How to avoid user to enter the Visual Basic Windows?

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

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
 
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.
 
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.
 
Back
Top