Hi Guys,
The server, on which my back end is stored, is terribly slow. I'd like to avoid situation where the user hits for instance "Add Project" button (the button is supposed to display a form that allows new project's entry), front end starts loading the form and required data from back end - and before the form appears on the screen, the user hits the button once more. I noticed that sometimes it takes few seconds to load the form and during that time user can (and knowing my users probably will) hit the button (or some other part of interface) once more. It can make my app crash or work unstable and that's why it is definitely good idea to avoid it.
I already created appropriate modal form saying "Please wait" that wouldn't allow the user to mess up. Unfortunately, there are many forms (and other bottleneck spots) for which I'd like to use this function. I don't like the idea of revising my whole code and placing
Code:
DoCmd.OpenForm.. and DoCmd.Close acForm
every here and there - isn't there a better way to do so? Could you Guys share your experience in this matter?
Robert