Change paper for each print

's Computer Specifications

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

's Computer Specifications

I haven't try it, but check this link

http://support.microsoft.com/default...b;en-us;279506

--
HTH, Good Luck
BS"D

"Tran Hong Quang" wrote:

> 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

's Computer Specifications

That link is not valid.

Regards
Tran Hong Quang

"Ofer Cohen" wrote:

> I haven't try it, but check this link
>
> http://support.microsoft.com/default...b;en-us;279506
>
> --
> HTH, Good Luck
> BS"D
>
>
> "Tran Hong Quang" wrote:
>
> > 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

's Computer Specifications

Worked for me.

On Mon, 17 Apr 2006 06:34:01 -0700, Tran Hong Quang
<(E-Mail Removed)> wrote:

>That link is not valid.
>
>Regards
>Tran Hong Quang
>
>"Ofer Cohen" wrote:
>
>> I haven't try it, but check this link
>>
>> http://support.microsoft.com/default...b;en-us;279506
>>
>> --
>> HTH, Good Luck
>> BS"D
>>
>>
>> "Tran Hong Quang" wrote:
>>
>> > 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

's Computer Specifications

Worked for me.
--
James Gaylord
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf

"Tran Hong Quang" wrote:

> That link is not valid.
>
> Regards
> Tran Hong Quang
>
> "Ofer Cohen" wrote:
>
> > I haven't try it, but check this link
> >
> > http://support.microsoft.com/default...b;en-us;279506
> >
> > --
> > HTH, Good Luck
> > BS"D
> >
> >
> > "Tran Hong Quang" wrote:
> >
> > > 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

's Computer Specifications

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

"Cyberwolf" wrote:

> Worked for me.
> --
> James Gaylord
> Finder of Paths, Hunter of Prey
> Ghost of the Night, Shadow of Day
> The Wolf
>
>
> "Tran Hong Quang" wrote:
>
> > That link is not valid.
> >
> > Regards
> > Tran Hong Quang
> >
> > "Ofer Cohen" wrote:
> >
> > > I haven't try it, but check this link
> > >
> > > http://support.microsoft.com/default...b;en-us;279506
> > >
> > > --
> > > HTH, Good Luck
> > > BS"D
> > >
> > >
> > > "Tran Hong Quang" wrote:
> > >
> > > > 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

's Computer Specifications

This declaration raise error when compiling

Dim prt As Access.Printer

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

Regards
Tran Hong Quang

"Ofer Cohen" wrote:

> I haven't try it, but check this link
>
> http://support.microsoft.com/default...b;en-us;279506
>
> --
> HTH, Good Luck
> BS"D
>
>
> "Tran Hong Quang" wrote:
>
> > 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

's Computer Specifications

"Tran Hong Quang" <(E-Mail Removed)> wrote in
message news:0DDC990E-C7B3-4D9D-ACA2-(E-Mail Removed)
> 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.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

's Computer Specifications

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" wrote:

> "Tran Hong Quang" <(E-Mail Removed)> wrote in
> message news:0DDC990E-C7B3-4D9D-ACA2-(E-Mail Removed)
> > 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.
>
> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> (please reply to the newsgroup)
>
>
>

's Computer Specifications

"Tran Hong Quang" <(E-Mail Removed)> wrote in
message news:71927355-B27C-4B10-A9C2-(E-Mail Removed)
> 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.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
OL2003 print options -change page size w/o changing paper size	=?Utf-8?B?a3JlbmVl?=	Microsoft Outlook Calendar	0	30th Nov 2005 06:42 PM
How do i get VBA to change the size of paper to print on	=?Utf-8?B?U3R1Sm9s?=	Microsoft Access Reports	1	11th Sep 2005 04:17 PM
How can i Print/Change Expon paper Configuration test page	TAUSEEF	Printers	2	10th Jul 2005 12:45 AM
Can I use print deluxe or print artist on avery paper 3275?	=?Utf-8?B?Zmxvc3NpZWo1NkBob3RtYWlsLmNvbQ==?=	Microsoft Access	1	8th Mar 2005 07:48 PM
Paper size in print setup won't change	=?Utf-8?B?SE1O?=	Microsoft Access	1	17th Dec 2004 07:19 AM