Sabtu, 30 Juni 2012

Re: [belajar-access] Re: Tanya protect database pada sql server (*mdf)?

 

Begini, kalau teknik yang dipakai Mas Hariyanto tidak memakai Link Tables, jadi fitur2 access yg cukup "memanjakan" kita
user access tidak bisa dipakai terutama Query (lha gimana bikin query kalau tabelnya gak ada)
Teknik yang dipakai Mas Hariyanto kurang lebih seperti PHP dalam mengakses database...dari beberapa artikel yang saya baca
(..sekali lagi baru baca2, belum buktikan langsung..) teknik ini lebih oke dalam hal performance dan cocok sekali untuk multi user.
Bagi yang terbiasa dengan access memang teknik ini boleh dibilang "sulit".
Sebenarnya DSN Less memang untuk me-Link Tables tapi tidak lewat Control Panel--admin. tools dll, tapi lewat VBA...
nah saya juga baru mau belajar ttg DSN Less, monggo kita belajar bareng...ini saya punya link bagus :

http://www.accessmvp.com/djsteele/DSNLessLinks.html

atau secara global di google :

http://www.google.co.id/#hl=id&sclient=psy-ab&q=ms+access+dsn-less&oq=ms+access-dsn+less&gs_l=hp.1.0.0i30l4.2253.9066.0.12676.18.14.0.4.4.1.331.2634.0j10j3j1.14.0...0.0.IrnOGGfNOfA&pbx=1&bav=on.2,or.r_gc.r_pw.r_qf.,cf.osb&fp=d9fc77ef60d7bc93&biw=1366&bih=574

tapi saya juga tertarik dengan metode Mas Hari, dan sangat berguna saya pikir kalo dua metode itu digabungkan...

Regards
Hendra


From: adi_srpd <adi_srpd@yahoo.co.id>
To: belajar-access@yahoogroups.com
Sent: Saturday, June 30, 2012 11:58 AM
Subject: [belajar-access] Re: Tanya protect database pada sql server (*mdf)?

 
Trims buat mas Hendra & Mas Hariyanto,,

O iya mas, langkah ini apakah untuk membuat koneksi masih dengan LINK TABLE (DSN Less)? mohon dikoreksi jika saya salah pengertian.
saya masih belajar koneksi dengan link table, sama sekali belum paham koneksi langsung menggunakan ADO/DAO atau apa.
cuma yang saya inginkan koneksi link table tersebut tidak secara mudah bisa dilihat oleh orang lain seperti yang disampaikan mas hendra, koneksi dengan ODBC bisa dilihat dengan excel sekalipun.

Sekedar usul buat mas hariyanto, supaya thread ini bisa digunakan untuk semua anggota milis belajar access yang sedang belajar aplikasi client-server, bagaimana jika mas Hariyanto membuat tutorial bersambung seperti punya bang OPI itu (sql server express 1 sd 11), biar bisa dipandu dari awal (he3x..)

Semoga sharing ilmu dari mas hendra, mas hariyanto, mas elang dan master access yang lainnya (bang OPI, mas Aksan, Bang Haer, bang Edi Wiyono dll) dicatat sebagai amal dan mendapat balasan dari Allah SWT,, Amien..

Salam Access

Adi

--- In belajar-access@yahoogroups.com, hari yanto <har_i20002000@...> wrote:
>
> Bismillahirohmanirohim..
>  
> Langkah awal yang penting adalah manajemen user. Kita harus membuat beberapa user untuk kepentingan berbeda-beda.
>  
> Dengan asumsi memakai database MySql dan menggunakan sqlyog, mari kita mulai.
>  
> Add user (icon gambar orang). Isi userName dengan hen. Host % (maksudnya nama komputer siapapun bisa mengakses, kalau mau membatasi bisa diberi nilai disini). Password: hen type password: hen. Global Priveleges biarkan tidak tercentang semua (untuk mengetahui apa dampaknya).
>
> Lalu, melalui icon gambar orang, klik manage Pemision. Pada combo box username pilih yang telah kita buat (hen@%). Pada database, kita diberi kewenangan penuh untuk memilih. Kalau pakai username hen, dia diperbolehkan mengakses database apa. Misal, kita pilih database test. Maka, uraian tabel akan berubah sesuai isi database. Misal, kita pilih tabel users hanya melihat saja (select). Kalau lebih detail lagi, batasi kolom mana yang boleh dilihat. Misal kita pilih first_name. Lalu klik apply.
>
> Untuk menguji dan melihat apa dan  bagaimana dampak manajemen user yang telah kita buat, klik file > new connection > Klik New, isi dengan hen > OK > isi host dengan localhost > username: hen > password: hen. Conect dan simpan.
>  
> Lihat dampaknya. Kalau memakai username hen dan password hen, ternyata hanya bisa membuka tabel test. Itupun dengan batasan hak akses hanya melihat. Tidak bisa mengedit. Menghapus. Dlsb.
>  
>  
> Semoga bisa membantu dan memberi semangat.
>  
> Hariyanto (Surabaya)
> http://110.139.57.19
>
>
> --- On Fri, 29/6/12, Hendra Agestha Hamid <the_agestha@...> wrote:
>
>
> From: Hendra Agestha Hamid <the_agestha@...>
> Subject: Re: [belajar-access] Re: Tanya protect database pada sql server (*mdf)?
> To: "belajar-access@yahoogroups.com" <belajar-access@yahoogroups.com>
> Date: Friday, 29 June, 2012, 1:26 PM
>
>
>
>  
>
>
>
>
>
> betul sekali mas...dan kebetulan sekali pakarnya sedang ngeluarin thread di sini ttg itu...Mas Hari Yanto...
> ayo kita sama2 belajar dengan beliau, saya juga baru mau belajar mas...mudah2an dengan belajar bersama
> kita bisa sama2 "tabah"...
> regards
> Hendra
>
>
>
>
>
>
>
> From: adi_srpd <adi_srpd@...>
> To: belajar-access@yahoogroups.com
> Sent: Friday, June 29, 2012 11:51 AM
> Subject: [belajar-access] Re: Tanya protect database pada sql server (*mdf)?
>
>
>
>  
>
> Terima kasih mas Elang & Mas Hendra atas penjelasannya,,
>
> -Kira-kira contoh "Connection String" metode DSN-Less seperti apa ya?
>
> -Apakah itu berarti koneksi via VBA, bukan lewat control panel- Administratif Tool dst.., gitu ya mas?
>
> Terimakasih atas pencerahan rekan-rekan belajar access semuanya..
>
> --- In belajar-access@yahoogroups.com, Hendra Agestha Hamid <the_agestha@> wrote:
> >
> > Dear mas Adi,,
> > Dari yang saya tau, jika mas menggunakan Link Table-ODBC tidak ada cara untuk mengamankannya,..
> > Dengan excel sekalipun data di DSN bisa dicuri dengan sangat mudah,...tinggal cari DSN -- import.
> > Satu-satunya cara agar aman adalah dengan metode DSN-Less, jadi hubungan dengan Database dengan "Connection String"
> > yang dibuat di modul di FE Access...
> > Regards
> > Hendra
> >
> >
> >
> > ________________________________
> > From: adi_srpd <adi_srpd@>
> > To: belajar-access@yahoogroups.com
> > Sent: Thursday, June 28, 2012 8:59 AM
> > Subject: [belajar-access] Tanya protect database pada sql server (*mdf)?
> >
> >
> >  
> > Dear All,,
> >
> > Saya sedang belajar link tabel access - sql server via ODBC menggunakan SQL Server 2005 Express edition.
> > Nah yang saya tanyakan bagaimana membuat password database (*mdf) tersebut seperti halnya pada ms access, saya cari menunya kok tidak ada ya?
> > Jika memang tidak disediakan menu password database, bagaimana cara pengamanannya agar tidak bisa dibuka oleh sembarang orang?
> >
> > Terimakasih atas bantuan rekan-rekan semua,,
> >
>



__._,_.___
Recent Activity:
SPAM IS PROHIBITED
.

__,_._,___

[belajar-access] Icon berkedip

 

Mohon pencerahan para master.
Saya sedangan membuat sebuah aplikasi yang berfungsi sebagai alaram. jadi jika ada data yang masuk pada sebuah tabel yang ditentukan maka aplikasi access ini akan memberitahukan kepada user kalau ada data baru yang masuk dengan sebuah musih dan tampilan form informasi.
Pertanyaan saya, bagaimana caranya untuk membuat icon ms access bisa berkedip sehingga selain suara musik user juga diberikan tanda dengan berkedipnya icon ms access tersebut. sebab kalau hanya dengan musik susahnya jika soundnya dimatikan maka bisa dipastikan user tidak akan tau kalau ada data baru masuk.

terima kasih pencerahannya

__._,_.___
Recent Activity:
SPAM IS PROHIBITED
.

__,_._,___

[MS_AccessPros] Checking Grade level

 

Clive,
I have looked at your proposal. I would like to have a combo box on the previous form where the user enters the time and date and other information for the event.

The flow of the forms would be so much better if I could get this combo box to work.

The problem is that the previous form is a continuous form and when I put a unbound combo box on a continuous form it changes for all the records when I change it for one record. Any way around that? There is no field in the underlying query or table that could hold this grade level data. I suppose I could add a field to the table just to hold the data for the grade combo box but that just does not seem like the right answer.

From my reading I have not found a good way to do this.

Thanks for your help.
Bill

Hi Bill,

On the main form you should have a ComboBox or a ListBox
or some other arrangement for selecting the GradeLevel.

Then you should filter the SubForm should for the selected
level only. That way you get what you want.

Hope that helps.

By the way, it may be better to resubmit this problem
because it might get missed becauseit is tangled up with
Msg 99639: "Drop Down Selection in Read Only".

Regards, Clive.

--- In MS_Access_Professionals@yahoogroups.com, "Bill Singer" <Bill.Singer@...>
wrote:
>
> This group has helped me capture some errors by checking if a field is null
> or if a time period is already booked. I have one more check to do but I
> can't figure it out and I do not believe the function will be the same as
> the previous checks.
>
>
>
> I have a main form to schedule events (sports games)
>
> I have a continuous sub form that I use to select TEAMS that will
> participate in that event. A One to many relationship. (one event to many
> teams)
>
>
>
> Each team name selected in the sub form is also tied to a specific grade
> level in the t_Teams. (table with team names) The grade level also shows in
> the combo box but the bound column is just an ID number.
>
>
>
> Is there a way to check to make sure I am always scheduling 5th graders to
> play 5th graders and 10th graders to play 10th graders.
>
>
>
> I am thinking I will have to search the t_Eventparticipants for team names
> associated with the EventParticipantID that is currently on the form and
> then check the t_Names to see if they have the same grade level associated
> with the team. (GraID in t_Teams)
>
>
>
> I really have no idea how to structure this or what function to use.

__._,_.___
Recent Activity:
.

__,_._,___

Bls: [belajar-access] Menunjukan personel yang belum mengikuti training [1 Attachment]

 
[Attachment(s) from GALIH PERSADHA included below]


coba pake queri dengan kriteria adalah kdkaryawan yang tidak ada di dalam tabel koneksitraining dimana kdtraining = "kodeyang dipilih"

ini ada contoh
tapi maaf tampilannya jelek banget.
semoga membantu


Dari: Airlangga 8humintara Amitaba <cgsatu@yahoo.com>
Kepada: belajar-access@yahoogroups.com
Dikirim: Sabtu, 30 Juni 2012 9:41
Judul: RE: [belajar-access] Menunjukan personel yang belum mengikuti training

 
Selamat pagi :),

Saya pikir ( minta maaf) cukup dua tabel saja.

Tabel connector karyawan dan training kok saya pikir malah buat lebih rumit.

Jadi tabel karyawan ( menurut anggapan saya ) berisi identitas karyawan.

Tabel training, berisi training yang diikuti karyawan, plus tanggal pelatihan.

Hubungkan dua tabel tersebut menggunakan IDpegawai ( PK tabel pegawai )

Nah, sekarang bagaimana tahu karyawan yang belum ikut pelatihan? Mudah :) buat sebuah query, dimana karyawan belum " terdaftar" dalam tabel training

Kelihatan deh, siapa yang belum ikut pelatihan :)

Cgsatu ( Elang )

Sent from my Sony Ericsson Aspen™



From: fhuladaq <fhuladaq@yahoo.co.id>
Sent: Friday, June 29, 2012 10:17 PM
To: belajar-access@yahoogroups.com
Subject: [belajar-access] Menunjukan personel yang belum mengikuti training

 
Selamat malam all Master MS Access ...
Saya sedang belajar membuat applikasi menggunakan access tapi saya bingung untuk menunjukan data karyawan yang belum mengikuti training.

Sebagai gambarannya:

1. Tabel Karyawan
2. Tabel Training
3. Tabel Connector Karyawan dan training

Untuk menunjukan data Karyawan yang sudah mengikuti training bisa tapi
saya ingin membuat supaya pada saat data 1 jenis training di panggil dapat menampilkan data karyawan yang belum mengikuti training tersebut.

Mohon bantuannya kepada para master untuk memberikan petunjuk dan pencerahannya...

Sebelumnya saya ucapkan terimakasih untuk bantuan para master....



[The entire original message is not included]


__._,_.___

Attachment(s) from GALIH PERSADHA

1 of 1 File(s)

Recent Activity:
SPAM IS PROHIBITED
.

__,_._,___

[MS_AccessPros] Primary Key

 

I just had a problem that I have never had before. One of my tables changed the Primary Key field, that is it remove the property. This cause 5 of my forms to not accept data. As soon as I made the field a Primary Key again everything worked fine. I am using Access 2010, but the tables (that is the backend) were created in Access 2003. Has this happened to anyone else? And what could cause such a thing to happen?
Thanks,
Darwin

__._,_.___
Recent Activity:
.

__,_._,___

[MS_AccessPros] Re: How to open a continuous form with a certain order using order by

 

I would try:
Me.OrderBy = Me.OpenArgs
Me.OrderByOn = True

Duane Hookom
MS Access MVP

--- In MS_Access_Professionals@yahoogroups.com, mrsgoudge <no_reply@...> wrote:
>
> Duane, If there are two replies this one has more info--my original post is not showing up. Sorry for not giving enough info. The correct records are showing but they are not ordered by City. (I entered City into the Ordr1 spot to simplify.) debug.Print is awesome--first time I've used it! It gives City. I'm not at work right now but I'm pretty sure that Me.OpenArgs when I hovered over it showed City too.
>
> Thanks!
> Connie
>
> --- In MS_Access_Professionals@yahoogroups.com, "Duane" <duanehookom@> wrote:
> >
> > Connie,
> > You didn't tell us if this works or not. We assume not, but don't have a clue what you are getting for results.
> >
> > You also have a debug.Print (great!) but don't tell us the results.
> >
> > It seems you have asked enough questions here that you should be getting the hang of providing the significant information so someone can more easily provide some help.
> >
> > Duane Hookom
> > MS Access MVP
> >
> > --- In MS_Access_Professionals@yahoogroups.com, mrsgoudge <no_reply@> wrote:
> > >
> > > Hi all!
> > >
> > > I've been working on opening another form with the records filtered and ordered based upon entries unbound boxes in the 1st form. The filtering is working beautifully thanks to John's help eons ago!
> > >
> > > Now I'm trying to have similar unbound boxes that will determine the order of the records. I've created comboboxes where column 0 (width = 0) has the same name as the field in the form.
> > >
> > > I've but the code for the ordering below. Also since I used OpenArgs I put what the code for that from the 2nd form (the one being opened).
> > >
> > > Thanks again!
> > > Connie
> > >
> > > Code from first form "LookingEvents" where a button is clicked to open Search_AllListings from with filtered and ordered records:
> > >
> > > 'Create OrderBy string to be used in the OpenArgs and then in Form Open
> > > If Nz(ordr1) <> 0 Then
> > > strOrder = strOrder & [ordr1].Column(0) & ", "
> > > End If
> > > If Nz(Ordr2) <> 0 Then
> > > strOrder = strOrder & [Ordr2].Column(0) & ", "
> > > End If
> > > If Nz(Ordr3) <> 0 Then
> > > strOrder = strOrder & [Ordr3].Column(0) & ", "
> > > End If
> > >
> > > 'See if the string has more than 2 characters (a trailng ", ") to remove message
> > > lngLen2 = Len(strOrder) - 2
> > > If lngLen2 <= 0 Then
> > > MsgBox "No criteria have been entered"
> > > Else 'Yep: there is something there, so remove the " AND " at the end.
> > > strOrder = Left$(strOrder, lngLen2)
> > > End If
> > >
> > > 'For debugging, remove the leading quote on the next line. Prints to Immediate Window (Ctrl+G).
> > > 'Debug.Print strOrder
> > > 'Open form with where and Order statement
> > > DoCmd.OpenForm "Search_AllListings", , , strWhere, , , strOrder
> > >
> > > Code from Search_AllListings form:
> > > Dim strOrder As String
> > > If Not IsNull(OpenArgs) Then
> > > Me.OrderBy = Me.OpenArgs
> > > If Me.OrderByOnLoad = False Then
> > > Me.OrderByOnLoad = True
> > > End If
> > > End If
> > >
> >
>

__._,_.___
Recent Activity:
.

__,_._,___

Re: [belajar-access] Membuat Update Harga

 

Redaksionalnya suhu luar biasa.
Terpola,rinci dan detail.
Regards

On 1 Jul 2012 06:15, "privat access" <les.access@gmail.com> wrote:
 

Dari permasalahan mas Ruchi sudah jelas bahwa detail penjualan menggunakan field harga_jual dari tabel daftar_harga (daftar_barang). sehingga apabila terjadi perubahan harga pada tabel master, maka akan berubahlah semua nilai harga pada transaksi yg telah lalu.

solusinya :

pada detail_penjualan, buatlah sebuah field harga_jual (harga, atau apalah namanya) yang berfungsi untuk mencatat harga transaksi penjualan (pd saat itu). sehingga jika terjadi perubahan harga pada tabel master daftar_harga (daftar_barang), maka nilai harga_jual pada tabel detail_penjualan TIDAK AKAN PERNAH BERUBAH.


salam,

Lusky Kurniawan

www.solusiaccess.com
www.facebook.com/SOLUSIACCESS.Indonesia
http://solusiaccess.wordpress.com



Pada 29 Juni 2012 21:08, Roland Tambunan <rolandtambunan@gmail.com> menulis:
 

Mas Ruchi,
Mungkin tabelnya bisa ditambahkan tabel harga tgl efektif, jadi idenya adalah ketika terjadi transaksi, maka harga yang berlaku adl sesuai dengan tabel harga tgl efektif.

Salam,
Roland



Powered by Telkomsel BlackBerry®

From: Ruchi Msaccess <ruchi_msaccess@yahoo.com>
Date: Fri, 29 Jun 2012 02:15:17 -0700 (PDT)
Subject: [belajar-access] Membuat Update Harga

 

Dear All,

Mohon masukannya,
Saya membuat aplikasi loundry untuk usaha saya sendiri,
databasenya adalah

Tabel 1 Daftar Harga
Tabel 2 Penjualan
Tabel 3 Penjualan Rinci
Tabel 4 Daftar Pelanggan


Selama ini aplikasi sudah berjalan efektif, namun per 27 Juni 2012 saya merubah harga untuk beberapa produk layanan loundry
Kendalanya adalah ketika harga saya rubah otomatis yang seharusnya menggunakan harga lama sebelum update jadi ikut berubah

Misalnya : 
Tgl 25 Juni 2012 harga per kilo 5.000
No kwitansi 0001 - 0010 total ada 60 Kilo jadi pada report 60 x 5.000 = 300.000

Ketika tanggal 27 Juni 2012 saya rubah menjadi 7.000
Report tgl 25 juga ikut berubah

Mohon masukan untuk memperbaiki ini

Terima Kasih
Masyruchi


__._,_.___
Recent Activity:
SPAM IS PROHIBITED
.

__,_._,___

Re: [MS_AccessPros] Crystal's New Date Picker 120627_230p

 

Hi Giorgio,

did you compile the code before you used the Popup Calendar?

what version of Access are you using?

'~~~~~~~~~ Compile ~~~~~~~~~
 
Whenever you change code or references, your should always compile before executing.
 
from the menu in a VBE (module) window: Debug, Compile
 
fix any errors on the yellow highlighted lines
 
keep compiling until nothing happens (this is good!)

Warm Regards,
Crystal

 *
   (: have an awesome day :)
 *

________________________________
From: giorgio_rovelli
Subject: Re: [MS_AccessPros] Crystal's New Date Picker 120627_230p


Hi Crystal, I've downloaded your PopupCalendar_Crystal_120627_230p.accdb
from
http://www.rogersaccesslibrary.com/forum/popup-calendar-for-access-2007-\
and-above_topic597.html

<http://www.rogersaccesslibrary.com/forum/popup-calendar-for-access-2007\
-and-above_topic597.html
>  but when I double-click the DateandTime1
text box on f_PopupCalendar_Test the f_PopupCalendar should open up
because of

Private Sub DateAndTime1_DblClick(Cancel As Integer)
    DoCmd.OpenForm "f_PopupCalendar"

End Sub

  but it doesn't, am I missing something?
  Giorgio

--- Crystal <strive4peace> wrote:
>
> Hi Clive,
>
> I posted another version shortly after the first ...
>
> PopupCalendar_Crystal_120627_ACCDB.zip
>
> there was an error if the form you are coming from did not have a
caption ...
>
>
> I made a page on RogersAccesLibrary with screen shots here:
>
> Popup Calendar
> by Crystal
> on RogersAccessLibrary
>
http://www.RogersAccessLibrary.com/forum/popup-calendar-for-access-2007-\
and-above_topic597.html

>
> I think I have the same version (now) posted in File>Crystal that is
on RogersAccessLibrary ...
>
> if you still have a problem with the latest one, please let me know!
>
> ~~~
>
> > "The first DoubleClick to any of the six controls appears to
> do nothing."
>
> there is no double-click event ... everything is a command button and
uses the CLICK event
>
>
> > "The only way to close the two forms"
>
> you can close the popup form like this:
> 1. right-click on the TitleBar and choose --> Design View
> 2. then you can close it
>
> the CANCEL button doesn't work?
>
> did you compile and save the code before you tested it?
>
>
> Warm Regards,
> Crystal
>
>  *
>    (: have an awesome day :)
>  *
>
>
> ________________________________
> From: Clive zctek@...
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Friday, June 29, 2012 3:31 PM
> Subject: [MS_AccessPros] Crystal's New Date Picker 120627_230p
>
> Hi Crystal, Giorgio,
>
> (I have raised this as a new thread because Giorgio's post
> is tangled with another thread and you may have missed it.)
>
> I have also had trouble with the New Calendar. After
> opening the DB in Access2007.
>
> The first DoubleClick to any of the six controls appears to
> do nothing.
> The second DoubleClick appears to do nothing but beep on
> each further DoubleClick. The only way to close the two forms,
> yes both are open, is to open the Debug Window and use
> Docmd.Close acForm,Forms(1).Name
> Docmd.Close acForm,Forms(0).Name
>
> I tried debugging it, by adding a line in the code for
f_PopupCalendar.FormOpen,
> after
> On Error Resume Next, I added
> MsgBox "Form_Open " & Me.Name
>
> and everything appeared to work OK.
>
> I removed the fix and the DB still worked OK.
>
> I restored the DB from the zip file and it failed
> as before. I also checked that it was compiled OK
> before opening any forms.
>
> I guess this is going to be a weird one to chase.
>
> Regards, Clive.
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Giorgio's Post:
> > [MS_AccessPros] Re: Calendar -- Popup Calendar posted
>
> > Hi Crystal, I've downloaded your
> > PopupCalendar_Crystal_120627_230p.accdb
> > but when I double-click the DateandTime1 text box on
> > f_PopupCalendar_Test the f_PopupCalendar should open
> > up because of
> >
> > Private Sub DateAndTime1_DblClick(Cancel As Integer)
> > '120627
> > DoCmd.OpenForm "f_PopupCalendar"
> > End Sub
> >
> > but it doesn't, am I missing something?
> >
> > Giorgio
>
>
>

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
.

__,_._,___

Re: [MS_AccessPros] Crystal's New Date Picker 120627_230p

 

you're welcome, Clive ;) thanks for letting me know

Warm Regards,
Crystal

http://www.AccessMVP.com/strive4peace

 *
   (: have an awesome day :)
 *

________________________________
From: Clive <zctek@aol.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Saturday, June 30, 2012 4:21 PM
Subject: Re: [MS_AccessPros] Crystal's New Date Picker 120627_230p

Thanks Crystal,

I downloaded the file again and it now works fine.

Regards, Clive.

--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> wrote:
>
> Hi Clive,
>
> I posted another version shortly after the first ...
>
> PopupCalendar_Crystal_120627_ACCDB.zip 
>
> there was an error if the form you are coming from did not have a caption ...
>
>
> I made a page on RogersAccesLibrary with screen shots here:
>
> Popup Calendar
> by Crystal
> on RogersAccessLibrary
> http://www.RogersAccessLibrary.com/forum/popup-calendar-for-access-2007-and-above_topic597.html
>
> I think I have the same version (now) posted in File>Crystal that is on RogersAccessLibrary ...
>
> if you still have a problem with the latest one, please let me know!
>
> ~~~
>
> > "The first DoubleClick to any of the six controls appears to
> do nothing."
>
> there is no double-click event ... everything is a command button and uses the CLICK event
>
>
> > "The only way to close the two forms"
>
> you can close the popup form like this:
> 1. right-click on the TitleBar and choose --> Design View
> 2. then you can close it
>
> the CANCEL button doesn't work?
>
> did you compile and save the code before you tested it? 
>
>
> Warm Regards,
> Crystal
>
>  *
>    (: have an awesome day :)
>  *
>
>
> ________________________________
>  From: Clive <zctek@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Friday, June 29, 2012 3:31 PM
> Subject: [MS_AccessPros] Crystal's New Date Picker 120627_230p

> Hi Crystal, Giorgio,
>
> (I have raised this as a new thread because Giorgio's post
> is tangled with another thread and you may have missed it.)
>
> I have also had trouble with the New Calendar. After
> opening the DB in Access2007.
>
> The first DoubleClick to any of the six controls appears to
> do nothing.
> The second DoubleClick appears to do nothing but beep on
> each further DoubleClick. The only way to close the two forms,
> yes both are open, is to open the Debug Window and use
> Docmd.Close acForm,Forms(1).Name
> Docmd.Close acForm,Forms(0).Name
>
> I tried debugging it, by adding a line in the code for f_PopupCalendar.FormOpen,
> after
> On Error Resume Next, I added
> MsgBox "Form_Open " & Me.Name
>
> and everything appeared to work OK.
>
> I removed the fix and the DB still worked OK.
>
> I restored the DB from the zip file and it failed
> as before. I also checked that it was compiled OK
> before opening any forms.
>
> I guess this is going to be a weird one to chase.
>
> Regards, Clive.
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Giorgio's Post:
> > [MS_AccessPros] Re: Calendar -- Popup Calendar posted
>
> > Hi Crystal, I've downloaded your
> > PopupCalendar_Crystal_120627_230p.accdb
> > but when I double-click the DateandTime1 text box on
> > f_PopupCalendar_Test the f_PopupCalendar should open
> > up because of
> >
> > Private Sub DateAndTime1_DblClick(Cancel As Integer)
> > '120627
> > DoCmd.OpenForm "f_PopupCalendar"
> > End Sub
> >
> > but it doesn't, am I missing something?
> >
> > Giorgio
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
> [Non-text portions of this message have been removed]
>

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
.

__,_._,___

RE: [MS_AccessPros] Erorr : Source Code Control Program

 

I was getting the same message and was going to ask the same question. How
do we turn it off? I didn't see anything.

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
Sent: Saturday, June 30, 2012 4:13 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Erorr : Source Code Control Program

Hendra

I think you can turn that off. It's an automatic warning once you install
the
dev tools.

Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT <http://thatlldoit.com/> http://thatlldoit.com
MS Access MVP
<https://mvp.support.microsoft.com/profile/Bill.Mosca>
https://mvp.support.microsoft.com/profile/Bill.Mosca

From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of
agesthahendra@ymail.com <mailto:agesthahendra%40ymail.com>
Sent: Saturday, June 30, 2012 11:49 AM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: [MS_AccessPros] Erorr : Source Code Control Program

Hi All..

After i installed Access Developer Extension on my Netbook that has
Access 2007 in there, there is a warning everytime i open every Access
file :
"You don't have a source code control program (Such Microsoft Visual
SourceSafe) installed on your machine. The Source code control
commands are therefore not available"
Any exlpanation would be very appreciated...thanks

Regards
Hendra

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
.

__,_._,___

RE: [MS_AccessPros] Erorr : Source Code Control Program

 

Hendra

I think you can turn that off. It's an automatic warning once you install the
dev tools.

Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT <http://thatlldoit.com/> http://thatlldoit.com
MS Access MVP
<https://mvp.support.microsoft.com/profile/Bill.Mosca>
https://mvp.support.microsoft.com/profile/Bill.Mosca

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of
agesthahendra@ymail.com
Sent: Saturday, June 30, 2012 11:49 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Erorr : Source Code Control Program

Hi All..

After i installed Access Developer Extension on my Netbook that has
Access 2007 in there, there is a warning everytime i open every Access
file :
"You don't have a source code control program (Such Microsoft Visual
SourceSafe) installed on your machine. The Source code control
commands are therefore not available"
Any exlpanation would be very appreciated...thanks

Regards
Hendra

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
.

__,_._,___