Cannot open Reports in Design View

User avatar
Michael Abrams
4StarLounger
Posts: 579
Joined: 10 Feb 2010, 17:32

Cannot open Reports in Design View

Post by Michael Abrams »

Windows XP/Access 2003

I am attempting to open Access reports in Design View, but when I click on Design, or Right Click and select Design View, nothing happens.

I can open tables and queries in Design, just not the reports.

I am on a network, and everything else in Office (as far as I know) works fine. I have rebooted and still nothing.

Is there a patch or hotfix for this?

Thank you.

Michael

User avatar
Michael Abrams
4StarLounger
Posts: 579
Joined: 10 Feb 2010, 17:32

Re: Cannot open Reports in Design View

Post by Michael Abrams »

OK - found an answer through google.

I had changed my default printer to one nearer my desk. When I switched the default printer back to the original printer, all was fine.

Nice that it worked, but can anyone tell me why?

What if I need to change default printers? What do I need to do to allow me to open reports in Design View?

Puzzled in Sacramento,

Michael

User avatar
HansV
Administrator
Posts: 78790
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Cannot open Reports in Design View

Post by HansV »

If you open one of the problem reports in design view, select File | Page Setup... and activate the Page tab, has the report been set up to use the Default printer, or to use a specific printer?
Best wishes,
Hans

User avatar
Michael Abrams
4StarLounger
Posts: 579
Joined: 10 Feb 2010, 17:32

Re: Cannot open Reports in Design View

Post by Michael Abrams »

It is set for Default Printer.

User avatar
HansV
Administrator
Posts: 78790
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Cannot open Reports in Design View

Post by HansV »

Does the printer you temporarily switched to have a very different paper format or margins than the original one?
Best wishes,
Hans

User avatar
Michael Abrams
4StarLounger
Posts: 579
Joined: 10 Feb 2010, 17:32

Re: Cannot open Reports in Design View

Post by Michael Abrams »

No. Actually, the person next to me set the other printer as default, and it worked fine. So I can now narrow it down to it being my machine or settings.

User avatar
HansV
Administrator
Posts: 78790
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Cannot open Reports in Design View

Post by HansV »

I'd try uninstalling then reinstalling that printer.
Best wishes,
Hans

User avatar
Michael Abrams
4StarLounger
Posts: 579
Joined: 10 Feb 2010, 17:32

Re: Cannot open Reports in Design View

Post by Michael Abrams »

HansV wrote:I'd try uninstalling then reinstalling that printer.
I uninstalled the printer, rebooted, installed it, and now I get the hourglass for 1 second, but the report still does not open in Design View or Preview.
I am stumped.

Michael

User avatar
HansV
Administrator
Posts: 78790
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Cannot open Reports in Design View

Post by HansV »

I am too. Sorry!
Best wishes,
Hans