If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
parameters
Hi,
how can I get the parameters to print on a report so the reader knows what dates that information covers without having to enter the dates twice? Thanks! -- JoAnn |
#2
|
|||
|
|||
parameters
Hi JoAnn,
Just use the parameter as the control source in your report. So if you have [Enter Start Date:] as a parameter, you can set the control source of a text box to [Enter Start Date:]. Or you can use it as part of an expression: =[Enter Start Date:] & " through " & [Enter End Date:]. Clifford Bass JoAnn wrote: Hi, how can I get the parameters to print on a report so the reader knows what dates that information covers without having to enter the dates twice? Thanks! -- Message posted via http://www.accessmonster.com |
#3
|
|||
|
|||
parameters
IMO, your users should never be hit with parameter prompts. Consider using
controls on forms for all user interaction. You can then reference the controls in text boxes on your report: Control Source: =Forms!frmRptCrit!txtFromDate Duane Hookom MS Access MVP "JoAnn" wrote in message ... Hi, how can I get the parameters to print on a report so the reader knows what dates that information covers without having to enter the dates twice? Thanks! -- JoAnn |
#4
|
|||
|
|||
parameters
Thanks - I am interested in using a form instead of parameters, but I'm not
sure how to do that. Can you expand on that? (thanks) -- JoAnn "Duane Hookom" wrote: IMO, your users should never be hit with parameter prompts. Consider using controls on forms for all user interaction. You can then reference the controls in text boxes on your report: Control Source: =Forms!frmRptCrit!txtFromDate Duane Hookom MS Access MVP "JoAnn" wrote in message ... Hi, how can I get the parameters to print on a report so the reader knows what dates that information covers without having to enter the dates twice? Thanks! -- JoAnn |
#5
|
|||
|
|||
parameters
Thanks Clifford
-- JoAnn "Clifford Bass via AccessMonster.com" wrote: Hi JoAnn, Just use the parameter as the control source in your report. So if you have [Enter Start Date:] as a parameter, you can set the control source of a text box to [Enter Start Date:]. Or you can use it as part of an expression: =[Enter Start Date:] & " through " & [Enter End Date:]. Clifford Bass JoAnn wrote: Hi, how can I get the parameters to print on a report so the reader knows what dates that information covers without having to enter the dates twice? Thanks! -- Message posted via http://www.accessmonster.com . |
#6
|
|||
|
|||
parameters
Hi JoAnn,
You are welcome. Clifford Bass JoAnn wrote: Thanks Clifford -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...esign/201001/1 |
#7
|
|||
|
|||
parameters
All user interaction should be managed through forms. IMO, don't allow users
to ever see your database window or tables. Assuming you have a report to open filtered based on start and end dates, you can add a couple text boxes on a form for the user to enter (or select using a calendar control). Name the text boxes txtStart and txtEnd. You can then add references to these controls in your report's record source query. The criteria under your date field might look something like: Between Forms![YourFormNameHere]!txtStart And Forms![YourFormNameHere]!txtEnd I prefer using the Where Condition of the DoCmd.OpenReport method. To display the values of the text boxes, add a text box on your report with a control source like: ="Between " & Forms![YourFormNameHere]!txtStart & " And " & Forms![YourFormNameHere]!txtEnd Duane Hookom MS Access MVP "JoAnn" wrote in message news Thanks - I am interested in using a form instead of parameters, but I'm not sure how to do that. Can you expand on that? (thanks) -- JoAnn "Duane Hookom" wrote: IMO, your users should never be hit with parameter prompts. Consider using controls on forms for all user interaction. You can then reference the controls in text boxes on your report: Control Source: =Forms!frmRptCrit!txtFromDate Duane Hookom MS Access MVP "JoAnn" wrote in message ... Hi, how can I get the parameters to print on a report so the reader knows what dates that information covers without having to enter the dates twice? Thanks! -- JoAnn |
Thread Tools | |
Display Modes | |
|
|