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?
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?