Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 219
  • 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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