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.


"Pat" <(E-Mail Removed)> wrote in message
news:608C7D66-FD4E-4AA1-A030-(E-Mail Removed)...
> 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

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.

"Pat" wrote:

> 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