I am trying to get a calendar drop down box to connect to three date fields that I have in a form. When I am in form design view I can insert an AxDate Control with the drop down calendar. The thing I can't figure out is how to connect it to my three date fields, "order date","ship date" and "receive date" to the calendar. I would think that I put the name of each field in the control source, however that option does not seem to be available in the properties. If anyone can help please do so. Thank you.
Calendar in Access
- Thread starter tjr222
- Start date
DES
Technoweenie
- Local time
- Yesterday, 22:23
- Joined
- Apr 17, 2001
- Messages
- 245
DTPicker
I am assuming you are using the Date Time Picker. Normally you would use three separate controls, one for each of the date fields and then assign their control source in the properties.
It would be possible to change the control source through code after a given event occures to be able to use one control and three control sources.
If you have problems with coding then you might best be using the three controls.
I am assuming you are using the Date Time Picker. Normally you would use three separate controls, one for each of the date fields and then assign their control source in the properties.
It would be possible to change the control source through code after a given event occures to be able to use one control and three control sources.
If you have problems with coding then you might best be using the three controls.
Thanks for the reply DES. I should have been more clear in my first message, having a seperate control for each date field is fine. The drop down date calendar I am using is called AxDate Control. The problem is however the control source is not available in the properties, so I cannot enter in the date field that I want to be controled by the drop down calendar. If you have any other way for me to do this please let me know. Thanks again.
DES
Technoweenie
- Local time
- Yesterday, 22:23
- Joined
- Apr 17, 2001
- Messages
- 245
DTPicker
Look for other controls on the controls toolbar and see if you have the Microsoft Date and Time Picker there? If you do use that one - it will give you what you need!
Though it may be a little quirky to get running. I have a sample if you would like it for the DTPicker.
Look for other controls on the controls toolbar and see if you have the Microsoft Date and Time Picker there? If you do use that one - it will give you what you need!
Though it may be a little quirky to get running. I have a sample if you would like it for the DTPicker.
