Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problems printing a report

Status
Not open for further replies.

shaunacol

Programmer
Jan 29, 2001
226
GB


I am using the code at the buttom of this entry behind a button to print a report but when I choose it opens the report in one note instead. What did I do wrong...

Please note that lstqueries is a list box within the form where the button resides that gives the user a list of different reports they can choose from. Please also note that when I use this code
DoCmd.OpenReport Me.lstQueries, acViewPreview, , strCriteria
then the report previews perfectly.

Here is the code.....any help appreciated

DoCmd.OpenReport Me.lstQueries, acViewNormal, , strCriteria
 
OK I have reset the default print but still no luck. They are now just sitting in the priner queue. I guess this is obviously more of a system or printer issue than a MS Access isue but if anyone has any ideas please do let me know...
 
Shaunacol: Are you sure the default printer is properly selected? Is there a check mark next to it?

Because when I change my default printer in Devices and Printers to xps writer it prints to that.

-Nima
"Pluralitas non est ponenda sine necessitate", i.e., "Plurality is not to be posited without necessity" aka K.I.S.S. (Keep It Short and Simple) -- Ockham's Razor
 
yes it is selected but looks as though its a system error as i thought and printer needs reinstalling
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top