Solved

hidden message boxes

Posted on 2013-11-20
3
252 Views
Last Modified: 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
0
Comment
Question by:terpsichore
3 Comments
 
LVL 34

Accepted Solution

by:
PatHartman earned 500 total points
ID: 39664243
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.
0
 
LVL 84
ID: 39664245
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).
0
 

Author Closing Comment

by:terpsichore
ID: 39664279
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.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now