Display Alerts in Access

[ovlia1286]

Hey,

Is there a method similar to ExcelApplication.displayalerts = False to suppress any messages created in Access. When I run a macro in Access VBA, it complains about a few records not being complete, and I do want to display this message.

Thanks for your help,

VO

[westconn1]

i think you will need to get the information you want to display and use a message box

pete

[ovlia1286]

No, I don't want it to display any messages/alerts...

Vince

[westconn1]

and I do want to display this message.

sorry i got it wrong

just put in error handling with resume next

pete

[ovlia1286]

Wow, I should of tried that... thanks for your help .

VO

[ovlia1286]

It didn't work... when i step through the code, the alert occurs before the code goes to the error handle. The alert is the following: "Microsoft is unable to apend all the data to the table. Do you want to proceed?"

[westconn1]

before that position, put in a line
on error goto errorhandle

at the end of the sub, on the line before End Sub add a few lines like

exit sub   ' so normally code will not go past
errorhandle:      ' label to go to
if err.number = xxxx  then resume next   , where xxxx is the number for the 
'error  you are getting and resume next mean go back to the line after the error
 
' here you would have conditions for other errors
End Sub

to go back to other errors not being processed by this error handler put
on error goto 0

pete

[ovlia1286]

I put an "on error goto errorhandle" line in my code before the error occurs. However, it still give me the same problem. The alert message is displayed BEFORE the program goes to the error handler. Is there no way to turn alerts off in Access?

VO

[salvelinus]

There's an choice in the Options menu on the toolbar of Access to turn on/off warnings. FWIW, I think that in some cases that overrides normal error handling.
The problem with turming off warnings is that will affect your whole app. It's probably possible to turn it off & back on through menubar commands, but I don't know the code for that offhand.
But do you really want to turn it off? It would be a lot better to handle the error in some way.

[RobDog888]

Since this is a Insert or AddNew record error from the data being incomplete or incorrect, I dont think you can turn off that
level of an error. Its best to fix the error.

[ovlia1286]

I agree that the error should be fixed. However, just for everyone's information, DoCmd.SetWarnings will enable or disable warnings in Access...

Thanks for everyone's help,
VO

[RobDog888]

It can also be accessed from the app object.

Application.DisplayAlerts = False 'Turn them off
'Do something that will invoke an error message
Application.DisplayAlerts = True 'Turn it back on.