Access crash

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Each time I press the button to send the print the report access crash. The
code is under a button on click event:

Dim stDocName As String
stDocName = "Professional profile sheet"
DoCmd.OpenReport stDocName, acNormal, , , acWindowNormal

The report print, but access close and restart.
 
Try the following:

-Compact and Repair the database.
-Make sure the report is not calling a macro or has code in the On close Event
-If the problem persists is possible that the db is corrupted, try importing
all the objects(tables,queries,forms,reports,macros,modules) into a new
database
 
Back
Top