Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1380
  • 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
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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