By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,921 Members | 1,305 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,921 IT Pros & Developers. It's quick & easy.

How to use calendar control?

P: n/a
Using Access 2002 and VBA.

1) How can I "attach" a calendar control to a combo box?
(or is there a correct way to show a calendar control?)

2) Once the date is clicked, how can I get the value of the date?

Thanks,
Bubbles
Aug 4 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
In short, don't. The ActiveX calendar control that distributes with Access
has several shortcomings, e.g. your application tends to break when used in
a different version of Access (which you will do in the future.)

To avoid the problems, just use a little Access form that looks like a
calendar. There's heaps of free ones on the 'net, e.g. here's one you can
download and import:
http://allenbrowne.com/ser-51.html
If you want something more, follow the link on that page to Stephen Lebans'.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"bubbles" <bu*********@hotmail.comwrote in message
news:f5**********************************@h17g2000 prg.googlegroups.com...
Using Access 2002 and VBA.

1) How can I "attach" a calendar control to a combo box?
(or is there a correct way to show a calendar control?)

2) Once the date is clicked, how can I get the value of the date?

Thanks,
Bubbles
Aug 4 '08 #2

P: n/a
Merci! I'll check it out.

On Aug 4, 10:45*am, "Allen Browne" <AllenBro...@SeeSig.Invalidwrote:
In short, don't. The ActiveX calendar control that distributes with Access
has several shortcomings, e.g. your application tends to break when used in
a different version of Access (which you will do in the future.)

To avoid the problems, just use a little Access form that looks like a
calendar. There's heaps of free ones on the 'net, e.g. here's one you can
download and import:
* *http://allenbrowne.com/ser-51.html
If you want something more, follow the link on that page to Stephen Lebans'.

--
Allen Browne - Microsoft MVP. *Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
Aug 4 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.