Parameter Reports with a form to enter in dates

  • Thread starter Thread starter Lee T
  • Start date Start date
L

Lee T

I would like to create a Parameter Report. I want the
user to type in/select the dates for input from another
form. This could be typing in the 01/01/1912 or from the
Active X Calendar.

Navigation would be as such:
Report XYZ button opens form
Input Date (and the report???) which would then
Open (or make visible) the report restricted to the
dates.

I have seen (and this is where my users got the calendar
idea) the begin/end dates along with the button to
activate the report on one form but I have a lot of
potential forms and would like to keep them separate if
possible.

Thanks,

LT
 
Thanks, that worked but my user wants the activeX
calendars to show up. I can do that with this type of
query as long as the OpenForm button is on the calendar
form. However, I don't want it to be there. I want to
hit the button to open the form BUT have the calendar
open first to select the dates.

LT
-----Original Message-----
probably the easiest way would be to
setup a query (that lists all fields of desired table)
then in the date field put the following in the criteria line

Between [Enter Start Date] and [End Date]

then save this query, and base your form or report on this query you just
created. then when the user opens this particular form/report it will run
the query thus requesting input of the start/end dates and will display the
dates in the user defined range.

let me know if this helps,
_Bigred


Lee T said:
I would like to create a Parameter Report. I want the
user to type in/select the dates for input from another
form. This could be typing in the 01/01/1912 or from the
Active X Calendar.

Navigation would be as such:
Report XYZ button opens form
Input Date (and the report???) which would then
Open (or make visible) the report restricted to the
dates.

I have seen (and this is where my users got the calendar
idea) the begin/end dates along with the button to
activate the report on one form but I have a lot of
potential forms and would like to keep them separate if
possible.

Thanks,

LT
Click to expand...


.
Click to expand...
 
Hi Lee,

Does the article 208630 help? This article describes how you can reference
the parameters of a report's RecordSource query or view. You can use this
method to display the parameters in a text box in the report.

ACC2000: How to Reference Parameters in Reports
http://support.microsoft.com/default.aspx?scid=KB;EN-US;208630



Sincerely,

Alick Ye, MCSD
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.




--------------------
| Content-Class: urn:content-classes:message
| From: "Lee T." <[email protected]>
| X-Tomcat-NG: microsoft.public.access.formscoding
|
| Thanks, that worked but my user wants the activeX
| calendars to show up. I can do that with this type of
| query as long as the OpenForm button is on the calendar
| form. However, I don't want it to be there. I want to
| hit the button to open the form BUT have the calendar
| open first to select the dates.
|
| LT
|
| >-----Original Message-----
| >probably the easiest way would be to
| > setup a query (that lists all fields of
| desired table)
| >then in the date field put the following in the criteria
| line
| >
| >Between [Enter Start Date] and [End Date]
| >
| >then save this query, and base your form or report on
| this query you just
| >created. then when the user opens this particular
| form/report it will run
| >the query thus requesting input of the start/end dates
| and will display the
| >dates in the user defined range.
| >
| >let me know if this helps,
| >_Bigred
| >
| >
| >| >> I would like to create a Parameter Report. I want the
| >> user to type in/select the dates for input from another
| >> form. This could be typing in the 01/01/1912 or from
| the
| >> Active X Calendar.
| >>
| >> Navigation would be as such:
| >> Report XYZ button opens form
| >> Input Date (and the report???) which would then
| >> Open (or make visible) the report restricted to
| the
| >> dates.
| >>
| >> I have seen (and this is where my users got the
| calendar
| >> idea) the begin/end dates along with the button to
| >> activate the report on one form but I have a lot of
| >> potential forms and would like to keep them separate if
| >> possible.
| >>
| >> Thanks,
| >>
| >> LT
| >>
| >
| >
| >.
| >
|
 
Back
Top