Is there a simple way to create a dialogue box that will display messages as a module runs? To be more specific: I have modules that perform data import and formatting functions which can be quite lengthy. I'd like to create a dialogue box that will display which action is currently running as well as a progress meter (such as "now updating table 1" with meter to show progress of that query).

Not that I know of but, i'd be glad to show you what i've done. For a routine that imports 50 or so DB's into one, it displays 1) databases completed 2) current database 3) current table

email me if you'd like me to send the modules.

Download the forms sample database from MS.

Go to the location below, this what I use all the time.

http://support.microsoft.com/support/kb/articles/Q96/9/89.ASP?LN=EN-US&SD=gn&FR=0

HTH
RDH

[This message has been edited by R. Hicks (edited 11-09-2000).]

The common dialog control cmdlg32.ocx will give you exactly what you are looking for. I am not sure if this comes only with the developer's version or whether other MS products provide it. If you have the ocx file above, it should be in windows system folder, reference it within your db and register the file under activex controls also within your db. It will then appear in your toolbox.