Calendar, How to -Cool Tips for Beginners

[musicmaker]

How to Input a calendar into a form:

1. Make room on your form for the calendar. Approximately 2” X 5”.
2. Press the last item on the toolbar. (It looks like it has a hammer over a wrench, on it.)
3. Choose Calendar. (by clicking on calendar)
4. Place calendar on form. (See below, last line before continuing.)
5. Go to calendar properties and change [Name] to [SelectDate].
6. Make a command button.
7. On the button top, type [Input Default Date].
8. In Button properties, [Event], [On Click], type this code: Me.DefaultDate = SelectDate.Value
9. Open an unbound text box.
10. Change it’s [Name] to [DefaultDate] .
11. Choose your original [Date] text box properties.
12. Choose [Data] tab. Go to [Default Value…….], type the following: = [DefaultDate]

This code resets the calendar date to today's date: Calendar.Value = IIf(IsNull(cal), Date, cal.Value)


Directions:

1. Select a date.
2. Click on [Input Default Date] button.

This is ideal if you are posting items two or three days late.

If you just want a calendar on your form, Omit steps #5 thru #12.

 

[musicmaker]

Another way to set the default date on your calendar in(Access97) is:
Go to Form Properties (the form where your calendar is located), Event Tab, On Load...
VBA code: SelectDate = Now()
Note: for this to work, the name setting of your calendar must be set to [SelectDate].