A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

change default printer of a report



 
 
Thread Tools Display Modes
  #1  
Old July 21st, 2004, 01:54 PM
Rodolfo Fontes
external usenet poster
 
Posts: n/a
Default change default printer of a report

Hi group,

I've done a form that can choose between avaibles objects and printers.
When I select a report early configured to printer "X", and i choose a
printer "Y", an error message appears, to choose a printer.
Is there anyway to select a blank printer for a report? or to do not
appear this message?

Access Version: 2000

ps: I didn't put the error message over here, since my office is portuguese
(Brasil).

Thanks,
Rodolfo Fontes


  #2  
Old July 21st, 2004, 03:23 PM
Fons Ponsioen
external usenet poster
 
Posts: n/a
Default change default printer of a report

I think the way to approach this is to set the report to
print to the default printer and than select an other
printer by using the file -print menu options.
The way to set the report to print to the default printer
is to open the report in design view, than select the
file - page setup option, click on the page tab and click
at the default printer option checkbox.
Hope this helps.
Fons
-----Original Message-----
Hi group,

I've done a form that can choose between avaibles

objects and printers.
When I select a report early configured to

printer "X", and i choose a
printer "Y", an error message appears, to choose a

printer.
Is there anyway to select a blank printer for a

report? or to do not
appear this message?

Access Version: 2000

ps: I didn't put the error message over here, since my

office is portuguese
(Brasil).

Thanks,
Rodolfo Fontes


.

  #3  
Old July 21st, 2004, 05:56 PM
Rodolfo Fontes
external usenet poster
 
Posts: n/a
Default change default printer of a report

I think it's more than that as the error message just give the option to
print on the default printer of the system (windows) or to select one. I can
select, but since i've already selected one on the form, i wanna force on
that printer without warnings.
Do you know something?

Thanks for helping
Rodolfo Fontes

"Fons Ponsioen" escreveu na mensagem
...
I think the way to approach this is to set the report to
print to the default printer and than select an other
printer by using the file -print menu options.
The way to set the report to print to the default printer
is to open the report in design view, than select the
file - page setup option, click on the page tab and click
at the default printer option checkbox.
Hope this helps.
Fons
-----Original Message-----
Hi group,

I've done a form that can choose between avaibles

objects and printers.
When I select a report early configured to

printer "X", and i choose a
printer "Y", an error message appears, to choose a

printer.
Is there anyway to select a blank printer for a

report? or to do not
appear this message?

Access Version: 2000

ps: I didn't put the error message over here, since my

office is portuguese
(Brasil).

Thanks,
Rodolfo Fontes


.



  #4  
Old July 21st, 2004, 06:08 PM
Fons Ponsioen
external usenet poster
 
Posts: n/a
Default change default printer of a report

Rodolfo, Is your report in the page setup set for the
default printer?
Fons
-----Original Message-----
I think it's more than that as the error message just

give the option to
print on the default printer of the system (windows) or

to select one. I can
select, but since i've already selected one on the form,

i wanna force on
that printer without warnings.
Do you know something?

Thanks for helping
Rodolfo Fontes

"Fons Ponsioen"

escreveu na mensagem
...
I think the way to approach this is to set the report to
print to the default printer and than select an other
printer by using the file -print menu options.
The way to set the report to print to the default

printer
is to open the report in design view, than select the
file - page setup option, click on the page tab and

click
at the default printer option checkbox.
Hope this helps.
Fons
-----Original Message-----
Hi group,

I've done a form that can choose between avaibles

objects and printers.
When I select a report early configured to

printer "X", and i choose a
printer "Y", an error message appears, to choose a

printer.
Is there anyway to select a blank printer for a

report? or to do not
appear this message?

Access Version: 2000

ps: I didn't put the error message over here, since my

office is portuguese
(Brasil).

Thanks,
Rodolfo Fontes


.



.

  #5  
Old July 21st, 2004, 06:48 PM
Rodolfo Fontes
external usenet poster
 
Posts: n/a
Default change default printer of a report

yes, and i've tried to set it to "selected printer"

Rodolfo Fontes

"Fons Ponsioen" escreveu na mensagem
...
Rodolfo, Is your report in the page setup set for the
default printer?
Fons
-----Original Message-----
I think it's more than that as the error message just

give the option to
print on the default printer of the system (windows) or

to select one. I can
select, but since i've already selected one on the form,

i wanna force on
that printer without warnings.
Do you know something?

Thanks for helping
Rodolfo Fontes

"Fons Ponsioen"

escreveu na mensagem
...
I think the way to approach this is to set the report to
print to the default printer and than select an other
printer by using the file -print menu options.
The way to set the report to print to the default

printer
is to open the report in design view, than select the
file - page setup option, click on the page tab and

click
at the default printer option checkbox.
Hope this helps.
Fons
-----Original Message-----
Hi group,

I've done a form that can choose between avaibles
objects and printers.
When I select a report early configured to
printer "X", and i choose a
printer "Y", an error message appears, to choose a
printer.
Is there anyway to select a blank printer for a
report? or to do not
appear this message?

Access Version: 2000

ps: I didn't put the error message over here, since my
office is portuguese
(Brasil).

Thanks,
Rodolfo Fontes


.



.



  #6  
Old July 21st, 2004, 07:22 PM
Fons Ponsioen
external usenet poster
 
Posts: n/a
Default change default printer of a report

Rodolfo, did this change anything, will your report print
to your default printer?
Fons
-----Original Message-----
yes, and i've tried to set it to "selected printer"

Rodolfo Fontes

"Fons Ponsioen"

escreveu na mensagem
...
Rodolfo, Is your report in the page setup set for the
default printer?
Fons
-----Original Message-----
I think it's more than that as the error message just

give the option to
print on the default printer of the system (windows) or

to select one. I can
select, but since i've already selected one on the

form,
i wanna force on
that printer without warnings.
Do you know something?

Thanks for helping
Rodolfo Fontes

"Fons Ponsioen"

escreveu na mensagem
...
I think the way to approach this is to set the

report to
print to the default printer and than select an other
printer by using the file -print menu options.
The way to set the report to print to the default

printer
is to open the report in design view, than select the
file - page setup option, click on the page tab and

click
at the default printer option checkbox.
Hope this helps.
Fons
-----Original Message-----
Hi group,

I've done a form that can choose between

avaibles
objects and printers.
When I select a report early configured to
printer "X", and i choose a
printer "Y", an error message appears, to choose a
printer.
Is there anyway to select a blank printer for a
report? or to do not
appear this message?

Access Version: 2000

ps: I didn't put the error message over here, since

my
office is portuguese
(Brasil).

Thanks,
Rodolfo Fontes


.



.



.

  #7  
Old July 21st, 2004, 08:46 PM
Rodolfo Fontes
external usenet poster
 
Posts: n/a
Default change default printer of a report

No, the only thing that changes is that with this option, the report will be
set to a specified printer...
Even with this, that warning message appears while choosing another printer.

Rodolfo Fontes

"Fons Ponsioen" escreveu na mensagem
...
Rodolfo, did this change anything, will your report print
to your default printer?
Fons
-----Original Message-----
yes, and i've tried to set it to "selected printer"

Rodolfo Fontes

"Fons Ponsioen"

escreveu na mensagem
...
Rodolfo, Is your report in the page setup set for the
default printer?
Fons
-----Original Message-----
I think it's more than that as the error message just
give the option to
print on the default printer of the system (windows) or
to select one. I can
select, but since i've already selected one on the

form,
i wanna force on
that printer without warnings.
Do you know something?

Thanks for helping
Rodolfo Fontes

"Fons Ponsioen"
escreveu na mensagem
...
I think the way to approach this is to set the

report to
print to the default printer and than select an other
printer by using the file -print menu options.
The way to set the report to print to the default
printer
is to open the report in design view, than select the
file - page setup option, click on the page tab and
click
at the default printer option checkbox.
Hope this helps.
Fons
-----Original Message-----
Hi group,

I've done a form that can choose between

avaibles
objects and printers.
When I select a report early configured to
printer "X", and i choose a
printer "Y", an error message appears, to choose a
printer.
Is there anyway to select a blank printer for a
report? or to do not
appear this message?

Access Version: 2000

ps: I didn't put the error message over here, since

my
office is portuguese
(Brasil).

Thanks,
Rodolfo Fontes


.



.



.



  #8  
Old July 21st, 2004, 09:00 PM
Fons Ponsioen
external usenet poster
 
Posts: n/a
Default change default printer of a report

I think I do not understand exactly when you get the
error. Is this while you are previewing the report and
than slecting print from the file menu? And what is the
translation of the error message?
Do you have the proper printer drivers installed for each
of the desktops?
Fons
-----Original Message-----
No, the only thing that changes is that with this option,

the report will be
set to a specified printer...
Even with this, that warning message appears while

choosing another printer.

Rodolfo Fontes

"Fons Ponsioen"

escreveu na mensagem
...
Rodolfo, did this change anything, will your report

print
to your default printer?
Fons
-----Original Message-----
yes, and i've tried to set it to "selected printer"

Rodolfo Fontes

"Fons Ponsioen"

escreveu na mensagem
...
Rodolfo, Is your report in the page setup set for

the
default printer?
Fons
-----Original Message-----
I think it's more than that as the error message

just
give the option to
print on the default printer of the system

(windows) or
to select one. I can
select, but since i've already selected one on the

form,
i wanna force on
that printer without warnings.
Do you know something?

Thanks for helping
Rodolfo Fontes

"Fons Ponsioen"


escreveu na mensagem
...
I think the way to approach this is to set the

report to
print to the default printer and than select an

other
printer by using the file -print menu options.
The way to set the report to print to the default
printer
is to open the report in design view, than select

the
file - page setup option, click on the page tab

and
click
at the default printer option checkbox.
Hope this helps.
Fons
-----Original Message-----
Hi group,

I've done a form that can choose between

avaibles
objects and printers.
When I select a report early configured to
printer "X", and i choose a
printer "Y", an error message appears, to choose

a
printer.
Is there anyway to select a blank printer

for a
report? or to do not
appear this message?

Access Version: 2000

ps: I didn't put the error message over here,

since
my
office is portuguese
(Brasil).

Thanks,
Rodolfo Fontes


.



.



.



.

  #9  
Old July 21st, 2004, 09:35 PM
Rodolfo Fontes
external usenet poster
 
Posts: n/a
Default change default printer of a report

I've done a form where the user can select a printer to print the selected
report.
The selected report is set to use a specified printer. But as we use the
software on WTS (Windows Terminal Services) the printer name is always
changing, adding "printer xxx on sesson1", "printer xxx on sesson2", and
on...
This Form, where the user can choose the report and the printer to print it,
was done for that case.
So, the warning message appears and give the option, to choose between:
1 - use the default printer (sometimes the user can set another one, so this
isn't helpfull)
2 - Cancel (don't print)
3 - configure (here you go to the page setup settings, where you can choose
AGAIN or to print on default printer or selected printer)
4 - help

Sorry for not passing this information early.

Thanks,
Rodolfo Fontes

"Fons Ponsioen" escreveu na mensagem
...
I think I do not understand exactly when you get the
error. Is this while you are previewing the report and
than slecting print from the file menu? And what is the
translation of the error message?
Do you have the proper printer drivers installed for each
of the desktops?
Fons
-----Original Message-----
No, the only thing that changes is that with this option,

the report will be
set to a specified printer...
Even with this, that warning message appears while

choosing another printer.

Rodolfo Fontes

"Fons Ponsioen"

escreveu na mensagem
...
Rodolfo, did this change anything, will your report

print
to your default printer?
Fons
-----Original Message-----
yes, and i've tried to set it to "selected printer"

Rodolfo Fontes

"Fons Ponsioen"
escreveu na mensagem
...
Rodolfo, Is your report in the page setup set for

the
default printer?
Fons
-----Original Message-----
I think it's more than that as the error message

just
give the option to
print on the default printer of the system

(windows) or
to select one. I can
select, but since i've already selected one on the
form,
i wanna force on
that printer without warnings.
Do you know something?

Thanks for helping
Rodolfo Fontes

"Fons Ponsioen"


escreveu na mensagem
...
I think the way to approach this is to set the
report to
print to the default printer and than select an

other
printer by using the file -print menu options.
The way to set the report to print to the default
printer
is to open the report in design view, than select

the
file - page setup option, click on the page tab

and
click
at the default printer option checkbox.
Hope this helps.
Fons
-----Original Message-----
Hi group,

I've done a form that can choose between
avaibles
objects and printers.
When I select a report early configured to
printer "X", and i choose a
printer "Y", an error message appears, to choose

a
printer.
Is there anyway to select a blank printer

for a
report? or to do not
appear this message?

Access Version: 2000

ps: I didn't put the error message over here,

since
my
office is portuguese
(Brasil).

Thanks,
Rodolfo Fontes


.



.



.



.



  #10  
Old July 21st, 2004, 10:32 PM
Albert D. Kallal
external usenet poster
 
Posts: n/a
Default change default printer of a report

The best solution:


First, leave ALL REPORTS set to DEFAULT PRINTER.

Next:

In your form that prompts the user for the printer, you simply SET the
default printer,a nd then print the report.

When done, you simply set the printer back to the previous printer
setting.

You don't mention what version of ms-access. Acces2002 and later has a built
in printer object that lets you change the printer.

If you are using an earlier version, then grab my printer switch code.

So, just remember to leave ALL REPORTS to DEFAULT printer (this means that
you do NOT set a specify printer for each report).
You don't mention what version\ of ms-access.

So, In access 2002 and later, there is a built in printer object, and it
lets you switch the printer with ease.

You can use:

Set Application.Printer = Application.Printers("HP LaserJet Series II")


The above means you don't need my code.

So, to save/switch, you can use:

dim strDefaultPrinter as string

' get current default printer.
strDefaultPrinter = Application.Printer.DeviceName

' switch to printer of your choice:

Set Application.Printer = Application.Printers("HP LaserJet Series II")

do whatever.

Swtich back.

Set Application.Printer = Application.Printers(strDefaultPrinter)


If you are using a earlier versions, then you can use my lightweight printer
switch code he

http://www.attcanada.net/~kallal.msn.../msaccess.html

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.attcanada.net/~kallal.msn


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Display Parameter from Form on Report sara Setting Up & Running Reports 10 July 19th, 2004 04:54 PM
Save Report With CreateReport Coding Issue Jeff Conrad Setting Up & Running Reports 8 July 12th, 2004 08:39 AM
Default printer setting not used. Jim O'Rourke Setting Up & Running Reports 0 June 10th, 2004 05:03 AM
Returning to Default Printer Ken General Discussion 4 June 5th, 2004 08:17 AM


All times are GMT +1. The time now is 06:03 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.