Loosing Printer Settings - Microsoft Access / VBA

Paul

I am hoping that some intelligent user in this group will be able to solve a
major problem I'm having.

I have a report in Access 97 SR2, that is set up as LEGAL, LANDSCAPE. But,
every time I run the report it reverts the printer settings to LETTER,
PORTRAIT. I know this problem exists in A2K. I tried the A2K "Autocorrect"
solution in 97, but it did not work...as I expected it not too...but it was
worth a try.

I have a medium amount of working knowledge in using VBA Code (enough to get
me by). Can anyone explain how to do this? I have looked on Google and
found a source, but it is incredibly complicated and it does not say where
to enter the code and where to call the code from.

I would truly appreciate any help.

Thanks,
Paul

Nov 13 '05 #1

Subscribe Post Reply

1487

Rick Brandt

"Paul" <pz****@rogers.com> wrote in message
news:2b********************@rogers.com...

I am hoping that some intelligent user in this group will be able to solve a
major problem I'm having.

I have a report in Access 97 SR2, that is set up as LEGAL, LANDSCAPE. But,
every time I run the report it reverts the printer settings to LETTER,
PORTRAIT. I know this problem exists in A2K. I tried the A2K "Autocorrect"
solution in 97, but it did not work...as I expected it not too...but it was
worth a try.

I have a medium amount of working knowledge in using VBA Code (enough to get
me by). Can anyone explain how to do this? I have looked on Google and found
a source, but it is incredibly complicated and it does not say where to enter
the code and where to call the code from.

I would truly appreciate any help.

Does your printer support legal paper?

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #2

Paul

Yes. I have tested previewing and printing and there are no problems.

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:0I****************@newssvr11.news.prodigy.com ...

"Paul" <pz****@rogers.com> wrote in message
news:2b********************@rogers.com...
I am hoping that some intelligent user in this group will be able to solve
a major problem I'm having.

I have a report in Access 97 SR2, that is set up as LEGAL, LANDSCAPE.
But, every time I run the report it reverts the printer settings to
LETTER, PORTRAIT. I know this problem exists in A2K. I tried the A2K
"Autocorrect" solution in 97, but it did not work...as I expected it not
too...but it was worth a try.

I have a medium amount of working knowledge in using VBA Code (enough to
get me by). Can anyone explain how to do this? I have looked on Google
and found a source, but it is incredibly complicated and it does not say
where to enter the code and where to call the code from.

I would truly appreciate any help.

Does your printer support legal paper?

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #3

Similar topics

Printing Labels Fast on Elton printer

by: qumpus | last post by:

My program right now generates USPS style shipping label using System.Drawing.Graphics. It works fine except that the printer prints really slowly. I want to make my program take advantage of true...

.NET Framework

Crystal Viewer and Printer Settings

by: Karthic | last post by:

When i right click on the .rpt file in the VS 2003, i see a property printer setting. It says "No printer" on the top and there is option to select printer and paper settings etc.. I want to...

C# / C Sharp

Control printer settings

by: Anthony Nystrom | last post by:

I need to within code control some printer settings before raising the print dialog... I need to set some properties for the printer such as "The Printer to Print too", Page settings such as paper...

Visual Basic .NET

Changing Printer Settings

by: Anthony Nystrom | last post by:

I am having trouble with changing printer settings before I raise either the pagesetup dialog or the print preview dialog... Changing the printer name is easy, but I am also trying to change the...

Visual Basic .NET

How to OPEN native PRINTER DIALOG -- Please HELP !!

by: pamelafluente | last post by:

I am doing my own PrintDialog, and have placed there a combo with the printer names, as in the PrintDialog provided by VB.NET. Here is the question: how do I open the native windows printer...

Visual Basic .NET

Changing printer settings programmatically...

by: ExitusLSU | last post by:

Is there a way to change the DEFAULT printer settings for an installed printer? I want it to change the printer settings for a specified printer at the whole OS/Windows level, not just for the...

.NET Framework

Printing using VB/IE - Getting Error "Unable to set shared printer settings"

by: sathyp | last post by:

Public Function SetPrinterDefaultsW(ByVal sPrinterName As String, _ ByVal nPaperSize As Long, ByVal nOrientation As Long) As Boolean Dim Prn As Printer Dim hPrinter As Long Dim pd As...

Visual Basic 4 / 5 / 6

Printer Selection Ini File problem

by: Mark | last post by:

Hello, I have a VB6 Project that uses an ini file to save selected printer settings for several forms. The program allows users to select the printer on their work station for printing forms. If...

Visual Basic .NET

Printer margin and orientation settings from ASP

by: Giovanni Benedetti | last post by:

Hi everybody, sorry for my English first of all. I've an ASP page (ASP 3.0) used on an intranet which fill up some particular Mail sheets getting data from a database. Those pre-compiled sheets...

ASP / Active Server Pages

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++