Where is Calendar control in Access 2010?

Acke

Registered User.
Local time
Today, 06:29
Joined
Jul 1, 2006
Messages
158
I need to set calendar control as criteria for date in VBA query. I cannot find Calendar control in ActiveX tools in Acc 2010. Where is it?

Dare picker seams like very slick and simple solution but I can see it only in database. As it might be solution to my problem, can date picker be used on a form as criteria for VBA query?
 
Yes it can be used as Query criteria.. But make sure proper formatting is applied.. As there is possibility of Access getting confused with International Dates..

Thanks for quick reply! How can I make date picker available on the form? Which control in form design is used to activate the picker?
 
If the control is bounded to a field with Date/Time format then Access will automate show the Date Picker for that control when the control has the focus.
For unbounded control you must set the format property to Date (Property sheet)
 
Thanks guys, the simplest solutions are always the best. Date picker works perfect.

For the sake of subject, it might be useful to know where to find Calendar control in Access 2010 although I don't need it anymore. In case you agree, you could provide calendar control solution for other people who might need actual calendar.
 
Acke, the Calender control is a deprecated feature in Access 2010.. It is not available.. It has been replaced with Date/Time picker.. If you had the reference added in the Older version of the file, it might come up with Missing reference error..

If you do want actual Calender, best design it.. Or lookup on this MSDN link :
http://msdn.microsoft.com/en-us/library/gg251104%28v=office.14%29.aspx

Good Luck with your project.. :)
 

Users who are viewing this thread

Back
Top Bottom