Prevent changes made by VBA scripts from triggering "ON CHANGE" scripts

E

E. Jordan

I have a series of macros that have been converted to VBA
scripts in Access 97. A handful of the scripts are
activated by clicking command buttons, but some are
triggered with "ON CHANGE." Is there a way to prevent
other scripts from executing while a particular script
executes?

I'm sure a skilled programmer could easily structure
his/her scripts to avoid this conflict, but due to a very
limited VBA knowledge, I'm looking for a simple work-
around. Thanks in advance.

Eric
 
G

Guest

-----Original Message-----
I have a series of macros that have been converted to VBA
scripts in Access 97. A handful of the scripts are
activated by clicking command buttons, but some are
triggered with "ON CHANGE." Is there a way to prevent
other scripts from executing while a particular script
executes?

I'm sure a skilled programmer could easily structure
his/her scripts to avoid this conflict, but due to a very
limited VBA knowledge, I'm looking for a simple work-
around. Thanks in advance.

Eric
.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calling C script from vba calls wrong executable.. 1
Executing a VBA macro from within Excel 97 script 1
How Do I Use List Box for VBA Script that Converts Excel Files to Any FIle Type? 6
worksheet change not triggering 1
Events won't trigger if locked for edit and if opened from IE 4
VBA newbie needs help with triggering a macro 3
Problem running a VBA script from an Outlook rule 5
tscmd35.zip Useful NT/2000/XP script tricks and tips 0

Top