Re: [MS_AccessPros] SetUp Printer Settings in a Report via VBA MS Access 2013

 

Norbert-

As of 2007, Reports have a Printer property.  You can rumble through the Application.Printers collection to find the one you want, then set the Printer property of the Report.  Not sure, but you perhaps can do that in the Open event of the Report.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Feb 21, 2015, at 5:31 PM, drnorbert@msn.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I have 4 printers for reports:

Default-

Checks-(Legal)

Label-(Dymo printer)

Duplex

When I make a change in my computer in a particular report and save it the printer properties change back to the Default printer.

The same happens if I imported all the objects of the database to a new database.

Also if I use FMS total Access Analyzer or Detective all the reports  settings change to the Default printer.

Therefore when I upload the database to the production program at the office I need to setup again many  reports to the corresponding printer. (about 235)

 

The solution will be if I can hard code the printer settings using perhaps PrtDevMode property however I am not very familiar how to apply this property or other to my issue.

Thanks 

Norbert  

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___