Report page setup properties

[ARC]

I have reports that are designed to where it doesn't matter if the region
using the program uses a letter sized paper or A4 sized. I have the width to
be just slightly over 7", so the reports work with either paper size.

However, in Access 2007, one of my testers in Australia is now getting a
beep from his printer telling him to change paper to letter sized. The
reports worked fine in Access 97, but in 2007, he's getting the printer
prompt.

If I go into design mode on the reports, the only option I can see under
page setup is Paper 1) Size. which I can't really change on the fly (at
least I don't think), and 2) Source. Currently this is set to "Automatically
Select" and the other option is "Auto Sheet Feeder". There's no help on this
screen so I'm unsure if setting all reports to auto sheet feeder will do any
good.

Any ideas?

Thanks!

Andy

P.S. Here's the text of his e-mail, in case it gives more clues: "Windows is
set to A4 size, when I print from the new program it changes the paper size
to Letter and the printer can't find Letter size in its trays, so it beep
and asks for the correct size paper to be fitted. Still works fine from old
IQ its just something about the new one. When I go back in to Printer setup
in windows the default is still A4 but IQ shows it as Letter, not sure
about this one"

[Salad]

ARC wrote:

I have reports that are designed to where it doesn't matter if the
region using the program uses a letter sized paper or A4 sized. I have
the width to be just slightly over 7", so the reports work with either
paper size.

However, in Access 2007, one of my testers in Australia is now getting a
beep from his printer telling him to change paper to letter sized. The
reports worked fine in Access 97, but in 2007, he's getting the printer
prompt.

If I go into design mode on the reports, the only option I can see under
page setup is Paper 1) Size. which I can't really change on the fly (at
least I don't think), and 2) Source. Currently this is set to
"Automatically Select" and the other option is "Auto Sheet Feeder".
There's no help on this screen so I'm unsure if setting all reports to
auto sheet feeder will do any good.

Any ideas?

Is there a new print driver for Vista?

>
Thanks!

Andy

P.S. Here's the text of his e-mail, in case it gives more clues:
"Windows is set to A4 size, when I print from the new program it changes
the paper size to Letter and the printer can't find Letter size in its
trays, so it beep and asks for the correct size paper to be fitted.
Still works fine from old IQ its just something about the new one. When
I go back in to Printer setup in windows the default is still A4 but IQ
shows it as Letter, not sure about this one"

[ARC]

It could be his printer driver. I set my paper size to A4 in the windows
control panel (I have vista), and the form printed without problems.

Very strange... being that he can print fine out of the previous release in
access 97 (he's running both side by side), maybe it's a combination of the
print driver and office 2007?
"Salad" <oi*@vinegar.comwrote in message
news:13*************@corp.supernews.com...

ARC wrote:

>I have reports that are designed to where it doesn't matter if the region
using the program uses a letter sized paper or A4 sized. I have the width
to be just slightly over 7", so the reports work with either paper size.

However, in Access 2007, one of my testers in Australia is now getting a
beep from his printer telling him to change paper to letter sized. The
reports worked fine in Access 97, but in 2007, he's getting the printer
prompt.

If I go into design mode on the reports, the only option I can see under
page setup is Paper 1) Size. which I can't really change on the fly (at
least I don't think), and 2) Source. Currently this is set to
"Automatically Select" and the other option is "Auto Sheet Feeder".
There's no help on this screen so I'm unsure if setting all reports to
auto sheet feeder will do any good.

Any ideas?

Is there a new print driver for Vista?

>>
Thanks!

Andy

P.S. Here's the text of his e-mail, in case it gives more clues: "Windows
is set to A4 size, when I print from the new program it changes the paper
size to Letter and the printer can't find Letter size in its trays, so it
beep and asks for the correct size paper to be fitted. Still works fine
from old IQ its just something about the new one. When I go back in to
Printer setup in windows the default is still A4 but IQ shows it as
Letter, not sure about this one"

[ARC]

I think I figued the problem. When updating my new version for acc2007, I
got rid of the old method of setting / changes printers by using a printers
module I found on the access web. A few weeks ago, a user posted that, if
you have a newer version of access, you could dump this code, and just use
the application.printer object!

From looking at MS's site, there is one failing with the appliation.printer
object: It won't automatically assume the page settings from the selected
printer! So...so much for totally dumping the old way of doing it, as at
least this inherited the paper size. Here's the MS arcitle. I'm not sure
which way to go now:

http://support.microsoft.com/kb/290293/en-us

They give 2 choices, but I'm dealing with a bunch of reports. So I could use
one of them, or do the 3rd choice of going back to the print module (a royal
pain, as I had to change many areas of code).

I suppose I could just have a on_open function that I put on each of my
hundred or so reports (do'oh!) that runs one of the options in the above
link.

Andy

"Salad" <oi*@vinegar.comwrote in message
news:13*************@corp.supernews.com...

ARC wrote:

>I have reports that are designed to where it doesn't matter if the region
using the program uses a letter sized paper or A4 sized. I have the width
to be just slightly over 7", so the reports work with either paper size.

However, in Access 2007, one of my testers in Australia is now getting a
beep from his printer telling him to change paper to letter sized. The
reports worked fine in Access 97, but in 2007, he's getting the printer
prompt.

If I go into design mode on the reports, the only option I can see under
page setup is Paper 1) Size. which I can't really change on the fly (at
least I don't think), and 2) Source. Currently this is set to
"Automatically Select" and the other option is "Auto Sheet Feeder".
There's no help on this screen so I'm unsure if setting all reports to
auto sheet feeder will do any good.

Any ideas?

Is there a new print driver for Vista?

>>
Thanks!

Andy

P.S. Here's the text of his e-mail, in case it gives more clues: "Windows
is set to A4 size, when I print from the new program it changes the paper
size to Letter and the printer can't find Letter size in its trays, so it
beep and asks for the correct size paper to be fitted. Still works fine
from old IQ its just something about the new one. When I go back in to
Printer setup in windows the default is still A4 but IQ shows it as
Letter, not sure about this one"

[Salad]

ARC wrote:

I think I figued the problem. When updating my new version for acc2007,
I got rid of the old method of setting / changes printers by using a
printers module I found on the access web. A few weeks ago, a user
posted that, if you have a newer version of access, you could dump this
code, and just use the application.printer object!

From looking at MS's site, there is one failing with the
appliation.printer object: It won't automatically assume the page
settings from the selected printer! So...so much for totally dumping the
old way of doing it, as at least this inherited the paper size. Here's
the MS arcitle. I'm not sure which way to go now:

http://support.microsoft.com/kb/290293/en-us

They give 2 choices, but I'm dealing with a bunch of reports. So I could
use one of them, or do the 3rd choice of going back to the print module
(a royal pain, as I had to change many areas of code).

I suppose I could just have a on_open function that I put on each of my
hundred or so reports (do'oh!) that runs one of the options in the above
link.

If you need to do that...look at the module object. Look at the Find
method as well as InsertText and InsertLines methods and of course the
code examples. See if the report has a module. If not, you might need
to set the HasModule to true. Then look for the OnOpen event of the
report. If if doesn't exist, create one with the code you want. If it
does exist, the code to write the lines. That might be quicker than
going into each report and updating.

>
Andy

"Salad" <oi*@vinegar.comwrote in message
news:13*************@corp.supernews.com...

>ARC wrote:

>>I have reports that are designed to where it doesn't matter if the
region using the program uses a letter sized paper or A4 sized. I
have the width to be just slightly over 7", so the reports work with
either paper size.

However, in Access 2007, one of my testers in Australia is now
getting a beep from his printer telling him to change paper to letter
sized. The reports worked fine in Access 97, but in 2007, he's
getting the printer prompt.

If I go into design mode on the reports, the only option I can see
under page setup is Paper 1) Size. which I can't really change on the
fly (at least I don't think), and 2) Source. Currently this is set to
"Automatically Select" and the other option is "Auto Sheet Feeder".
There's no help on this screen so I'm unsure if setting all reports
to auto sheet feeder will do any good.

Any ideas?

Is there a new print driver for Vista?

>>>
Thanks!

Andy

P.S. Here's the text of his e-mail, in case it gives more clues:
"Windows is set to A4 size, when I print from the new program it
changes the paper size to Letter and the printer can't find Letter
size in its trays, so it beep and asks for the correct size paper to
be fitted. Still works fine from old IQ its just something about the
new one. When I go back in to Printer setup in windows the default is
still A4 but IQ shows it as Letter, not sure about this one"