How to avoid user to enter the Visual Basic Windows?

[Guest]

Hi all.

Did anyone know is it possible to avoid user to enter the Visual Basic
Windows in a MS Access application? The situation is when i run an MS Access
Application, an error is occured in run-time, then it will automatisch going
to the Visual Basis Windows. My question is are there any way to avoid it?

Best regards,

Pat

 

[John Spencer]

The only way I know is
--Install an error handler in all your visual basic code
--Set Error Trapping (VBA Tools: Options) to Break on Unhandled errors

Or compile the code and make the database an mde. Distribute the mde to the
users, keep the mdb for changes to the database. Of course I am assuming
that you have split the database into a frontend and backend.

 

[Guest]

In the VB editor, Select Tools, Options, General tab and select Break on
UnHandled Errors. Then add error handlers to all your subs and functions.