Solved

How to change printer from Access db

Posted on 2002-05-20
6
1,363 Views
Last Modified: 2007-11-27
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
Comment
Question by:iboutchkine
  • 4
  • 2
6 Comments
 
LVL 7

Accepted Solution

by:
lmerrell earned 50 total points
Comment Utility
Here's a link with some different methods.

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


lmerrell
0
 
LVL 7

Expert Comment

by:lmerrell
Comment Utility
You were close but you also need to set the PrtDevMode it appears.
0
 
LVL 7

Expert Comment

by:lmerrell
Comment Utility
I use a product called Print Batch Manager to do this as well.

http://ourworld.compuserve.com/homepages/attac-cg/ACGPBM.htm
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 28

Author Comment

by:iboutchkine
Comment Utility
thahk you imerell. I'll try it and let you know
0
 
LVL 28

Author Comment

by:iboutchkine
Comment Utility
It worked out perfect
0
 
LVL 7

Expert Comment

by:lmerrell
Comment Utility
Glad I could point you in the right direction.  Have a great day!

lmerrell
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now