Disappearing Modal PopUp Form

Aoife

Registered User.
Local time
Today, 20:57
Joined
Dec 4, 2013
Messages
36
Hi
I’ve got a background form with modal and popup properties both set to yes that opens when the application is opened – it serves to hide the MS Access application on startup.

I call further forms all with modal and popup properties both set to true, all works great until any of the forms have VBA that takes more than just a few seconds to process. If a user touches the form whilst such code is running and MS Access is “Not Responding”, the form disappears behind the initial background form.

There is no way for the user to know that the ‘Windows-Tab’ keyboard combination will return the form with the code to re-appear – this is further exacerbated by the fact that it’s a touch screen application with no access to a keyboard. The application locks itself out as there is no way of accessing the form that was processing the code.

Is there a way of ensuring that the most recent modal/popup form always stays on top?
 
Thanks for the reply. I did see the potential Daisy Chain solution but my understanding is that this would serve to hide my background form (make it invisible) and therefore you would see more of the MS Access interface?
 
Hi,

Are all your forms maximized to fill the screen and the intent is to only allow the user to see the last one opened? If so, you might consider using Dialog forms instead.
 
Thanks for all the feedback. Tried opening as a Dialog form and the VBA was unresponsive after the initial code was run. The form froze thereafter and I had to bomb it out.

I'll attempt to post a slimmed down version of the database later in the week.

BTW impressive database Colin.
 
Thanks ... But more importantly could you use a similar approach to that example?
 
I tend to build systems where there my popups are set to modal yes and I only have one of these open at any one time. I just find it easier to manage.
 

Users who are viewing this thread

Back
Top Bottom