Date Feild & calendar

[Douglas J Steele]

Take a look at what Stephen Lebans has at
http://www.lebans.com/monthcalendar.htm

 

[Khalil Handal]

Hi,
Is there a way to have a calendar pop out when double click on a date feild
in a form so that the user will select the date intead of typing it.

Note:
I read in one of Excel news groupmessages that a right click on a cell in
Excel and then choose "insert date" from the menu that appears, then a
calendar appears and you can choose the desired date.

Can this or something similar be done with access.

Khalil

 

[Guest]

You could insert an Active X control to show a calendar.

This shows the calendar INSTEAD of the date field.

To insert an Active X Control on a form:

1) In design view, choose INSERT from the menu, the select ACTIVE X
CONTROL...

2) In the dialog box select CALENDAR CONTROL from the list, then click OK

3) In the Properties for the new calandar, go to the DATA tab to CONTROL
SOURCE. Enter the name of the date field you want to show.

You should now be able to see the date entered in the Date field showing on
the new calendar.

And for data entry, you will be able to use the calendar to select any Month
and Year and click the day you need.

Good Luck!

RRLady

 

[Khalil Handal]

Hi,
I have downloaded the file in the link you provide. It is dificult to work
with it if i'm entering a birthdate (i.e. 10/10/1940) year 1940 or any other
year.
Is there a way to allow to choose the year also? Or tou use a build in
calendar in access??

Khalil

 

[MARVA FLETCHER]

Take a look at what Stephen Lebans has at
http://www.lebans.com/monthcalendar.htm