Connecting Tech Pros Worldwide Forums | Help | Site Map

ReportToPDF - Access 2003 SP2

Newbie
 
Join Date: Aug 2007
Posts: 1
#1: Aug 29 '07
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

missinglinq's Avatar
Moderator
 
Join Date: Nov 2006
Location: Richmond, Virginia USA
Posts: 3,000
#2: Aug 29 '07

re: ReportToPDF - Access 2003 SP2


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)>
NeoPa's Avatar
Administrator
 
Join Date: Oct 2006
Location: London - UK
Posts: 15,730
#3: Sep 4 '07

re: ReportToPDF - Access 2003 SP2


Quote:

Originally Posted by akeatley

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

Originally Posted by OP

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.
Reply


Similar Microsoft Access / VBA bytes