Show query name that is running

[jcw5107]

I have a form with a command button - that I use to update tables/records, append data to tables, or make new tables.
My question is...
Is there a way to tell which query is currently running? In the status bar, or a message box...???
The queries are being ran like:
DoCmd.RunSQL ("Delete * From AlternatesMain;")
DoCmd.OpenQuery "11qryAlternatesMain", acNormal, acEdit

DoCmd.RunSQL ("Delete * From AOGMain;")
DoCmd.OpenQuery "12qryAOGMain", acNormal, acEdit

DoCmd.RunSQL ("Delete * From PartTypeMstr;")
DoCmd.OpenQuery "13qryPartTypeMain", acNormal, acEdit

Any suggestions or examples..?
Thanks in advance..!!
jcw5107

 

[TheAceMan1]

How are a jcw5107 . . .

Have a look at the [blue]SysCmd[/blue] method . . .

See Ya! . . . . . .

Be sure to see FAQ219-2884: