Calendar control

[Dave Hookings]

Access 2007 in Vista.
I need a calendar control on a form to update a table. The supplied calendar
control only advances a month at a time, per click. As the dates I will be
entering could be 2012 or later that is not practical. I found mscal with the
Active X tool, and that layout is what I want, but it won't work. When the
form opens I get an error message for the on load expression about not
communicating with an active X. (why, oh why, will microsoft not let us copy
error messages??)
I've checked references and it appears to be referenced ok.
I tried to use a form mentioned in here but got error messages regarding
undeclared variables.
This should be a simple procedure, but it has taken me hours.
Any help would be much appreciated.

Dave Hookings

 

[Allen Browne]

Here's one:
http://allenbrowne.com/ser-51.html

It's just a little Access form (so doesn't have the problems of an ActiveX
control), and has a way to advance the year.

 

[Arvin Meyer [MVP]]

In addition to Allen's. I have one at:

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

and Stephen Lebans has one at:
http://www.lebans.com/monthcalendar.htm

BTW, you can copy most error messages using Ctrl + C and paste them into
notepad. SnagIt, or other screen capture utilities let you copy the message
exactly as it appears:

http://www.techsmith.com/screen-capture.asp

 

[Dave Hookings]

Thanks for that (and thanks to Allen)
Would you believe it? After posting that I deleted the control from my form,
shut down Access, restarted and put the MSCAL control on the form - now it
worked!
I did copy the MSCAL files from programme files to system32 before
reopening. Maybe that did it.
Regarding the copying of error messages. I tried to highlight the message
using the mouse and nothing happened, so I assumed that ctrl + C would not
know what to copy. I do, of course, have the snipping tool in Vista, which I
will use next time, as long as I can post a bitmap in a message.

Thanks again

Dave