Question Problem with Print Preview in 2010 Runtime 64 bit (1 Viewer)

Poppa Smurf

Registered User.
Local time
Today, 10:13
Joined
Mar 21, 2008
Messages
448
I am using a 2003 database and 2010 Runtime 64 bit. The problem that I am having is when I execute the following code from a form :-

Code:
Private Sub Preview_Click() 
On Error GoTo Err_Preview_Click
 
Dim strDocName As String
 
Select Case display_order
   Case 1 ' by date
           strDocName = "rpt_comments_all"
           DoCmd.OpenReport strDocName, acViewPreview
 
  Case 3 ' by Summary
           strDocName = "rpt_comments"
           DoCmd.OpenReport strDocName, acViewPreview
 
  Case Else
           MsgBox ("Not a valid selection")
 
End Select
 
Exit_Preview_Click:
     Exit Sub
 
Err_Preview_Click:
          If Err = ConErrRptCanceled Then
                    Resume Exit_Preview_Click
          Else
                    MsgBox Err.Description
                    Resume Exit_Preview_Click
          End If
End Sub
The default ribbon associated with Runtime displays the Close Print Preview Button (as active), OK so far.

Now when I open in the Print Preview mode the same report or another report using the same DoCmd format as above is displayed as inactive (greyed out).

Is there a solution to this problem without creating a custom ribbon?
 

Users who are viewing this thread

Top Bottom