Disable all form events?

[Paul B]

Hi all,

One of my applications is used by several users, mainly through terminal
sessions. One of the drawbacks with this is (sometimes) the slow
response time. This causes the user to click on buttons again after
initial clicking. E.g. from a swichboard form, if the users clicks a
button to open another form, and this form is not opened as quickly as
expected, the user tries again.

This results in opening the form twice, with all corresponding problems
and errors. The same is when closing the form. Using the "close" event,
data is collected, manipulated and stored. If this button is used twice,
again we may get problems and errors.

So my question is: is there an easy way to prevent this? Of course I can
disable a control/button after initial use, but I do not know if this is
the best solution. In the switchboard form, there are about 10 options.
And disabling all these options separately (and afterward enabling
again) is not my preferred solution.

Can I disable all form events with one command, or postpone/ignore any
input during processing?

Thinks in advance for any suggestions.

Paul

 

[Arvin Meyer [MVP]]

Your problem is not the code as much as it is the way you are using Access
on the Terminal Server. You need to create a folder for each user so that
when he/she logs into the Terminal Server they are directed to their own
folder each one of which has a copy of the Access front-end. Any other
method will eventually cause corruption. possibly irreparably.

If you still have the same problem, start checking the server RAM and the
network for slow or bad NICs. As a last resort, you can change your code to
disable the button after it is clicked once. Then re-enable it after the
code runs.