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).
Access 2007 Front-end linked tables to an Access 2007 Back-end database
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