• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1378
  • Last Modified:

How to change printer from Access db

I want to change default printer programatically from Access database.  I know how to do it from VB, but it looks like Access VBA does not have Printers collection. I was trying to change rpt.PrtDevName = MyPrinterName, but did not manage to make it work.
Any help will be appreciated.
0
iboutchkine
Asked:
iboutchkine
  • 4
  • 2
1 Solution
 
lmerrellCommented:
Here's a link with some different methods.

http://www.mvps.org/access/reports/rpt0009.htm


lmerrell
0
 
lmerrellCommented:
You were close but you also need to set the PrtDevMode it appears.
0
 
lmerrellCommented:
I use a product called Print Batch Manager to do this as well.

http://ourworld.compuserve.com/homepages/attac-cg/ACGPBM.htm
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
iboutchkineAuthor Commented:
thahk you imerell. I'll try it and let you know
0
 
iboutchkineAuthor Commented:
It worked out perfect
0
 
lmerrellCommented:
Glad I could point you in the right direction.  Have a great day!

lmerrell
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now