Printing differnet reports using the same Critera set

[vp7799]

Here is the problem. When a person arrives in my unit the must come see me to "inprocess" which involves several forms that need to be signed. I have access setup where after I enter their information I can select the report to be printed and access puts in the persons information. I do this based on a query that in the critera block I have [Type SSN] or [Type Last Name]. So when i click on the report a pop up box asks for SSN first which i can click ok if i do not want to look it up then a pop up box that asks for last name one of the two i have to enter. The problem is I have serval forms and do not want to input the SSN or last name 8 different times( I am Lazy). Is there a way to build a Marco to do this for me. I have already built one that opens and prints the reports but the pop up box shows up for each report, which can be annoying. I hope i did not confuse anyone. Thanks for any help

Ty

 

[LittleSmudge]

Instead of closing the pop-up form after each report is printed - just set .Visibility = NO.

It will still be there and it's data can be retrieved by the subsequent Reports. - You just don't see it.

Then remember to close the thing after the final report is printed.

G LS

 

[vp7799]

I really did not understand that, let me explain a little more. I have 4 different reports that i want to have printed out. When I excute any one of the forms a pop up box asking for SSN comes up. To have the report fill in the persons info I need to enter a SSN. I built a Macro to Open all 4 forms and print them. Problem is I get one pop up box i enter in the info another one for the next form pops up asking again for the same info and the form will not print untill i input the SSN. Is there some way to put the SSN in only once and have all reports print with the persons info on them? I hope this clears up what I would like. Thanks

 

[KenReay]

Hi

the 'pop up form' you are getting is the builtin Access way of asking for a value to a parameter in a query.

You need to make yourself an Access Form, which has text boxes (or combo boxes) to receive the data you want (ie SSNO and/or Name), and then use those values in your queries. This can be simplified by using the builder in the query designer.

You could follow LittleSumdges advice and hide the form while you run the report(s), and / or have a p[ront button on the form which runs the necessary reports one after the other. If the set of reports sometimes varies you could even have check boxes on the form to allow you to select the reports you want to run.

Hope this helps

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use