Get Access to Open a Window and Wait for Editing to be Complete?

[AccessPro]

Hi,

I am creating an image-management database. I want my users to be able
to double-click on an image (a preview of what exists in a network
subfolder), and for the code to open the image in its associated
application (say, Microsoft Photo Editor), then wait for the user to
close the window before continuing code execution. I know I can shell
out to whatever application I need, but Shell doesn't seem to have a
"wait" mode on it. I want this to work similar to when you open an
Access window as a dialog box (and the code waits until the dialog box
is closed before executing the next line). That way the database knows
who has last edited the image, and when the image was last edited. Can
anyone tell me how or if this is possible?

Thank you!

[David W. Fenton]

"AccessPro" <lo*******@bellsouth.net> wrote in
news:11*********************@e56g2000cwe.googlegro ups.com:

I am creating an image-management database. I want my users to be
able to double-click on an image (a preview of what exists in a
network subfolder), and for the code to open the image in its
associated application (say, Microsoft Photo Editor), then wait
for the user to close the window before continuing code execution.
I know I can shell out to whatever application I need, but Shell
doesn't seem to have a "wait" mode on it. I want this to work
similar to when you open an Access window as a dialog box (and the
code waits until the dialog box is closed before executing the
next line). That way the database knows who has last edited the
image, and when the image was last edited. Can anyone tell me how
or if this is possible?

One solution would be ShellWait():

http://www.mvps.org/access/api/api0004.htm

This uses Windows API calls to do the job.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[AccessPro]

Thanks! I knew I couldn't be the first person to need to solve this
problem.