I am using a 2003 database and 2010 Runtime 64 bit. The problem that I am having is when I execute the following 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 ' date order
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
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?