Code for Printing a report is not working

Skip Bisconer

Who Me?
Local time
Today, 14:24
Joined
Jan 22, 2008
Messages
285
I have an option box to preview or print a simple one page report. I am using code that I have been using for this purpose for several different databases. All the other data bases send the report to the defaul printer from this code.

Case 1 produces the desired result but Case 2 doesn't. It creates a .tif file, wants me to save it before printing, and if I answer yes to save it doesn't print it just opens the Windows Office Document Image program. I just want it to print on the default system printer like all my other processes.

Can some one advise me on this?

Code:
Private Sub ProcessAPReport_Click()
Select Case Frame48
Case 1
Me.Visible = Valse
DoCmd.OpenReport "GL Distribution to AP Report", acViewReport, , , acDialog
Me.Visible = True
Case 2
[COLOR=royalblue]DoCmd.OpenReport "GL Distribution to AP Report", acViewNormal, "", "", acNormal[/COLOR]
End Select
 
Forget it I posted. I had created a report from clicking on the standard Report toolbar and it must have created a report with an image in it. I got rid of it by changing the Picture property to no picture. Sorry if I wasted anyones time.
 

Users who are viewing this thread

Back
Top Bottom