By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,946 Members | 1,701 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,946 IT Pros & Developers. It's quick & easy.

calendars in reports

P: n/a
Is there a way to use a calendar to select the range of dates needed
in a report. I have been able to display a calendar in a form but
would much rather use a selection method than having to type the
dates.

thanks,
Rudy
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Rudy,

Use a pop-up form that has a calendar and two textboxes on it. Name the first
textbox StartDate and the second textbox EndDate.

Put the following code in the Calendar's OnClick event:
If IsNull(Me!StartDate) Then
Me!StartDate = Me!NameOfCalendar.Value
Else
Me!EndDate = Me!NameOfCalendar.Value
End If

The first date selected on the calendar will fill StartDate ane the second date
selected will fill EndDate.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"rudy" <rc******@satx.rr.com> wrote in message
news:8b**************************@posting.google.c om...
Is there a way to use a calendar to select the range of dates needed
in a report. I have been able to display a calendar in a form but
would much rather use a selection method than having to type the
dates.

thanks,
Rudy

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.