Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Dec 2001
    Location
    Houston
    Posts
    71
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Using VBA to designate report printer (97 SR-2 ==> XP)

    I have an application to distribute to folks in various departments, who use different printers. I would like to use VBA to designate the printer for a report to go to -- not only the printer name, but perhaps the margins as well. How can I do this? I use the Open Report event to enter the code and create a report object, but saw no properties that allowed me to set the printer or margins. So far I've only looked at it in 97, but plan to boost it up to XP before I'm done. Does either have a facility to allow me to do this? If so, how is it done?

    Dale Napier

  2. #2
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Nevada, USA
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using VBA to designate report printer (97 SR-2 ==> XP)

    Take a look at this thread .

    Hope it helps you.
    Carol W.

Posting Permissions

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