Docmd.OpenReport CRASHES Access '97

  • Thread starter Thread starter Jonathan Goldman
  • Start date Start date
J

Jonathan Goldman

Hi-
I have a relatively simple report that I open in an Access '97 VBA
procedure, using the

Docmd.OpenReport "rptName", acViewNormal

syntax. The problem is that doing this usually crashes Access! No
error message is given, the thing just vanishes! Why? How do I fix
this?

TIA...
 
If this happens for just one report, the database is partially corrupt.
Create a new (blank) database, import everything else, and rebuild the
report.

If it happens for the reports in other databases (such as Northwind) as
well, the problem could be something else such as a faulty printer driver.
Access uses the metrics of the printer driver to prepare the report, even if
you do not print.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 97 crashes opening a report 3
Printer prints multiple copies 1
DoCmd.OpenReport suddenly failing, macro print prints same report ok 2
OpenReport Question 1
PC often crashes, at the beginning or after pixels appear 3
Report Data Splitting 2
can't print in landscape 2
Printing Problem When Using OpenReport 5

Back
Top