How to change printer of report in visual basic ?

Hi,

Who knows how i can change the printer in visual basic and also how to get a list of installed printers.

My problem is that when printing on different printers (of the same type) the report seems to forget the papersize and the paperfeeder.
Not on my pc but when i install it on a pc of a user who uses another printer (but same type).

I have som reports printing on B5 and some on A4, A5 from the envelopetray and A4 from tray 1. But when the user adds a new printer the settings in the reports are set to the defaults (A4 and auto).

The user prints on different printers, using different applications, and i would like to select the printer automatically in my access application. So the user doesn't have the change his default printer every time he starts my application.
jan_l_keersmaekersAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jan_l_keersmaekersAuthor Commented:
Can i change the default printer using code in ms access 97.

In visual basic
dim x as printer
for x=1 to printers
set x....

But how can i do this in MS Access ?
0
believerCommented:
Check out question 10115162. It covers the same topic you are asking about.

Good Luck,
Believer
0
jan_l_keersmaekersAuthor Commented:
How do i find question 10115162 ?
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

believerCommented:
Well, that's a good question.  I hear the experts referencing questions by number, but I get skunked when I try to search for a question by number.  Maybe you can only search by keywords. Maybe another expert will tell us how to find a question by using the number.

Try Printer, or default ???

Believer
0
believerCommented:
P.S.

The search option is at each topic level.
0
believerCommented:
Here is the answer I received from EE tech support when I asked about the search feature. Seems like I was leaving out the url:


Hi,

I see the problem, the search engine searches for text, not question
numbers.

All Experts Exchange questions are prefixed with

http://www.experts-exchange.com/EQ.

So the url you need is
http://www.experts-exchange.com/jsp/qShow.jsp?ta=msaccess&qid=10115162 

Ian
Community Support @ Experts Exchange

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jan_l_keersmaekersAuthor Commented:
Yes,  when i was looking a the screen i suddenly found it.
0
jan_l_keersmaekersAuthor Commented:
Happy Holydays
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.