Calendar

[Frank]

How can I auto fill a "Date field" when some one filling out a form selects
the date from a calendar

 

[Daniel Pineault]

See http://www.devhut.net/index.php?lang=en&pid=0000000004#datepick for 2
very good calendar options. Each explains how-to setup and use them.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Richard]

Another option
http://www.datapigtechnologies.com/flashfiles/clndrcontrol.html

 

[Daniel Pineault]

You can use ActiveX control, but they are not recommended. Actually whenever
possible they are to be avoided as they can lead to versioning issues...

So my original post still stands. Use either Stephen or Allen's calendar as
they as reliable (no versioning issues) and easy to setup and use.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Arvin Meyer [MVP]]

I agree. ActiveX controls can be problematic, especially between versions.
If there are other alternatives, I'd recommend using them. In addition to
Stephen's calendar, which is API based, and Allen's calendar, based on a
form. There is a form based calendar which has been working (with
conversion, as necessary) in every version of Access beginning with Access
2.0 and continuing through the Access 2010 beta:

http://www.datastrat.com/Download/Calendar2K.zip

There are also several calendars at the Access Web.