only prints the same query - no matter what i have open

[RedGoneWILD]

what have i done wrong? reports were printing just fine, but now no matter what report i have open, when i go to print it keeps printing the same query, not even a report.



Even when I close the database, and restart it, i still get the same query. What setting in VBA did I alter to cause it to do this. Please help!

[weekend00]

delete the query then try again. Before deleting, save it somewhere. But don't just rename.

[RedGoneWILD]

any idea what caused it so i can prevent it from happening again?

[weekend00]

I don't know yet, just delete the query to find out the reason.

[RedGoneWILD]

ok, i have a reports form with a list of reports. I can open the reports with a button from this form. The form stays open and the report opens up as well. When I try to print, it will print anything but the report...such as a query or the form.

But when everything else is closed, and I open the report manually from the navigation pane, then it prints fine

what vba code do i need to get this to print the open report? do i need to set focus to the report? do i need to close the form that opened the report?

[weekend00]

how did you release the print job for the report? By VBA code? from menu of the report?

when you choose from the print menu of the report, of couse the focus is on the report.

Maybe you tried to print the report from Access main window's menu?

[RedGoneWILD]

yeah, i selected the circle in the upper left hand corner?

whats the best way to print a report?

[weekend00]

Right click on the the report, choose print.

[RedGoneWILD]

okay, but is there a way to just set the print focus to the open report instead? It's so much easier to go to the top and select print....right clicking only brings up print preview, then you have to right click again to print

[weekend00]

I got you.
you want to print a report without opening it.

right click on the report's name, there is a "print" option as sell as "print preview".