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.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.