Display query name in macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone have a quick way to dispay the name of the query that is
currently running when runnig a macro?
 
Joe,

Do you mean a macro that runs a query, for example using an OpenQuery
action? If so, you could have a form with a label on it, or an unbound
textbox, and use a SetValue action in the macro, immediately before the
OpenmQuery action, to set the Caption property (in the case of a label)
or Control Source property (in the case of a textbox), to display the
name of the query.
 
hi
just prior to runnng the query, you can display a message
box stating which query is about to run but this would
require that you close the box before the query runs.
oyou could also create a small form with 2 labels(1
saying "current query running is" and 1 for the
queryname), call the form just prior to runing the query
and set the label caption to the name of the query then
close the form after the query runs.
 
Back
Top