How to use calendar control?

[bubbles]

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

[Allen Browne]

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

[bubbles]

Merci! I'll check it out.

On Aug 4, 10:45*am, "Allen Browne" <[e-mail]:

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.