Calender / date control

[Denis]

I have a field called date . I want to have a drop down box which,
when you chick on it, will show a calendar. Upon selecting a date from
this calendar it will put the selected date in the “date” field. It is
a similar idea to what you see on travel websites when booking trips.

Any ideas. Thanks

Denis

[james.igoe@gmail.com]

Re: Calender / date control

- date field should be text box
- add calendar to form, partially covering text box, and set calendar
visible = no
- code the text boxc click event:
1. opens ocx calendar
2. if date not empty, sets date of box to calendar, else sets as
today
- code calendar click event
1. set text box data to value of calendar
2. hide calendar
- after code works, have calendar control completely cover text box -
users should not have the ability to enter values directly

James Igoe

http://vba.wikidot.com/

http://code.comparative-advantage.com/

On Jun 9, 10:50 am, Leslie Porter OHV



On Jun 11, 11:43 am, Denis <denisphe...@gm ail.comwrote:

I have a field called   date .  I want to have a drop down box which,
when you chick on it, will show a calendar. Upon selecting a date from
this calendar it will put the selected date in the “date” field. It is
a similar idea to what you see on travel websites when booking trips.
>
Any ideas. Thanks
>
Denis

[ARC]

Re: Calender / date control

In access 2007, date fields will automatically display a built-in calendar
button. Just fyi...


"Denis" <denisphelan@gm ail.comwrote in message
news:1a254529-2b45-4d18-8b23-cb961000d5d9@y3 8g2000hsy.googl egroups.com...
I have a field called date . I want to have a drop down box which,
when you chick on it, will show a calendar. Upon selecting a date from
this calendar it will put the selected date in the “date” field. It is
a similar idea to what you see on travel websites when booking trips.

Any ideas. Thanks

Denis

[Tony Toews [MVP]]

Re: Calender / date control

Denis <denisphelan@gm ail.comwrote:

>I have a field called date . I want to have a drop down box which,
>when you chick on it, will show a calendar. Upon selecting a date from
>this calendar it will put the selected date in the “date” field. It is
>a similar idea to what you see on travel websites when booking trips.

See the Calendar Tips page at my website

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

There could, likely will, be lots of version problems when you go to distribute the
MSCal.OCX..

One alternative is MonthCalendar is a completely API generated Month Calendar derived
directly from the Common Control DLL. There are links to several downloadable
calendar forms at my website. As these are forms you can also do anything with them
you want.

You can also use the calendar form which comes in the Access <insert your version
hereDevelopers Handbook by Litwin/Getz/Gilbert, publisher Sybex
www.developershandbook.com. These books are well worth spending money. Every time I
open one I save the price of the book.

Duane Hookum has an awesome and simple calendar in a report. See the Calendar
Reports sample section at http://www.access.hookom.net/Samples.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at

http://www.granite.ab.ca/accsmstr.htm

Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/