Press Any Key to Continue

[Brad]

Thanks for taking the time to read my question.

I have some code that opens a temp table for the user to preview the data
before running the rest of the code.

Right now it doesn't work because the message box opens overtop the temp
table. You click ok, and the rest of the code runs and you never get to check
the data before proceeding.

Is there a way I can do this? A message pops up telling the user they need
to double check the data before proceeding. When they are ready, they can
press any key to continue, or they could click ok, or what ever. I just want
the code to pause while they check the data.

The user will have to be able to scroll through the data to see everything,
and a TimeOut does not seem to be what I'm looking for.

Thanks,

Brad

 

[Dirk Goldgar]

Thanks for taking the time to read my question.

I have some code that opens a temp table for the user to preview the data
before running the rest of the code.

Right now it doesn't work because the message box opens overtop the temp
table. You click ok, and the rest of the code runs and you never get to
check
the data before proceeding.

Is there a way I can do this? A message pops up telling the user they need
to double check the data before proceeding. When they are ready, they can
press any key to continue, or they could click ok, or what ever. I just
want
the code to pause while they check the data.

The user will have to be able to scroll through the data to see
everything,
and a TimeOut does not seem to be what I'm looking for.

The easiest way I can think of to do this is to display the temp table in a
continuous form, and open that form in dialog mode; e.g.,

DoCmd.OpenForm "frmReviewTempData", _
WindowMode:=acDialog

In the Form Header section, have instructions to review the data and close
the form (or click an OK button that closes the form) when they're done.

What should the user do if they don't want to proceed? If necessary you
could have a Cancel button on the form, which just hides the form instead of
closing it. Then the when the calling code resumes, which it will do when
the form is closed *or* hidden, that code can check whether the form was
closed (in which case, it should proceed normally) or is still open (in
which case the code should close the form and abort the process).

 

[Brad]

Excellent idea Dirk!!

Thanks so much.

Brad

The easiest way I can think of to do this is to display the temp table in a
continuous form, and open that form in dialog mode; e.g.,

DoCmd.OpenForm "frmReviewTempData", _
WindowMode:=acDialog

In the Form Header section, have instructions to review the data and close
the form (or click an OK button that closes the form) when they're done.

What should the user do if they don't want to proceed? If necessary you
could have a Cancel button on the form, which just hides the form instead of
closing it. Then the when the calling code resumes, which it will do when
the form is closed *or* hidden, that code can check whether the form was
closed (in which case, it should proceed normally) or is still open (in
which case the code should close the form and abort the process).

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)