Parameter Query & Reports

[Gigi0614]

Can you hook a parameter query to a report?

Ya know a popup box that you enter values in, and it does a lookup on those specific records, then spits out a report??

I think you can do this, but my Access books don't cover that...

 

[dhookom]

Try it.
I don't recommend using parameter queries for anything since parameters provide no defaults or integrity checks. Plus, they pop up one at a time.

Using controls on forms is much more effective.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[Crowley16]

yes you can, but like dhookom said, not really a great idea...

 

[Gigi0614]

OK, how would you do this...

I've got a report that needs to be run every day, and may need to occasionally be run for previous days, or even future days.

The report pulls records based on date.

Hmmmm...I'm not sure how to do this...

 

[Crowley16]

u should probably start a new thread for this question since it's totally unrelated to your first question...

however...

you should include a few more details about this report...
i.e. when u say run report for today, do you mean report to be run with source data from a query based on today's date?

if that's the case, then you can just build a form and on it, have a text box for the date, and a command button to activate the report.
And in your query, use Forms![formName].tbxDate instead of the parameter...

this way, u can have default day set to today, checking date entered is valid...

 

[Gigi0614]

OK, then so, I will read up on command buttons in my ACCESS book. Thanks!

 

[Crowley16]

lol...

it's dead easy...

1) goto form design view
2) draw a command button
3) name your button
4) right click on button, select build event
5) put: docmd.openreport "rptName"
6) goto form view
7) click on button...

 

[Gigi0614]

Thank you Crowley!! I will practice this.