Date Entry from Calander Control

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sydious - 13 Aug 2006 20:11 GMT

If I add an activeX Calander to my form, How do you link it so the Date field
gets filled if they click the calander control for the given date?

Also if I was using the calander control to be part of a Control Panel and
select a date on the calander for the form to look up the data for that date?

any help?

Reply to this Message

Arvin Meyer [MVP] - 13 Aug 2006 21:03 GMT

> If I add an activeX Calander to my form, How do you link it so the Date
> field
> gets filled if they click the calander control for the given date?

Have a look at:

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

> Also if I was using the calander control to be part of a Control Panel and
> select a date on the calander for the form to look up the data for that
> date?

You can use date textbox controls with a popup calendar on a dialog form to
lookup data in a query:

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

Select * From MyTable Where DateField = Forms!frmDialog!txtStartDate

Signature

Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

Reply to this Message