Help! Lost Using Calendar Control

  • Thread starter Thread starter S Jackson
  • Start date Start date
S

S Jackson

I am trying to build a form that asks the user for a range of dates so that
the user can print a report for that range.

I put in two ActiveX (?) Calendars. (I'm so lost.) Now what? How do I
tell Access to take the date the user selects from the 1st calendar as the
start date and the date from the 2nd calendar as the end date and then
generate the report?

Is this just much to complicated for an intermediate user?

S. Jackson
 
No it is not too complicated!

If your calendars are named Calendar1 and Calendar2, you
need code like this:

Sub Calendar1_Click()

Startdate= MyCalendar.Value
End Sub

Sub Calendar2_Click()

Enddate= MyCalendar.Value
End Sub

Then just use Startdate and Enddate in the query on which
the report is based.

Dave
 
How do I use this in my Query?

Sorry, but I am really green here.

I think I've got set up what you indicated below.

S. Jackson
 
Back
Top