Report Parameters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Bear this in nind - I'm a beginner with Access

I've created a Query with a paramter [Date]

I have created a Report based on the above Query with a Dialog for the user
to enter the desired [Date] value via a date-picker.

How do I pass the user-entered [Date] value from the Dailog to the Reoprt
(and hence Query)?

Thanks in advance
 
Just create an unbound text box on your report with your source equal to the
prompt from your query.


= [Date]


I would not recommend using reserved words like "date". I'd use
[EnterStartDate] or [EnterEndDate] or [EnterDate] to avoid conflicts.

Rick B
 
Thanks for the quick reply Rick

I have changed the parameter name to [EntryDate] as suggested.

The problem is that I need to set the value on a Form (using a DTPicker),
and then pass it to the Report as a parameter

When a press the button on the From to call the Report it still asks for the
paramterd value ([EntreyDate])

Rick B said:
Just create an unbound text box on your report with your source equal to the
prompt from your query.


= [Date]


I would not recommend using reserved words like "date". I'd use
[EnterStartDate] or [EnterEndDate] or [EnterDate] to avoid conflicts.

Rick B

PeteA said:
Bear this in nind - I'm a beginner with Access

I've created a Query with a paramter [Date]

I have created a Report based on the above Query with a Dialog for the user
to enter the desired [Date] value via a date-picker.

How do I pass the user-entered [Date] value from the Dailog to the Reoprt
(and hence Query)?

Thanks in advance
Click to expand...
Click to expand...
 
The date you selected from the datepicker should be placed in a field on
your form. In your query, don't ask the user to enter the date by entering
the prompt, instead, refer to the field you stored your date in on the form.

The format would be something like...

[Forms]![FormNameGoesHere]![FieldNameGoesHere]


Hope that helps.

Rick B

PeteA said:
Thanks for the quick reply Rick

I have changed the parameter name to [EntryDate] as suggested.

The problem is that I need to set the value on a Form (using a DTPicker),
and then pass it to the Report as a parameter

When a press the button on the From to call the Report it still asks for the
paramterd value ([EntreyDate])

Rick B said:
Just create an unbound text box on your report with your source equal to the
prompt from your query.


= [Date]


I would not recommend using reserved words like "date". I'd use
[EnterStartDate] or [EnterEndDate] or [EnterDate] to avoid conflicts.

Rick B

PeteA said:
Bear this in nind - I'm a beginner with Access

I've created a Query with a paramter [Date]

I have created a Report based on the above Query with a Dialog for the user
to enter the desired [Date] value via a date-picker.

How do I pass the user-entered [Date] value from the Dailog to the Reoprt
(and hence Query)?

Thanks in advance
Click to expand...
Click to expand...
Click to expand...
 
Back
Top