Is it possible to set Printer settings using VBA

[Gezza]

I have a need to be able to change Printer settings, specifically the Page Size, using VBA code. These are not standard Page Sizes but specific to a Sticky Label Printers attached to multible computers.
Is this possible? And if so how.
I have seen some code that nominates a specific printer picked from the Micosoft printers & faxes window, but I have not found where you can set the Page Settings.

Hope someone can help

Cheers
Gezza

 

[HiTechCoach]

I have a need to be able to change Printer settings, specifically the Page Size, using VBA code. These are not standard Page Sizes but specific to a Sticky Label Printers attached to multible computers.
Is this possible? And if so how.
I have seen some code that nominates a specific printer picked from the Micosoft printers & faxes window, but I have not found where you can set the Page Settings.

Hope someone can help

Cheers
Gezza

Gezza,

Starting with Access 2002, there is a new printer object that makes it easy.

See:
Programming Printer Settings in Microsoft Access
* This applies to Access 2002 and later

 

[Gezza]

Thanks for your reply,

I am currently running, Access 2001 is there a way to do it pre 2002?

 

[HiTechCoach]

Thanks for your reply,

I am currently running, Access 2001 is there a way to do it pre 2002?

With access 2000 and earlier, you have to work the Windows PrtDevMode Properties and PrtMip Properties

 

[Gezza]

I think we are getting close, but I have limited knowledge of the actual code to use or how to construct it. The links you have attached don't explain it enough with my limited knowedge. I did find a list of available paper sizes but the page size I am looking for is not in the list.