By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,201 Members | 1,617 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,201 IT Pros & Developers. It's quick & easy.

ReportToPDF - Access 2003 SP2

P: 1
I have the ReportToPDF code working fine with Access 2003 (No Service Patch) and acrobat 8, but as soon as i try the same code on Access 2003 SP2 with acrobat 7 it doesn't work.

<<<<<<<<<<<
Expand|Select|Wrap|Line Numbers
  1.     ' Save the Snapshot file as a PDF document.
  2.     Dim blRet As Boolean
  3.     Dim sPDF As String
  4.     Dim sName As String
  5.     sName = "Exception_Report"
  6.  
  7.     If Len(sName & vbNullString) = 0 Then Exit Sub
  8.     ' let's use the name of the selected Snapshot file
  9.     ' to name our converted PDF document.
  10.     sPDF = Mid(sName, 1, Len(sName) - 3)
  11.  
  12.     blRet = ConvertReportToPDF(sName, , sName & ".PDF", False)
>>>>>>>>>>>>>>>>>>>>

Does the ReportToPDF work with access 2003 SP2??

Can you think of any other reason this would work??

Cheers
Aaron
Aug 29 '07 #1
Share this Question
Share on Google+
2 Replies


missinglinq
Expert 2.5K+
P: 3,532
You have inadvertently posted your question in the Articles section rather than in the Forum section of our site, so I have moved it across to the Forum for you.

Welcome to TheScripts!

Linq ;0)>
Aug 29 '07 #2

NeoPa
Expert Mod 15k+
P: 31,766
I have the ReportToPDF code working fine with Access 2003 (No Service Patch) and acrobat 8, but as soon as i try the same code on Access 2003 SP2 with acrobat 7 it doesn't work.

<<<<<<<<<<<
Expand|Select|Wrap|Line Numbers
  1.     ' Save the Snapshot file as a PDF document.
  2.     Dim blRet As Boolean
  3.     Dim sPDF As String
  4.     Dim sName As String
  5.     sName = "Exception_Report"
  6.  
  7.     If Len(sName & vbNullString) = 0 Then Exit Sub
  8.     ' let's use the name of the selected Snapshot file
  9.     ' to name our converted PDF document.
  10.     sPDF = Mid(sName, 1, Len(sName) - 3)
  11.  
  12.     blRet = ConvertReportToPDF(sName, , sName & ".PDF", False)
>>>>>>>>>>>>>>>>>>>>

Does the ReportToPDF work with access 2003 SP2??

Can you think of any other reason this would work??

Cheers
Aaron
Aaron,

If you want people to look at your problem you should really make the effort to ask the question in a much clearer way.
This is a bit like saying :
I've got a problem. Can you tell me what it is?
ReportToPDF & ConvertReportToPDF? Are they both references to the same thing that you haven't introduced anywhere? Are they supposed to be inbuilt Access items? Help didn't seem to know anything about them.
If you would like us to help please provide us with a meaningful question. It's not much fun spending time and effort just trying to find out what the question means.
Sep 4 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.