8.5 by 14

[jbento]

All,
I am trying to change my reports in Access to have a default size of 8 1/2 by 14. I try to do this using Page Setup for the reports, but everytime I get out of Access it goes back to the original settings.

How can I make it always have the default of 8 1/2 by 14?

I hope someone can help me with this one.

Thanks in advance,

Jerome Benton
JERPAT Web Designs

http://www.jerpat.org

GOD Is Good All The Time!!!

 

[danvlas]

Quick fix: turn Name AutoCorrect off: Tools-Options-General

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[jbento]

danvlas,
I will try that now and let you know what happens.

Thanks,

Jerome Benton
JERPAT Web Designs

http://www.jerpat.org

GOD Is Good All The Time!!!

 

[jbento]

danvlas,
I went in and turned that feature off from my computer, and it doesn't work when another user tries to print from their computer.

It seems too me that on each individual computer it sets to their default setting. I would have to go into every user's machine and make changes, and that would be a total pain

Do you know of any other way to do this so that everyone would have the new settings?

This problem is beating me up. Once this problem is resolved, I can go live with this database.

Jerome Benton
JERPAT Web Designs

http://www.jerpat.org

GOD Is Good All The Time!!!

 

[danvlas]

Convert the db to mde and you'll get rid of the problem. Don't forget to keep the original mdb in a safe place...




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[jbento]

danvlas,
I tried making the mde file with all of the other settings you told me and it still doesn't work.

I found the below code on the Microsoft website, in the Knowledge Base section, and I can't get that to work either because I'm getting a "object not defined" error. I think this means I have to go in the References section of the code and add the reference, but I can't figure out which reference to add. Here is the code:

Assign the Printer Settings of the Object Directly
Another workaround is to programmatically set the printer settings of the object itself, instead of setting them to the Application.Printer property. Setting the individual properties of the object's Printer property is similar to the user manually changing printer settings within the Page Setup dialog box. When you programmatically set the object's printer settings directly, the settings are saved with the object automatically.

To set the object's printer settings directly, follow these steps:
Open the sample database Northwind.mdb.
Close the Main Switchboard form when it appears.
On the Insert menu, click Module.
Add the following Visual Basic for Applications code to the new module:Sub ChangePrinterSettingsForReport()
Dim rpt As Access.Report

DoCmd.OpenReport "Alphabetical List of Products", acPreview
Set rpt = Reports("Alphabetical List of Products&quot

'Set the default printer's orientation to landscape
rpt.Printer.Orientation = acPRORLandscape

'Set the default printer's paper size to legal
rpt.Printer.PaperSize = acPRPSLegal
End Sub

Click in the sample procedure above, and then on the Run menu, click Run Sub/UserForm.
On the File menu, click Close and Return to Microsoft Access.
On the File menu, click Page Setup, and then click the Page tab. Note that the report's Paper Size is set to Legal, and the Orientation is set to Landscape.
Close the report.
In the Database window, print preview the Alphabetical List of Products report again. Note that the printer settings were automatically saved with the report.
-----------------------------------------------------------

If you would like to see the entire article, go here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;290293&Product=acc2002

I hope you can help with this one.

Thanks in advance,

Jerome Benton
JERPAT Web Designs

http://www.jerpat.org

GOD Is Good All The Time!!!

 

[danvlas]

What Access version do you use? If Access 2000, you're out of luck, because the Printers collection was added in XP



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[jbento]

We have Office XP Professional at my job, so I do have the XP version of access.

So what do I do now?

Jerome Benton
JERPAT Web Designs

http://www.jerpat.org

GOD Is Good All The Time!!!