hidden message boxes
Dear experts -
I have one or two forms where in some cases (I just experienced this while logging in remotely via remote desktop) I am in a form and invoke another form, with some intervening message boxes.
The message boxes don't appear on top, but they are there and stop the program, as expected. I need to click somewhere else on the screen and then they appear.
Has anyone seen this and is there an easy fix?
Both the calling form and the called form are set to modal+popup.
Thank you
I have one or two forms where in some cases (I just experienced this while logging in remotely via remote desktop) I am in a form and invoke another form, with some intervening message boxes.
The message boxes don't appear on top, but they are there and stop the program, as expected. I need to click somewhere else on the screen and then they appear.
Has anyone seen this and is there an easy fix?
Both the calling form and the called form are set to modal+popup.
Thank you
Who is Participating?
LVL 42
I have had this happen to me so you're not nuts but I don't have a solution. It is possible that the problem occurs because you already have a modal form open and so the message box can't display itself on top of that.
Anytime I see behavior like this I think of corruption, so first thing would be to insure that your database maintenance is up to date.
First make a backup, then Compact the database. Next, Compile the database - from the VBA Editor click Debug - Compile, and fix any errors you might find. Continue doing this until the Compile option is disabled. Now compact again.
You might also consider a Decompile after doing this. To do that, build a Shortcut with this as the Target: "Full path to msaccess.exe" "full path to your db" /decompile. Run this shortcut, then do the Compact-Compile-Compact sequence again.
Finally, you might also consider moving everything to a new, blank database container. You can use the Import function in Access to do this.
Also be sure that all machines, including the one running the VMs, is fully up to date in regard to Windows and Office (and any specialized VM software that is being used).
First make a backup, then Compact the database. Next, Compile the database - from the VBA Editor click Debug - Compile, and fix any errors you might find. Continue doing this until the Compile option is disabled. Now compact again.
You might also consider a Decompile after doing this. To do that, build a Shortcut with this as the Target: "Full path to msaccess.exe" "full path to your db" /decompile. Run this shortcut, then do the Compact-Compile-Compact sequence again.
Finally, you might also consider moving everything to a new, blank database container. You can use the Import function in Access to do this.
Also be sure that all machines, including the one running the VMs, is fully up to date in regard to Windows and Office (and any specialized VM software that is being used).
actually, this was the solution - the clue in this case was that the message box was directly covered by the invoked form - if i switch off both modal and popup, I don't have the issue. I'll have to fiddle with those setting a bit more, or ensure that the form doesn't appear until the message box goes away.
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
