VBA Script Editor Opening

[Ben]

Hi!

Just recently, I received complaints from users that every now and then the
VBA script editor pops out for no reason. I made sure that the breakpoints
have all been cleared before compacting the MDB application.

I have tried to performing the linking of tables and compacting before I
install them in the user's workstation. But they are still seeing the VBA
script editor every now and then. Mostly, after the first occurence, it
does not appear or open anymore.

I do not have any clues on the cause of this issue.

Any help is appreciated. Thanks.

 

[KLZA]

First track your errors. Remove the on error goto function and trap
the error, next identify the error. after identifying your error,
fix it. if you cannot fix it and can live with the error, make the
error function goto end sub..
ie...

 

[Roger]

First track your errors.  Remove the on error goto function and trap
the error,  next identify the error.  after identifying your error,
fix it.  if you cannot fix it and can live with the error, make the
error function goto end sub..
ie...






- Show quoted text -

make a backup copy of the mdb
then use the /decompile switch (google this group for more info) on
your mdb

I seen cases where it will stop during execution and open the VBA
window at a line where I previously had a breakpoint... the above
fixes this

 

[Ben]

I have decided to try the undocumented /decompile switch. I have backed up
MDB app and have deployed to all workstations. I should know in a week how
it goes.

For forum sake, I will let this forum know how it goes.

First track your errors. Remove the on error goto function and trap
the error, next identify the error. after identifying your error,
fix it. if you cannot fix it and can live with the error, make the
error function goto end sub..
ie...






- Show quoted text -

make a backup copy of the mdb
then use the /decompile switch (google this group for more info) on
your mdb

I seen cases where it will stop during execution and open the VBA
window at a line where I previously had a breakpoint... the above
fixes this

 

[Ben]

It seems that the /decompile switch worked in solving the erratic popping
out of the VBA editor during the app's execution.

Thanks to all.