Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Tigard, Oregon USA

    Unanswered: Access 2000 - Printing a form in landscape mode

    I've been working on a project for a company this past week, and I brought it home to work on it. Problem: They use Access 2000, I use Access 2003.

    Some of the features I programmed for them didn't work after I moved the database back to their network, as some of the code does not apply.

    I've figured out how to repair all of the features to how 2000 wants to see them, except for one thing:

    I have a button in the main form, which, instead of printing one of their various reports off, it is supposed to do the same thing as going FILE > PRINT > SELECTED RECORD and setting it to Landscape mode. The code works GREAT in 2003....... but I cannot find anything to save myself on this last feature.

    This is the code for the subroutine that works in Access 2003:

    Private Sub ScreenPrint_Click()
    On Error GoTo Err_ScreenPrint_Click

    Forms("Caller Request").Printer.Orientation = acPRORLandscape
    DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
    DoCmd.PrintOut acSelection
    Forms("Caller Request").Printer.Orientation = acPRORPortrait
    Exit Sub

    MsgBox Err.Description
    Resume Exit_ScreenPrint_Click

    End Sub

    When I try to run the code on 2000, and I click the button, I get a debug dialog box telling me that the variable "acPRORLandscape" is not defined.

    Is there another technique I could use to accomplish the same thing, but that 2000 will understand?

    Please and Thank You!!!

  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    This is why I always develop an application in it's source database. If you are going to implement on 2000, then develop in 2000!

    You might want to consider developing a report for printing, set that report to landscape and just print the current record by passing a filter


    DoCmd.OpenReport "ReportName", acViewPreview, , "RecordID = " & Me.RecordID

    I never print forms
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts