• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 223
  • Last Modified:

ActiveX Calendar 9.0 Access 2000

I'm looking for a good self help book or instruction sheet(basic-intermediate)on implementing ActiveX Calendar9.0  control in a form using Access 2000.

Specificly, I would like to be able to click on a date field and have the calender pop-up for that field, select the date from the calendar and then the calendar closes.

0
Neal_Mickley
Asked:
Neal_Mickley
1 Solution
 
AllenHareCommented:
Neal,

Can't let you know where to find a book but heres how you do the second part of you question.

1.Create a new form with only a Activex Calendar 9.0 object on it.

2.Then use the 'on enter' event property of your date field to open new calendar form.

3. Next in your calendar form design use the 'build event' option with your Calendar 9.0  object. This should give you the 'click event'

4. Here, just copy the calendar 9.0 value to your date field. eg
    Form1.Goal_Review_Date.Value = Cal.Value

'cal being the name of my calendar 9.0 object.'

5. Then add  DoCmd.Close to close the calendar form.

Done




   
0
 
amp072397Commented:
Answer force-accepted. Any problems with that, please post a reply here.

Thanks!
amp
Community Support Moderator
Experts Exchange
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now