Dropdowns for dates

[Bob]

Is there any way that dates can be formatted so that they
can be used in dropdown fashion? I am creating a time
management database and want to avoid tying in the same
date 6-10 times for every different task code.

 

[Jeff Conrad]

Lots of options for you on calendars.

This is my personal favorite from Sensei Stephen Lebans:
I HIGHLY RECOMMEND IT!!
Instructions included on the site.

http://www.lebans.com/monthcalendar.htm

You can use the Calendar ActiveX Control that ships with
your Access program. You'll find it under your ActiveX Controls
list. To help you see how this works I suggest you go to Arvin
Meyer's site and download a couple of his sample databases
that demonstrate how to use the calendar.

http://www.datastrat.com/Download2.html

If that doesn't work I would suggest this one:

http://www.lebans.com/monthcalendar.htm

You may also want to check Tony Toews' site which
lists many calendar options including using forms and
even an API solution. You can find that here:

http://www.granite.ab.ca/access/calendars.htm

You may also want to consider this one:

http://www.lebans.com/monthcalendar.htm

MVP Allen Browne has some ready made calendar
forms you can download here:

http://members.iinet.net.au/~allenbrowne/ser-51.html

A friend told me about this one:

http://www.lebans.com/monthcalendar.htm

Here is a cool one in French with a slick clock as well:

http://www.logicielappui.com/tips/Acc2000_Calendar_Clock.zip

This one is in English:

http://www.lebans.com/monthcalendar.htm

You could also read this Microsoft KB article for some help:

ACC: How to Create a Pop-Up Calendar Control on a Form
http://support.microsoft.com/?id=190194

I recently stumbled across this one:

http://www.lebans.com/monthcalendar.htm

This link gives some step-by-step instructions:

http://www.techonthenet.com/access/forms/popup_cal.htm

I believe this one is fairly new:

http://www.lebans.com/monthcalendar.htm

Here's another one of interest:

http://www.byerley.net/AccessCalDemo.zip

If that one gives you trouble you may want to try this one:

http://www.lebans.com/monthcalendar.htm

The Access Developer's Handbook has a form-based
one included with the book/CD:

http://www.developershandbook.com

I've also heard some good things about this one:

http://www.lebans.com/monthcalendar.htm

This one might work just fine as well:

http://www.glump.net/content/accessdatepicker

This one was just recently passed on to me:

http://www.lebans.com/monthcalendar.htm

And last, but not least I would try this one:

http://www.lebans.com/monthcalendar.htm

(Can you say subliminal messages?)