MS Access - can't print

[ILTMan]

Running MS Access 2003 on a Windows XP Pro network.
When I try to print or print preview in MS Access 2003 nothing happens. When
I hover over the printer icon it displays (no printer). I have 4 printers set
up and a default printer set. I can pront from every other application.

 

[Allen Browne]

This is strange.

I wonder if it's:
- a faulty printer driver,
- problems with permissions in Windows (are you running as a computer
administrator)?
- permissions on the network (are the printers across the network)?
- or possibly bad references (from a code window, go to References on the
Tools menu, and see if anything is marked missing).

You could also ask Access to list the printers for you.
Open the Immediate Window (ctrl+G), and enter things like:
? Application.Printers.Count
? Application.Printer.DeviceName
? Application.Printers(0).DeviceName

 

[ILTMan]

Thank you for your suggestions. When I first tried
? Application.Printers.Count
nothing was returned.
but ? Application.Printer.DeviceName returned
? Application.Printer.DeviceName
\\BROMCOM10978\Samsung ML-1450 Series
This printer is attached to a server that's not part of the domain, so I
changed my default printer to a true network printer and repeated the process.
? Application.Printers.Count
5
? Application.Printer.DeviceName
\\PRINTER\RM113P1
? Application.Printers(0).DeviceName
\\BROMCOM10978\Samsung ML-1450 Series
? Application.Printers(1).DeviceName
\\PRINTER\LRCColour
? Application.Printers(2).DeviceName
\\PRINTER\RM113Colour
? Application.Printers(3).DeviceName
\\PRINTER\RM113P1
? Application.Printers(4).DeviceName
\\PRINTER\RM113P2

Went back into Access and I no longer get the (no printer) message.

So the problem appears to be resolved for me but we do have other users of
the system who use true network printers who've also experienced the problem
(not everyone has the problem) so will check out their printers etc and get
back to you if the problem persists.

Thanks

 

[SA]

ILTMan:

In addition to Allan's suggestions, I'd add that Access 2003 can be touchy
about printer drivers. Try changing your default to one of the other
printers on your machine, see if that works. If so, then try updating the
printer driver for your desired default printer. That would normally solve
the problem for that printer.

 

[ILTMan]

Thank you SA and Allan, your help is much appreciated.

 

[TxAggieJen]

I had a similar problem with Access 2003 and printing queries on a local
printer. I had to give the user local admin rights to the PC, have the user
login, then delete the local printer and reinstall the local printer using
the Windows XP Add Printer wizard. It worked after that.

Not sure what to do in the case of a network printer, but figured someone
might need this info if they are having this problem with a local printer.

 

[cobrachen]

I have the same experience. I had one computer with a new harddrive just
re-imaged and the Access 2003 could not print to the two HP default laser
network printers. I had at least 4 clients with either Dell desktops or Dell
Laptops could not print to one of the HP laser network printers.

Plus what I heard from the customer care personal in the same organization
told me there were more had the same issues. All of these could be resolved
by selecting another network printer as default one.

However, we all agreed this looks like a bug since so many machines had the
same issue and I don't recalll this happened before we moved from Office 2000
to 2003.

For your information.

 

[ormazd]

Running MS Access 2003 on a Windows XP Pro network.
When I try to print or print preview in MS Access 2003 nothing happens. When
I hover over the printer icon it displays (no printer). I have 4 printers set
up and a default printer set. I can pront from every other application.

I am encountering this exact issue in my organization, and see it's a
long-standing Microsoft issue. Has anyone ever found the solution?

This only occurs while printing Access 2003 reports on XP machines. The
clients are using network printers, and have no prolems printing from other
applications. This seems to pop up randomly for us, and keeps resurfacing.
We have tried a couple workarounds that fix it temporarily, but would like to
get to the root and resolve it once and for all.

Thanks in advance for any assistance.