A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Disable all form events?



 
 
Thread Tools Display Modes
  #1  
Old October 29th, 2008, 07:26 PM posted to microsoft.public.access
Paul B[_10_]
external usenet poster
 
Posts: 1
Default Disable all form events?

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
  #2  
Old October 29th, 2008, 10:54 PM posted to microsoft.public.access
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Disable all form events?

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Paul B" wrote in message
...
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



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:39 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.