|
-
Mar 14th, 2006, 10:56 PM
#1
Thread Starter
New Member
report missing when using docmd.openreport with preview
Greetings (newbie here):
I am using MsbBox to determine if screen preview is required for a report. When the conditions are met for print preview, the report does not appear. It works fine for printing directly to printer. Is it hidden behind open forms? I am using forms as a menu system for the users. Print preview works fine if I access the report directly through the objects. Any help out there would be greatly appreciated.
-
Mar 15th, 2006, 03:58 AM
#2
-
Mar 15th, 2006, 08:39 AM
#3
Thread Starter
New Member
Re: report missing when using docmd.openreport with preview
I'm using MS Access. Did I post to the wrong place? The code below is the message box info used after determining the required filter string.
Response = MsgBox("Print to screen first?", vbYesNoCancel + vbDefaultButton3, "Print Decision:")
If reponse = vbYes Then
DoCmd.OpenReport "Sick Day Report - Individual", acViewPreview, , FilterStr
ElseIf Response = vbNo Then
DoCmd.OpenReport "Sick Day Report - Individual", acViewNormal, , FilterStr
DoCmd.Close
DoCmd.OpenForm "Menu_Sick_Day_Reports", , , , acFormReadOnly, acDialog
Else
DoCmd.Close
DoCmd.OpenForm "Menu_Sick_Day_Reports", , , , acFormReadOnly, acDialog
End If
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|