Share via

Access will not print

Anonymous
2020-06-30T19:19:10+00:00

When I open Access and try to print, I get a popup stating that I do not have a Default Printer. I do have a default printer installed. I can print from Word, Excel and Outlook, just not Access.

Any clue to where I can start troubleshooting this issue? It started in March, prior to that I printed just fine.

Thank-You!

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. George Hepworth 22,765 Reputation points Volunteer Moderator
    2020-06-30T19:49:38+00:00

    Something changed in your environment in March. New version of Access, new printer or printer driver, new location of the default printer. Something. 

    Start by seeing if you can reassign the Default printer for one of your reports to the specific printer you desire to use.

    Also make sure it's assigned as your default in the Windows OS.

    It has been reported that checking this option can give rise to the problem you now see. Validate that as well.

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2020-07-01T13:19:33+00:00

    Access includes a Printer property of the Application object by which you can set a printer to be used when printing from Access.  You could therefore try including code to do this when your database opens, e.g. by calling a function in an AutoExec macro.  You'd just need a single line of code in the function:

        Set Application.Printer = Application.Printers.Item("Name of printer goes here")

    To revert to the Windows default printer you'd execute the following line of code when the database is closed:

        Set Application.Printer = Nothing

    If you want to be able to choose a printer from within Access you'll find an example of such code in LabelPrinter.zip in my public databases folder at:

    https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169

    This little demo file includes a fmPrinterDlg form in which a printer can be selected when printing labels via the other forms in the demo.  This form could be imported into any Access database to provide the same functionality.

    0 comments
  3. Anonymous
    2020-06-30T21:07:20+00:00

    Does your computer have a functional printer?

    "The Page Setup Window never opens"

    When you open the report in design view, you can't get the page setup dialog to open?

    Perhaps try an Office Repair.

    I also know a recent Windows update has caused major (with a capital M) perhaps this is all related to that.

    0 comments
  4. Anonymous
    2020-06-30T20:10:59+00:00

    Thank you GroverParkGeorge,

     The Page Setup Window never opens, :-(

    Just the popup that says there's no default printer installed. I opened Printers & Scanners and Unchecked the, Let Windows Manage My Default Printer, window, then chose the printer I wanted for my default. Others in my office can print from Access.

    0 comments