set a printer thru a form?

[Rover]

I want to set the printer for the report I run from a form. That is to
say, I always want to print on the same printer no matter what the
default printer is set to.

Jim

 

[Albert D. Kallal]

If you open a report in design mode, and then go file->page setup.

Any, and all settings you place in those settings (things like landscape,
and printer selected) will be saved.

So, in the page "tab" of the above...you can select, and save a specified
printer.

If your applciaton is used on more then one pc, or in a multi-user
envirment, then you might not need the aobve...and I can post you some code
soltions to switch the printer if you need.

 

[Rover]

I guess I should have indicated that I am running it multi-user
environment. I would appreciate the code.

Thanks in advance.

Jim

 

[Al Borges]

Hi Jim:

Since you can't change a form into design mode while using the runtime
environment, you have to temporarily change your default printer through
code, changing the Windows API, then change it back. It's pretty complicated
when using MS Access 2000 and older; I understand that with Access XP this
issue was improved. You can find the code in Getz's book "MS Access
Handbook".

Regards,
Al