Can not preview reports - access 2007

[CJ]

Hi Groupies

I have a database that is in use by a number of project managers for a
company. They all use it independently and are not connected to a network at
all because they all work remotely in the field.

One of the computers will not preview reports. I thought it might be a 2003
SP3 issue but he has now upgraded to 2007 and is experiencing the same type
of problems.

For example: When he selects a Preview Report button from a form, he
receives the message "the open report action was cancelled." The button
just has basic code to open and preview a report. His data is good. There
are no integrity issues or missing pieces of data.

Nobody else is experiencing any of these problems whether they are using
2003, 2007, Windows XP or Vista. I have tested it with every variation with
no trouble and when he sends the database to me, everything works well. His
VB Code is also complete and the References are good.

Does anybody have any ideas at all??? This is incredibly frustrating.

 

[Marshall Barton]

CJ wrote

I have a database that is in use by a number of project managers for a
company. They all use it independently and are not connected to a network at
all because they all work remotely in the field.

One of the computers will not preview reports. I thought it might be a 2003
SP3 issue but he has now upgraded to 2007 and is experiencing the same type
of problems.

For example: When he selects a Preview Report button from a form, he
receives the message "the open report action was cancelled." The button
just has basic code to open and preview a report. His data is good. There
are no integrity issues or missing pieces of data.

Nobody else is experiencing any of these problems whether they are using
2003, 2007, Windows XP or Vista. I have tested it with every variation with
no trouble and when he sends the database to me, everything works well. His
VB Code is also complete and the References are good.

Just a shot in the dark here, but make sure he has a printer
(driver) installed and it is the default pronter.

 

[CJ]

Hi Marshall

Yep, I went through the printer setup with him. He has no problem printing
anything else. He had a number of issues before that were part of the 2003
SP3 fix, 2007 has cleared up all of those except for this issue.

As it turns out, it is not all of the reports that will not print, probably
60% do not work for him. I'm not sure what's worse, all not printing or just
some of them.

 

[Marshall Barton]

Yep, I went through the printer setup with him. He has no problem printing
anything else. He had a number of issues before that were part of the 2003
SP3 fix, 2007 has cleared up all of those except for this issue.

As it turns out, it is not all of the reports that will not print, probably
60% do not work for him. I'm not sure what's worse, all not printing or just
some of them.

My only thougjt is some kind of printer issue. Check (File
- Page Setup)those reports to make sure they are set up to
use the default printer like the ones that do work.

If that does not help, I would have to cop out and blame it
on corruption and suggest that you give him a fresh copy of
the database.

 

[CJ]

No worries.

Personally, I think it is an issue that his PC has since his file works fine
on every other computer we try it on. I was hoping there was some other
known "issue". ;-)

I will double check the default printer thing though.