Opening report problems using the DoCmd.OpenReport

  • Thread starter Thread starter Emmanuel
  • Start date Start date
E

Emmanuel

Here is an excerpt from a user here at our center:

Access Errors

The errors only seem to occur when trying to open reports
using the Visual Basic DoCmd.OpenReport method. All other
VBA code works fine. When I try to open a report, nothing
happens. If I then try to reopen the report, I will get
an error message like this:
<image with MS Access Application Error>

Clicking on OK causes Access to shut down. Sometimes I
will get two of these in a row before Access shuts down.
Several weeks ago these error messages had DDE Server
Error in the title bar, so that has apparently something
has changed.
If I try to open a report in design view, I get the
following error message:
<image with error occuring with loading the form or report>

I then got some error messages about printers not being
defined, but was unable to get a screen capture and have
not been able to reproduce that error.

Has anyone seen this this before? I have not been able to
find this exact error/cause in the knowledge base. Any
help would be greatly appreciated.
 
Emmanuel said:
Here is an excerpt from a user here at our center:

Access Errors

The errors only seem to occur when trying to open reports
using the Visual Basic DoCmd.OpenReport method. All other
VBA code works fine. When I try to open a report, nothing
happens. If I then try to reopen the report, I will get
an error message like this:
<image with MS Access Application Error>

Clicking on OK causes Access to shut down. Sometimes I
will get two of these in a row before Access shuts down.
Several weeks ago these error messages had DDE Server
Error in the title bar, so that has apparently something
has changed.
If I try to open a report in design view, I get the
following error message:
<image with error occuring with loading the form or report>

I then got some error messages about printers not being
defined, but was unable to get a screen capture and have
not been able to reproduce that error.

Has anyone seen this this before? I have not been able to
find this exact error/cause in the knowledge base. Any
help would be greatly appreciated.
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

It sounds like a corrupted Report object. Some things to try:

1. Open a module and Compile & Save all modules (Compile <project
name> in Access 2000 & higher).
2. Compact the file (.mdb, .adp) that holds the report.
3. Open the report in design view, change something & save the report
then compact the file.

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQE+A44echKqOuFEgEQK4nwCgjPHXUib8Oks9RPMmI/xvjKQjCiUAn28+
Byu795mShZrPYBKsjPMXQ56+
=TTJ2
-----END PGP SIGNATURE-----
 
Back
Top