A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

parameters



 
 
Thread Tools Display Modes
  #1  
Old January 14th, 2010, 02:06 AM posted to microsoft.public.access.tablesdbdesign
JoAnn
external usenet poster
 
Posts: 144
Default 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  
Old January 14th, 2010, 02:19 AM posted to microsoft.public.access.tablesdbdesign
Clifford Bass via AccessMonster.com
external usenet poster
 
Posts: 150
Default 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  
Old January 14th, 2010, 05:43 AM posted to microsoft.public.access.tablesdbdesign
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default 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  
Old January 15th, 2010, 01:40 PM posted to microsoft.public.access.tablesdbdesign
JoAnn
external usenet poster
 
Posts: 144
Default 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  
Old January 15th, 2010, 01:47 PM posted to microsoft.public.access.tablesdbdesign
JoAnn
external usenet poster
 
Posts: 144
Default 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  
Old January 15th, 2010, 04:01 PM posted to microsoft.public.access.tablesdbdesign
Clifford Bass via AccessMonster.com
external usenet poster
 
Posts: 150
Default 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  
Old January 15th, 2010, 11:34 PM posted to microsoft.public.access.tablesdbdesign
Duane Hookom[_4_]
external usenet poster
 
Posts: 316
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:33 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.