473,898 Members | 2,344 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 "Automatica lly
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"

Oct 11 '07 #1
4 9500
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
"Automatica lly 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"
Oct 11 '07 #2
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.co mwrote in message
news:13******** *****@corp.supe rnews.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
"Automatical ly 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"
Oct 11 '07 #3
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.pri nter object!

From looking at MS's site, there is one failing with the appliation.prin ter
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.co mwrote in message
news:13******** *****@corp.supe rnews.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
"Automatical ly 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"
Oct 11 '07 #4
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.pri nter object!

From looking at MS's site, there is one failing with the
appliation.prin ter 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.co mwrote in message
news:13******** *****@corp.supe rnews.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
"Automaticall y 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"
Oct 11 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
12427
by: Shiz | last post by:
I currently have a Form with Option buttons (to give you the option of sorting by name, or by Field, etc), these are referenced in a module which then formats the report contingent on the option chosen (i.e. the title changes to say "Sorted by Name" or "Sorted by Field"). For one of the options, "Sort by Field" I would not only like to have them sorted by Field alphabetically, but I would like to Group them and have a Group Header and...
15
13367
by: Mark C | last post by:
All, I have exhaustingly been looking through the newsgroups in search of a way to systemically output an Access 97 report to a pdf file using the full version of Adobe Acrobat. I want the user to be able to click a button and have the Access report saved as a pdf in a directory specified by me the programmer. I have seen a posting by John Baker promoting a web-sight that has an mde that one can reference in any database but after 30...
6
3321
by: Mike Conklin | last post by:
This one really has me going. Probably something silly. I'm using dcount for a report to determine the number of different types of tests proctored in a semester. My report is based on a parameter query which is the recordsource for the report. The parameter is <=. The query returns the correct amounts upto the date entered (no need for "between" dates here). There are 8 textboxes with dcounts; 2 other boxes Sum some of these
5
4157
by: bcanavan | last post by:
When I export xml(and xls) from Access 2003 the result is a complete report in a single page. I would like to get the entire report in a single page (one trip to the server) for printing and scrolling-preview, but with page breaks and page numbering appropriate to the paper size. I have a sense that this can be done in xsl, since xsl defines the format for everything else in the report. My goal is to avoid the time and expense of...
0
2730
by: Henry | last post by:
I have written an ASP/VB.Net application via VS 2003 (Crystal V9) that uses MS Access 2000 as its database. I can export reports that have no linked sub reports for printing. However, I'm unable to export reports that have linked subreports. I receive (a "Missing parameter field current value") on the following statement: Me.crReportDocument.Export() The main report requires 4 parameters. The linked reports do not require any...
7
27709
by: steve | last post by:
Hi All I need to change text in a Report Viewer document at runtime It is just the heading I want to change to match what the user has chosen as the Report to view How do I access the textbox in "GymMaster.Memberships.rdlc" (below) to change the text sql = "select * from members order by surname"
7
21755
by: steve | last post by:
Hi All I have created rdlc files and when I load them into Report Viewer at run time they appear OK If I click on 'Print layout' button on Report Viewer the view again appears acceptable If I click on 'Page setup' button the margins left & right are not what I set on the rdlc file at design time (1.5cm) they are 5.9mm
1
2330
by: Daniele | last post by:
I have to create a report, that contains in the section body a list of record. For every record it has to appear an incremental additional field that begins from One; when he reaches the record 50, it is had to activate a page break and the following record leaves again with numeration equal to one. How can I do?
3
18724
by: creative1 | last post by:
Here is how you create a complex data report that involves parent and child commands and you can update information at runtime. Its pretty straight forward to work with simple queries; however, working with complex reports is tricky Assumption: Reader of this article have basic knowledge of creating data reports. Creating a Parent-Child Command and create a DataReport Suppose we have a database called company with two tables ...
0
9839
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
10946
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9658
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
7187
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5877
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6076
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4705
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4295
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3303
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.