[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


What is the default printer for Access 97?

Posted on 2009-04-30
Medium Priority
Last Modified: 2013-11-28
I found out that Access 97 can eventually not use Windows default printer when you click on "Immediately Print" icon.
For other Office applicattions like Word or Excel there are basically 2 ways to print:
1. Immediate: using the icon on top menu bar file is printed immediately on Windows default printer.
2. Not Immediate: using the menu bar item "File", then Print, a dialog box "Printing" is open and you can select a printer different from the Windows default. So you can print a document with a different print than Windows default but keeping the Windows default.

Well this is not valid for Access 97 !!!!
If you print in a"Not Immediate" way, I mean using  the "Printing" dialog box and selecting a different printer than Windows default and then you try to print in "Immediate" way, the print job will not be directed to Windows default printer but to the last printer used.

It looks like Access '97 had its "own default printer."

Well, question is, how can I retrieve which is the "Access own default printer" at any time?. Most of the routines I got were to retrieve Windows default printer.
I suppose that "Windows own default printer" must be saved as property of some Access object. Which is it?

Kind Regards


Question by:armando_horcajo
LVL 74

Accepted Solution

Jeffrey Coachman earned 2000 total points
ID: 24275792

The Printer Object was not fully exposed in Access versions earlier than 2002(xp)

There is some famous code in the Access 2000 Developers handbook (Desktop Edition) that most developers used as a reference.

But it is not light reading by any definition.

The book still seems to be available:

Let's see if other Experts migh have more info...



Expert Comment

ID: 24276590
Pl.check/ensure the following :

Your application don't have using any function/class to set default printer !
You are not changing the windows default printer in any other application !
Your Msoffice is working problem, may be some problem in OLE.
Try to reload MS-Office, if your application is creating problem from last few days.

Best wishes,

Bm Keshav
LVL 93

Expert Comment

by:Patrick Matthews
ID: 34118896
This question has been classified as abandoned and is being closed as part of the Cleanup Program.  See my comment at the end of the question for more details.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question