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