Change paper for each print

T

Tran Hong Quang

Hi,
I have default printer with default paper is letter. I have database with
some reports layout for letter and some other reports layout for A4. I would
like to schedule to print the report at given time. I need to change
printer's paper to my report's paper for each time it prints automatically.

How to change printer paper ?

Thanks
Quang
 
T

Tran Hong Quang

Last time I tried, it said that the page can not be found. Now it is working.
Thanks
 
T

Tran Hong Quang

This declaration raise error when compiling

Dim prt As Access.Printer

Which library do I have to add to "references..." ?

Regards
Tran Hong Quang
 
D

Dirk Goldgar

Tran Hong Quang said:
This declaration raise error when compiling

Dim prt As Access.Printer

Which library do I have to add to "references..." ?
Click to expand...

What version of Access are you using? The Printer object and Printers
collection were added with Access 2002. They didn't exist before that.
Notice that the KnowledgeBase article that Ofer pointed you to was for
Access 2002.
 
T

Tran Hong Quang

I'm using Ms Access 2000.

I have a look on the code. The report must be opened in design mode. Whether
it still work if I convert database into .mde ?

Regards
Tran Hong Quang
 
D

Dirk Goldgar

Tran Hong Quang said:
I'm using Ms Access 2000.

I have a look on the code. The report must be opened in design mode.
Whether it still work if I convert database into .mde ?
Click to expand...

I don't think you'll be able to open the report in design view in an
MDE. That may well limit your options. Perhaps the "On the Fly
Printing" module from ACG-Soft
(http://ourworld.compuserve.com/homepages/attac-cg/) could help. That's
not a free solution, but it's not very expensive.
 
Top