Unexpected Prompts when Printing Reports

[gemineye]

When I attempt to print a report, I get the same prompts used to create that report in the first place. In order to print it, I have to enter all the information again.

Any idea what is causing this problem? Thanks!

 

[stix4t2]

I am assuming the prompts are in the query, so when access run the reports is looks for the information. And when you print it, it looks again? What did you mean by it prompts when creating the report?

 

[gemineye]

Yes, the prompts are in the query. When I run the report I get the prompts. When I go to print the report I get the same prompts again.

 

[stix4t2]

I guess I am just a little slow after the long week. Can you not close the report and print, print from the preview? Can you create a form to enter the prompt information and provide a button to show the report?

 

[gemineye]

Thanks for your replies. Even if I try to do a print preview, I get the prompts. I could create a form to enter the prompt information and provide a button to show the report but it seems I should be able to just print it without getting the prompts.

 

[stix4t2]

The query is not that smart, everytime it runs it has to recalculate on the prompts. This is why if you have the values on a form, you can set the query to look at the form.

i.e. startDate endDate
If a little form came up asking for start date and end date and included a button to preview report and a button to print report. You could set the query to use
between forms!printRequest!startDate and forms!printRequest!endDate under dateReceived. Then the report would not prompt. Also you can set the prompts to a temp table so the system remembers. You are also able to validate any information before running the report. I just helped another user validate that the report had records before showing it, otherwise it provided a message box that the report had no data. Alot can be done here to make the user experience alot more enjoyable.

 

[gemineye]

Stix4t2, thanks very much for your assistance. I will try out your suggestions-- Jim