Home
Forums
New posts
Search forums
Articles
Latest reviews
Search resources
Members
Current visitors
Newsgroups
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Home
Forums
Newsgroups
Microsoft Access
Microsoft Access Reports
Page Setup with VBA
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
[QUOTE="Lamar, post: 13586766"] My office uses Access reports to print as labels using a local Dymo Label printer. So a user clicks a button and the Access report prints as a label with customer's address. I have ten people in my office that need to print multiple . So for each user I create their own report/label to print to their local Dymo printer (so that is 10 reports). Can use VBA to control the Page Setup of a report? I just want to use one report named "Label" that prints each user's local printer. So when user clicks the print label button I want the following to happen the Page Setup of the "Label" report: Printer change to 'Dymo Label Printer' Margins (inches): Top - 0.058" Bottom - 0.06" Left - 0.023" Right - 0.06" Page Orientation to 'Landscape' Paper Size to '30321 Large Address' It does not matter who is printing the label the dimension stay the same. I have to control this through Coding. Any help is appreciated. [/QUOTE]
Verification
Post reply
Home
Forums
Newsgroups
Microsoft Access
Microsoft Access Reports
Page Setup with VBA
Top