Calender

[tonym29]

I am running office xp with access, I would like to include a drop down calender for entering dates, can anyone advise me how to do it.

Thanks Tony.

 

[fneily]

One way: GoTo Design view of your form. On the ToolBox toolbar, click on More Controls. Scroll down to Microsoft Date And Time Picker. Click on this and then draw a box on your form. You can go into VBA (ALT + F11), click on Tools, References and see if it was registered by seeing if there's a check next to Microsoft Windows Common Controls-2 6.0. Then you can program the On Updated event of the control to do whatever you want with the date.

 

[RJL1]

I have use this calendar method that I found a while back on the web. You can download the sample MDB that has the calendar code from :

http://www22.brinkster.com/accessory/forms/accm.zip

Take a look at the the code it is very easy.

Ricardo