Close Form Doesn't

[Phil Smith]

I have a database which runs a ten second query to update certain tables
upon opening. I wanted to warn people, so I created a form with a label
that says "please wait."

I have my opening macro open that form, run the query, close the form,
then open the switchboard for the database.

Instead the macro seems to pause at the close form command, until I
manually close the form, at which point it continues normally.

Ideas?

 

[Steve Schapel]

Phil,

Please post back with the details of the macro - all Actions, and key
Argument settings.

 

[Phil Smith]

OK, I figured out the problem, but it just changes the problem to one of
not displaying the guts of the form, just the outline.

Macro is pretty simple.
Open form, Normal.
RunCode. This is code to correct dsnless connections.
Close Form, No save.
Open Form. This opens the switchboard.

I was using Open Form, Dialog, at first. This is what prevented the
rest from running until it was closed. However, it fixed my other
problem, which is the form actually displaying. As is, I get an
outline, and I get the Title at the top of the window, along with the
Min/Max/Close buttons, but the inside is transparent. It does go away,
but it does not serve the purpose of displaying an informational message.

Any Ideas? The form itself is nothing but a single label.

 

[Steve Schapel]

Phil,

It sounds like whatever is happening in the RunCode is fairly
processor-intensive, so Access is deciding to give resource allocation
priority to it instead of screen updates. Try forcing the issue by
putting a RepaintObject action into your macro immediately after the
first OpenForm.

 

[Phil Smith]

So simple, So effective. Thank you very much.