VB Coding Help Please

[Scott_66701 via AccessMonster.com]

I'm trying to print 5 reports without the printer window popping up for each
report being printed. The reports are named "PCR1", "PCR2" etc. Can
someone please show me a code so that when I press the button it prints one
copy of all five reports without the printer window popping up to where you
have to press "OK" to print. Thank you

 

[AccessVandal via AccessMonster.com]

Try

DoCmd.OpenReport "NameofReport", acNormal

This will print to the default printer without any printer prompt.

 

[Scott_66701 via AccessMonster.com]

I tried but it doesn't do anything

Try

DoCmd.OpenReport "NameofReport", acNormal

This will print to the default printer without any printer prompt.

 

[Gina Whipp]

Scott,

Try...

DoCmd.OpenReport "PCR1", acViewNormal
DoCmd.OpenReport "PCR2", acViewNormal
DoCmd.OpenReport "PCR3", acViewNormal
DoCmd.OpenReport "PCR4", acViewNormal
DoCmd.OpenReport "PCR5", acViewNormal

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Scott_66701 via AccessMonster.com]

Still wont' do anything. Could someone copy and paste what the screen looks
like with the code in there so i can see what I'm doing wrong. Is there
suppose to be something before or after the code below?

Scott,

Try...

DoCmd.OpenReport "PCR1", acViewNormal
DoCmd.OpenReport "PCR2", acViewNormal
DoCmd.OpenReport "PCR3", acViewNormal
DoCmd.OpenReport "PCR4", acViewNormal
DoCmd.OpenReport "PCR5", acViewNormal

I tried but it doesn't do anything

[quoted text clipped - 12 lines]

 

[Gina Whipp]

Scott,

No screenshots allowed here.... Please copy/paste the below in the On_Click
event of the button on your form.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Still wont' do anything. Could someone copy and paste what the screen
looks
like with the code in there so i can see what I'm doing wrong. Is there
suppose to be something before or after the code below?

Scott,

Try...

DoCmd.OpenReport "PCR1", acViewNormal
DoCmd.OpenReport "PCR2", acViewNormal
DoCmd.OpenReport "PCR3", acViewNormal
DoCmd.OpenReport "PCR4", acViewNormal
DoCmd.OpenReport "PCR5", acViewNormal

I tried but it doesn't do anything

[quoted text clipped - 12 lines]

you
have to press "OK" to print. Thank you