Preview Problem in Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I wrote a simple app in Access 2002 with 3 different reports. I used a Switch
Board as my menu and each report is called via the Open Report from the
menu. I distributed the app to team members in my company who mostly have
Access 2002. The reports work perfectly on computers running Access 2002, but
the reports will not run for anyone who has Access 2003. Those who have
Access 2003 can execute the queries called by the Report to see the data, but
cannot run the reports either through the Switchboard or directly through the
Reports panel.

Any idea what is causing this behavior in Access 2003?
 
Others have asked this question in these newsgroups, and the problem has
been traced back to installation of the network printer.

You must have a printer installed on the machine to be able to preview the
reports, since Access uses the printer metrics to calculate the layout of
the report. If there is a problem with the printer, the report will not
preview or print correctly.

On a machine that exhibits the problem, open the Immediate window (Ctrl+G),
and enter things like:
? Printers.Count
? Printer.DeviceName
This should show you how many printers are installed, and which one is the
default. If Access can't find the printers, or provides bad info on the
default printer, there is a problem with the installation of the network
printer. (This applies even though other applications can print to it okay.)
 
Back
Top