Change paper for each print

[Guest]

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

 

[Guest]

I haven't try it, but check this link

http://support.microsoft.com/default.aspx?scid=kb;en-us;279506

 

[Guest]

That link is not valid.

Regards
Tran Hong Quang

I haven't try it, but check this link

http://support.microsoft.com/default.aspx?scid=kb;en-us;279506

 

[RD]

Worked for me.

That link is not valid.

Regards
Tran Hong Quang

 

[Guest]

Worked for me.

 

[Guest]

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

 

[Guest]

This declaration raise error when compiling

Dim prt As Access.Printer

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

Regards
Tran Hong Quang

 

[Dirk Goldgar]

This declaration raise error when compiling

Dim prt As Access.Printer

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

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.

 

[Guest]

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

 

[Dirk Goldgar]

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 ?

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.