Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing an Envelope

    In Access 2000, I have a button that prints an envelope for the current record. I used File, Page Setup to select the right envelope paper size of 4 1/8 x 9 1/2. It works fine for the printer I have but if I send the database to someone else to use, who has a different printer, the envelope paper size that was originally saved defaults to a paper size of 8 1/2 x 11 and has to be manually changed. How can this be remedied?
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing an Envelope

    Since I didn't get any response from my initial question. Let me ask another question regarding this same problem. Is there any way through code that I can determine what the default printer is and then select the paper size based on the default printer that a person is using?
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing an Envelope

    Dear Judy Jones,

    I did see your question first time around but I didn

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing an Envelope

    I found Charllot's Post, Hope it Helps

    Re: landscape printer setting in access report [Post#: 11576 / re: 11562 ]


    The simplest way is to use Page Setup with the report in design view, set it the way you want it, and then save the report. This will work as long as all users have the same printer name and path. However, there's a bug in the initial release of Access 2000 that causes it to drop printer settings. Make sure you have SR1a loaded, since it corrected that problem.

    Charlotte

  5. #5
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing an Envelope

    Hi Judy,

    Sorry for the delay in responding. I just knew someone else would have a detailed and accurate answer for you. However, seeing none, here's my <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>:

    You can use the PrtDevMode to get and set properties of your printer. There are a host of Knowledge Base articles with examples. Unfortunately, I have never been successful in implementing any of them.

    This article will get you started: <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q109/8/28.asp?LN=EN-US&SD=gn&FR=0&qry=PrtDevMode&rnk=7&src=DHCS_MSPSS_ gn_SRCH&SPR=ACC>Q109828</A>
    HTH <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>

  6. #6
    2 Star Lounger
    Join Date
    Jul 2003
    Location
    Newtown, Pennsylvania, USA
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing an Envelope

    You should probably also make sure that the Name Autocorrect feature is turned off on the database (Tools/Options/General) - this 'feature' is associated with a known bug that reverts paper size to the default.

    kiwi44

  7. #7
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing an Envelope

    Thanks to everyone who took time to respond. MarkJ you put me on the right track re: the use of PrtDevMode. I found the following Microsoft site dealing with Access 2000 entitled "How to Print a Report to Different Paper Trays"

    http://support.microsoft.com/support...es/Q200/5/46.A
    SP

    I copied and pasted the code into a new module and modified it slightly

    I changed the dm.dmDefaultSource = 5 'which was the number to designate an envelope feeder

    I added a line for the dm.dmPaperSize = 20 'Access help said that this number designated an 4 1/8" x 9 1/2" envelope

    I didn't need the last section which was designed to print a second page from a different paper tray.

    Once these modifications were made, I went into the code for the buttons designed to print an envelope report and added the line SetPaperSource("rptName"). This sets the paper size and source from any printer the user chooses to use.

    The major reason for a problem with envelopes is that each printer refers to the paper size name differently and on some printers the envelope tray feeds from the left and on some printers it feeds from the center.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  8. #8
    New Lounger
    Join Date
    Aug 2001
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing an Envelope

    Did you distribute this as an MDE? I'm using this 'fix' except when the MDE is generated, the user is not allowed in design mode allowing me to correct the damage. However, MS Access is still able to go in and change the reports so that they are unusable. Did you come across this? If so, how did you resolve it? The one difference is that I am using Access

Posting Permissions

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