Results 1 to 7 of 7

Envelope wants to print four pages

  1. #1
    gafort is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Jan 2011
    Location
    Cleveland, Ohio
    Posts
    22

    Envelope wants to print four pages

    I have the following set up to print an envelope on a HP Laserjet P2015. Every time I print, the out of paper light flashes and I have to press the reset button. Any ideas what is causing this? Here is the code:



    Private Sub btnPrintEnvRental_Click()
    Dim sSQL As String
    sSQL = "PARCEL=" & "'" & Forms!frmRental.[PARCEL] & "'"
    ' DoCmd.OpenReport "VioLetter", acViewPreview, , PARCEL = Forms!frmResidentialProperties.[PARCEL]
    DoCmd.OpenReport "rptEnvRental", acViewPreview, , sSQL
    'DoCmd.PrintOut acPrintAll, , , acHigh, 2
    End Sub

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    I don't there is something about the codes, it's the report itself which cause the problem.

  3. #3
    ansentry's Avatar
    ansentry is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    May 2009
    Location
    Melbourne, Australia
    Posts
    67
    What paper size have you set for the report?

    I use access 2003 to print envelopes (DL & C5) and they work fine.

    When your report opens in preview, how many pages display at the bottom left hand corner?

    Mine shows 1 and the preview display the envelope in its correct size.

  4. #4
    gafort is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Jan 2011
    Location
    Cleveland, Ohio
    Posts
    22
    Quote Originally Posted by ansentry View Post
    What paper size have you set for the report?

    I use access 2003 to print envelopes (DL & C5) and they work fine.

    When your report opens in preview, how many pages display at the bottom left hand corner?

    Mine shows 1 and the preview display the envelope in its correct size.
    It wants to print 4 envelopes. I have it set for #10 envelopes. I am getting the "section width greater than page width" error. When I attempt to shrink the envelope (in design view) to less than the 9.5 width, it no longer prints the address, just a bunch of numbers. I have tried removing white space, same thing. This is driving me nuts. Thanks for your help.

  5. #5
    ansentry's Avatar
    ansentry is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    May 2009
    Location
    Melbourne, Australia
    Posts
    67
    I don't know what #10 Envelopes are. They do not appear in my page setup list (see attached). Is you paper orientation set to Portrait or Landscape?

    I could make a sample db based on my DL Envelope for you to have a look at if you wish.

    Let me know.

  6. #6
    gafort is offline Novice
    Windows 7 32bit Access 2003
    Join Date
    Jan 2011
    Location
    Cleveland, Ohio
    Posts
    22
    #10 envelope is a standard business size in U.S. You don't need to do a sample DB. The problem is in the margin setup somewhere. I've changed all the margins numerous times without success. For now, I just hit the reset button after each envelope print. A real pain when you have 500 letters to go out like I do now. Thanks again

  7. #7
    Join Date
    May 2010
    Posts
    339
    I use the primary key to print, try something like this behind a new button.
    This prints (2) reports/envelopes.

    Code:
     Dim strWhere As String
        If Me.Dirty Then    'Save any edits.
            Me.Dirty = False
        End If
        If Me.NewRecord Then 'Check there is a record to print
            MsgBox "Select a record to print"
        Else
            strWhere = "[YourID] = " & Me.[YourID]
            DoCmd.OpenReport "YourReport", acViewNormal, , strWhere 'Prints (2) reports
            DoCmd.OpenReport "YourReport", acViewNormal, , strWhere
     
        End If
    Good luck
    Richard

Please reply to this thread with any new information or opinions.

Similar Threads

  1. How to attached mergered envelope to a Form
    By GomChrist in forum Access
    Replies: 1
    Last Post: 11-19-2010, 12:30 AM
  2. Print Single Envelope From Form
    By genest11 in forum Forms
    Replies: 2
    Last Post: 03-25-2010, 09:00 AM
  3. Print Preview different from Print Hardcopy
    By peterc in forum Reports
    Replies: 4
    Last Post: 10-27-2009, 05:35 AM
  4. Blank pages between report pages
    By jonsuns7 in forum Reports
    Replies: 2
    Last Post: 10-01-2009, 05:06 AM
  5. Error when trying to print or print preview
    By TriAdX in forum Reports
    Replies: 8
    Last Post: 08-25-2009, 08:20 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums