how to avoid open report action cancelled message (97)

Topic

New Reply

how to avoid open report action cancelled message box
what is a graceful way of avoiding the

Reply | Quote

Replies

never mind, I commented this out next to the button running the report & peace & order was restored to the universe.

‘MsgBox err.Description

Reply | Quote

FYI, you can also use: DoCmd.SetWarnings = FALSE

Reply | Quote

You can also trap the error that occurs. This allows you to get a meaningfull error when something unexpected happens.

eg surround your code in a procedure with the following.

at start.
On Error goto Error_trap

{code in here)

Exit_Procedure:
Exit Sub
Error_Trap:
Select case err
Case 2501’Report open canceled.
‘do nothing, we accept this error.
Case Else
msgbox Error,vbInformation,Err & “{procedure Name}”
end select
resume Exit_Procedure ‘Quit after error.
This allows you to receive an error description in the msgbox and the error number for trapping if necessary and the procedure where the error occured as the title for the msgbox.

Never blindly disable error trapping, as the ability to trap errors and deal with thenm is the primary advantage of using vba over macros.

Reply | Quote