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?
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