Access save as PDF - open Adobe Reader using Citrix

Rx_

Nothing In Moderation
Local time
Today, 00:16
Joined
Oct 22, 2009
Messages
2,803
Very specific problem for those of us using Citrix Servers with Access 2007.

On my Development workstation, The Access Report (on the Deactivate event) saves as a PDF file, then launches the Adobe Reader to open the PDF report. This allows the user to "save as" to thier favorite location.

Problem: When moving the Access 2007 application to the Citrix Server, the Access 2007 conversts the Access report to PDF. But, it failes to launch the Adobe Reader for the Citrix user.

The good news:

My Citrix guru came up with this web site and a MVP had this solution:
http://www.pcreview.co.uk/forums/thread-1081981.php
Does it work if, instead of using Shell and specifying the path to
Acrobat Reader (which may be different on the server anyway) you just
write
Application.FollowHyperlink doclaunch
? On my system (without Citrix involved) that works, given that Acrobat
Reader is the registered application for files of type ".pdf".
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

Below, is my existing Code: If anyone has suggestions on how to merge the two, it would be greatly appreciated.
(B.T.W. I am leaving now for a vacation and may not respond until next week).

Code:
Private Sub Report_Deactivate()
      Dim MyFiLeName      As String
10        If Not NoData Then  ' checks for no data event to prevent a mis fire
20            DoEvents
30            MyFiLeName = "C:\Standard_Report " & Format(Now, "mm-dd-yyyy hhnnss") & ".pdf"
40            DoEvents
50            MsgBox "Please Save Your Adobe File to a network file location", vbOKOnly, "Save Now or loose it"
60            DoEvents
              'DoCmd.OutputTo acOutputReport, "Rx_ReportNewAPD", acFormatPDF, MyFiLeName, True ' , , , acExportQualityPrint
70            DoCmd.OutputTo acOutputReport, "rptAPD_2010", acFormatPDF, MyFiLeName, True
              ' The Now function just time stamps the file so all files are unique in name on citrix server for a user to save
80            DoEvents
90        End If
End Sub

Access 2007 Front-end linked tables to an Access 2007 Back-end database
 

Users who are viewing this thread

Back
Top Bottom