If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Access > Print Preview in 2010 Runtime 64 bit

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-23-12, 04:29
Poppa Smurf Poppa Smurf is offline
Registered User
 
Join Date: Jun 2007
Location: Sydney,Australia
Posts: 358
Print Preview in 2010 Runtime 64 bit

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?
__________________
Poppa Smurf
allanmurphy47@gmail.com
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On