2003 report goes landscape in 2010 (1 Viewer)

marlan · Feb 17, 2013

Hi all you experts!

I'm working a 2003 .mdb project on Acc2003.
I have a report I export to pdf (by Stephen Leban) and e-mail. This has bin working great for the past few years, but now is going wrong for one of my clients: she satrted using 2010 Run-Time, and now 2 of the reports get printed in landspape, rather than portrate.
Note 1: I designed reports so that all margins are 0. this is the setting on my machine, and on the clien's too.
Note 2: I get the same results when installing 2010 RT on my computer...:banghead:

Any Ideas?
TIA

marlan · Feb 18, 2013

Hi,

OK, I've goen around this problem, by creating a wrapper:

Code:

Public Function ConvertReportToPDFwrapper( _
Optional RptName As String = "", _
Optional SnapshotName As String = "", _
Optional OutputPDFname As String = "", _
Optional ShowSaveFileDialog As Boolean = False, _
Optional StartPDFViewer As Boolean = True, _
Optional CompressionLevel As Long = 0, _
Optional PasswordOpen As String = "", _
Optional PasswordOwner As String = "", _
Optional PasswordRestrictions As Long = 0, _
Optional PDFNoFontEmbedding As Long = 0, _
Optional PDFUnicodeFlags As Long = 0 _
) As Boolean
    If Application.Version = 11 Then
        ConvertReportToPDFwrapper= ConvertReportToPDF(RptName, , OutputPDFname, ShowSaveFileDialog, StartPDFViewer, , , , , , &H181000)
    ElseIf Application.Version > 11 Then
        DoCmd.OutputTo acOutputReport, RptName, "PDF Format (*.pdf)", OutputPDFname, StartPDFViewer
        ConvertReportToPDFwrapper= True
    End If         
End Function

The nice thing: you can have *.mdb files export a report to pdf hwen running in acc2007 and later!

marlan · Feb 18, 2013

The thread is not solved, because I still don't know why the report went ladscape using Stephen Leban's module. using DoCmd.OutputTo it stayd portrate.

Any Ideas?

2003 report goes landscape in 2010 (1 Viewer)

marlan

Registered User.

marlan

Registered User.

marlan

Registered User.

Similar threads

Users who are viewing this thread