PrintOut action

[svcghost]

Hey guys,

I'm trying to create a macro that will print out 5 reports. I know how to OPEN 5 reports with a macro, with the OpenReport action, but I want to print them. The PrintOut action is not in the drop down list of usable actions in the Macro design view, though.

Any ideas? I really did try and search this topic a lot, but with no luck. Sorry.

[TheShabz]

when you choose the "openReport" option in the macro, on the bottom, right below where you choose the report name, the default view is "print". so unless you change that, it'll print by default.

[svcghost]

Thanks for that. The default, oddly enough for me, was not print. It was "Report" view.

One more question. So about 10 of the 15 reports I want to print with this macro, there is a parameter "GameNumber". This parameter is named the same and corresponds to the same field in the Games table "GameID". Is there any way I can just have the user prompted ONCE for this parameter?

[TheShabz]

have the macro be run from a button on a form. include a textbox on the form that will hold the parameter. Then, in the report, refer to the textbox value as the filter parameter.

[svcghost]

Well the thing is, the report just asks for the GameNumber parameter because the query it's based on uses that parameter. So I'm confused about step 3, i.e. your last sentence.

[TheShabz]

ok so its not filtered in the form. if its a query prompt, just set the criteria field of the query design to Forms!formName!txtBoxName

[svcghost]

Okay thank you.

I have two problems now:

1. I can't make this edit in the 5 queries that I use UNION in, because those queries can't be opened in Query Design View

2. The reports print fine, but when I simply VIEW them, they look messed up.
Only when I open the Print Form that I made, and enter the proper game number in, THEN save, and THEN open the report, does it work.

[TheShabz]

yea reports are awkward that way. they're like web pages. look different depending on how you open them. i really dont know why they do that and have moved away from access reports, so i wouldnt be much help there. go ahead and post the sql and i'll insert it in for you.

[svcghost]

Thanks for all your help though.

What exactly do you mean insert it in?

[TheShabz]

well you said you couldnt make that edit to 5 queries because you couldnt view them in design view. paste in the sql from sql view and i'll put in the Forms!formName!txtBoxName

[svcghost]

Ohhh that's all you have to do? Okay then I know how to make that edit. Save you some work haha.

Thanks very much. rep'd u

[TheShabz]

woot! i haz reps!

glad you got it working.