ReportToPDF - Access 2003 SP2

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

<<<<<<<<<<<

    ' Save the Snapshot file as a PDF document.
    Dim blRet As Boolean
    Dim sPDF As String
    Dim sName As String
    sName = "Exception_Report"
 
    If Len(sName & vbNullString) = 0 Then Exit Sub
    ' let's use the name of the selected Snapshot file
    ' to name our converted PDF document.
    sPDF = Mid(sName, 1, Len(sName) - 3)
 
    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]

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]

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.

<<<<<<<<<<<

    ' Save the Snapshot file as a PDF document.
    Dim blRet As Boolean
    Dim sPDF As String
    Dim sName As String
    sName = "Exception_Report"
 
    If Len(sName & vbNullString) = 0 Then Exit Sub
    ' let's use the name of the selected Snapshot file
    ' to name our converted PDF document.
    sPDF = Mid(sName, 1, Len(sName) - 3)
 
    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.