How to add a pop up calendar to date field in a subform?

A

Access''03_NewUser

Greetings forum members,

It would be greatly appreciated if someone could advise me how to add a pop
up calendar to a date field in a subform.

Basically, what I want to happen (...or something close to this) is:
1. The user clicks inside the subform field,
2. A pop up calendar opens,
3. The user selects a date,
4. The user selected date is entered into the subform field, and
5. The pop up calendar closes.

Adding to the complexity, my subform is in (and must remain in) datasheet
view.

I am attempting to use the following code, from KB article #190194. This
code works fine for fields on my main form, but returns a run-time error 2110
when I try and use it on fields in my subform.

This address should take you to the article:
http://support.microsoft.com/kb/190194/en-us
 
O

Ofer Cohen

Have a look at this link on "Mini Calendar"

http://www.mvps.org/access/forms/frm0050.htm

Keep in mind that you cant show a button in the datasheet view, use the
DoubleClick event of the date text box to open the calendar.
If you get an error message, please post the message and the line of code
where the error occur.
 
A

Access''03_NewUser

Little help...

When I attempt to open the file 'MiniCalendar.mdb', I get a vbOK message
box, titled 'AVI Error', with the following message: "The driver cannot
recognize the specified command parameter."

I can't get past this error message to open the mdb. Any suggestions?
 
O

Ofer Cohen

Open the MDB while the shift key held down so the mdb while open without
running the main form.

You will be able to look at each form separetly
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top