displaying reports in Access 2003

[Wilbur21]

The user is in a windows 2000 environment using office 2003 with a printer added to the user profile. In Office 2000 when the report did not display I simply added a printer which would solve the problem. In this case the report still will not display.

Any ideas?

 

[dhookom]

You aren't telling us if you set the printer as the default printer. Also, are the printer drivers updated? Did you try setting other printers as the default?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Hap007]

Dear Wilbur21,

I have similar problems with reports when moving from an earlier version of Access to a later version.

Here is what I experienced.

1) Older version of Access, one of many reports would not display.
2) The underlying query for the report did work.
3) Turns out that the report/query combination was failing but not giving any message in the newer version of Access.

So,
I made a copy of the report and started removing each field in the report until I found the offending field.
I actually had to remove the field from the report and also modify the query.

I finally decided that the newer 'Jet engine' must not have evaluated the query the same, yet the query would run, but just not work with the 'Report'

So, you might try this to see if this is also your problem.

Hope this helps,
Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Add-on Solutions
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[Wilbur21]

Hi Guys,

The printer is a network printer and yes access is trying to read the default printer. I looked at some forums where people are getting the exact same prob with access 2003. After some trouble shooting I found out that by actually setting print permissions on the printer for the user, the user was able display the report. NOt sure why this should work this way since by default the user is a member of the everyone group and the everyone group already has print permissions by default. Access 2000 accepts the default printer without setting an individual print permission for the user.