Connecting Tech Pros Worldwide Forums | Help | Site Map

calendars in reports

rudy
Guest
 
Posts: n/a
#1: Nov 13 '05
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

PC Datasheet
Guest
 
Posts: n/a
#2: Nov 13 '05

re: calendars in reports


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
resource@pcdatasheet.com
www.pcdatasheet.com


"rudy" <rcastro4@satx.rr.com> wrote in message
news:8bed18f5.0406180900.2d5df479@posting.google.c om...[color=blue]
> 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[/color]


Closed Thread


Similar Microsoft Access / VBA bytes