There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.
Solved
hidden message boxes
Posted on 2013-11-20
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
3 Comments
Active today
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.
Active today
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.
Featured Post
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.
Join & Write a Comment Already a member? Login.
A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
Usually, rounding is performed by some power of 10 - to thousands, hundreds, tens, or integer - or to one, two, or more decimals. But rounding can also be done to a power of two, say, 16 or 64, or 1/32 or 1/1024, even for extreme values.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query:
…
Enter Foreign and Special Characters
Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~
Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses
Course of the Month3 days, 23 hours left to enroll
589 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.