How do I add a calendar drop-down in Access?

I have a table to track compliance issues in which there are 3 dates (date
issue received, date started, date closed). I would like to use drop-down
calendars for each of these fields. Is this possible? If so, please explain
in the simplest of terms since I have not used Access in this way before.

Thank you so much!

Look at:

http://www.fontstuff.com/access/acctut09.htm

and/or

http://www.mvps.org/access/forms/frm0057.htm

or

http://allenbrowne.com/ser-51.html

or my favorite-

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

-Ed


"Angela" wrote in message
...
I have a table to track compliance issues in which there are 3 dates (date
issue received, date started, date closed). I would like to use drop-down
calendars for each of these fields. Is this possible? If so, please
explain
in the simplest of terms since I have not used Access in this way before.

Thank you so much!

Can recommend http/www.lebans.com/monthcalendar.htm even I was able to set it
up by following the destructions.

"Ed Robichaud" wrote:

Look at:

http://www.fontstuff.com/access/acctut09.htm

and/or

http://www.mvps.org/access/forms/frm0057.htm

or

http://allenbrowne.com/ser-51.html

or my favorite-

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

-Ed


"Angela" wrote in message
...
I have a table to track compliance issues in which there are 3 dates (date
issue received, date started, date closed). I would like to use drop-down
calendars for each of these fields. Is this possible? If so, please
explain
in the simplest of terms since I have not used Access in this way before.

Thank you so much!

When designing your form, from the menu click INSERT ActiveX Control.
Scroll down the list of available controls and see if you can find the
Microsoft Date and Time Picker control. When you insert this into the
document it gives you a combo box like object that defaults to the current
date and when clicked displays a calendar page of the current month.

This ActiveX control is version dependent and I believe it first showed up
in Access 2000. If you have Access 2000 and it is not in the list it needs
to be installed.

--
Kevin Backmann


"Ed Robichaud" wrote:

Look at:

http://www.fontstuff.com/access/acctut09.htm

and/or

http://www.mvps.org/access/forms/frm0057.htm

or

http://allenbrowne.com/ser-51.html

or my favorite-

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

-Ed


"Angela" wrote in message
...
I have a table to track compliance issues in which there are 3 dates (date
issue received, date started, date closed). I would like to use drop-down
calendars for each of these fields. Is this possible? If so, please
explain
in the simplest of terms since I have not used Access in this way before.

Thank you so much!

Thanks. I'll check these out.

"Ed Robichaud" wrote:

Look at:

http://www.fontstuff.com/access/acctut09.htm

and/or

http://www.mvps.org/access/forms/frm0057.htm

or

http://allenbrowne.com/ser-51.html

or my favorite-

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

-Ed


"Angela" wrote in message
...
I have a table to track compliance issues in which there are 3 dates (date
issue received, date started, date closed). I would like to use drop-down
calendars for each of these fields. Is this possible? If so, please
explain
in the simplest of terms since I have not used Access in this way before.

Thank you so much!

Thank you. I'll try it.

"MikeJohnB" wrote:

Can recommend http/www.lebans.com/monthcalendar.htm even I was able to set it
up by following the destructions.

"Ed Robichaud" wrote:

Look at:

http://www.fontstuff.com/access/acctut09.htm

and/or

http://www.mvps.org/access/forms/frm0057.htm

or

http://allenbrowne.com/ser-51.html

or my favorite-

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

-Ed


"Angela" wrote in message
...
I have a table to track compliance issues in which there are 3 dates (date
issue received, date started, date closed). I would like to use drop-down
calendars for each of these fields. Is this possible? If so, please
explain
in the simplest of terms since I have not used Access in this way before.

Thank you so much!

Well, I've tried this site and followed the instructions (more like you said
"DEstructions"). I got all kinds of Compile errors. I don't know enough
about coding to know what they mean or what to do about them.

"MikeJohnB" wrote:

Can recommend http/www.lebans.com/monthcalendar.htm even I was able to set it
up by following the destructions.

"Ed Robichaud" wrote:

Look at:

http://www.fontstuff.com/access/acctut09.htm

and/or

http://www.mvps.org/access/forms/frm0057.htm

or

http://allenbrowne.com/ser-51.html

or my favorite-

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

-Ed


"Angela" wrote in message
...
I have a table to track compliance issues in which there are 3 dates (date
issue received, date started, date closed). I would like to use drop-down
calendars for each of these fields. Is this possible? If so, please
explain
in the simplest of terms since I have not used Access in this way before.

Thank you so much!

I have continued to try this. I can't get past a "Compile Error: Ambiguous
name deteced: DialogFont". I've made several attempts to fix this, but I
just can't figure it out. Can you help with this?

thanks

"MikeJohnB" wrote:

Can recommend http/www.lebans.com/monthcalendar.htm even I was able to set it
up by following the destructions.

"Ed Robichaud" wrote:

Look at:

http://www.fontstuff.com/access/acctut09.htm

and/or

http://www.mvps.org/access/forms/frm0057.htm

or

http://allenbrowne.com/ser-51.html

or my favorite-

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

-Ed


"Angela" wrote in message
...
I have a table to track compliance issues in which there are 3 dates (date
issue received, date started, date closed). I would like to use drop-down
calendars for each of these fields. Is this possible? If so, please
explain
in the simplest of terms since I have not used Access in this way before.

Thank you so much!

Angela, I am really sorry, I have used Steven Lebans solutions on many
occasions but this was not one of them so I applogise for misdirecting you.

In fact the solution I used for this item was by Allen Browne
http://allenbrowne.com/ser-51.html

With his solution you download the caledar form and buttons. You simply copy
the calendar form to your forms area and copy the sample button to your form
where you place it next to the control where you want to enter the date. You
change the OnClick event to reflect your controls name.

=CalendarFor([Date_of_Enquiry],"Set the Enquiry Date")

(My controls name is [Date_of_Enquiry] as you can see above, the text in
quotes is a comment for notes)

Then when you select the date on the Calendar, it pops the date selected
straight into the control on your form. Copy the button as many time as you
have date fields and just change the on click event to the new field name.

I'm really sorry if you have had problems, in future I will either check
first or keep my mouth shut. Hope I have now put the record straight and
helped you?

Regards

Mike

"Angela" wrote:

I have continued to try this. I can't get past a "Compile Error: Ambiguous
name deteced: DialogFont". I've made several attempts to fix this, but I
just can't figure it out. Can you help with this?

thanks

"MikeJohnB" wrote:

Can recommend http/www.lebans.com/monthcalendar.htm even I was able to set it
up by following the destructions.

"Ed Robichaud" wrote:

Look at:

http://www.fontstuff.com/access/acctut09.htm

and/or

http://www.mvps.org/access/forms/frm0057.htm

or

http://allenbrowne.com/ser-51.html

or my favorite-

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

-Ed


"Angela" wrote in message
...
I have a table to track compliance issues in which there are 3 dates (date
issue received, date started, date closed). I would like to use drop-down
calendars for each of these fields. Is this possible? If so, please
explain
in the simplest of terms since I have not used Access in this way before.

Thank you so much!

OK. I'm feeling like a total idiot! I was able to get the 1st step to work,
but I'm having trouble getting the second step to work.

"Copy the calendar button from the sample form onto your form. (There are
two styles to choose from.)"

I tried to copy it, but didn't get a "paste" option when I tried. Is there
something I'm missing here?

Thanks for your help (and patience).


"MikeJohnB" wrote:

Angela, I am really sorry, I have used Steven Lebans solutions on many
occasions but this was not one of them so I applogise for misdirecting you.

In fact the solution I used for this item was by Allen Browne
http://allenbrowne.com/ser-51.html

With his solution you download the caledar form and buttons. You simply copy
the calendar form to your forms area and copy the sample button to your form
where you place it next to the control where you want to enter the date. You
change the OnClick event to reflect your controls name.

=CalendarFor([Date_of_Enquiry],"Set the Enquiry Date")

(My controls name is [Date_of_Enquiry] as you can see above, the text in
quotes is a comment for notes)

Then when you select the date on the Calendar, it pops the date selected
straight into the control on your form. Copy the button as many time as you
have date fields and just change the on click event to the new field name.

I'm really sorry if you have had problems, in future I will either check
first or keep my mouth shut. Hope I have now put the record straight and
helped you?

Regards

Mike

"Angela" wrote:

I have continued to try this. I can't get past a "Compile Error: Ambiguous
name deteced: DialogFont". I've made several attempts to fix this, but I
just can't figure it out. Can you help with this?

thanks

"MikeJohnB" wrote:

Can recommend http/www.lebans.com/monthcalendar.htm even I was able to set it
up by following the destructions.

"Ed Robichaud" wrote:

Look at:

http://www.fontstuff.com/access/acctut09.htm

and/or

http://www.mvps.org/access/forms/frm0057.htm

or

http://allenbrowne.com/ser-51.html

or my favorite-

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

-Ed


"Angela" wrote in message
...
I have a table to track compliance issues in which there are 3 dates (date
issue received, date started, date closed). I would like to use drop-down
calendars for each of these fields. Is this possible? If so, please
explain
in the simplest of terms since I have not used Access in this way before.

Thank you so much!