Designing Access Reports

S

Special K

I have read through a number of posts on this page which touch on the problem
I am experiencing, but cannot seem to find a definitive answer. On one PC in
my office a user with Access 2003 can not create, open or run a report.
There is NO error message; there IS a default printer installed. But using
either design view or report wizard simply does nothing. It’s as if the
design button was never clicked upon. All of the PC’s were built the same
way so I can not understand why this is happening. Any help greatly
appreciated.
 
A

Allen Browne

On the machine that has this problem, open the Immediate Window, and enter:
? Printers.Count
? Printer.DeviceName
How many printers does A2003 recognise?
Does it find the correct printer?

If the count is zero or the device name is wrong, there is a problem with
the way the printer is set up on this machine. As you probably read, this
tends to happen in A2003 with network printers that are incorrectly
installed. You may be able to temporarily work around the problem by
installing another printer in the Windows Control Panel, making this
(non-existent) printer the default. This will allow Access to read the
printer metrics from the driver, and at least create the report.

Of couse, this won't solve the problem, because you cannot print to this
non-existent printer. But if that works, you have demonstated that the issue
is indeed with the way the printer is installed. You may be able to fix that
by removing the printer, and installing the same printer driver as if it
were a local printer, and then pointing it to the location across the
network.

HTH
 
Top