Connecting Tech Pros Worldwide Help | Site Map

calendars in reports

  #1  
Old November 13th, 2005, 12:58 AM
rudy
Guest
 
Posts: 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
  #2  
Old November 13th, 2005, 12:58 AM
PC Datasheet
Guest
 
Posts: n/a

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 Threads
Thread Thread Starter Forum Replies Last Post
Is ADO dead? Lyle Fairfield answers 19 March 3rd, 2006 09:45 PM
One Small step one infinite leap zetasum answers 0 July 23rd, 2005 01:32 AM
One Small step one infinite leap zetasum answers 0 July 18th, 2005 10:13 PM
One Small step one infinite leap zetasum answers 4 July 17th, 2005 12:21 PM