Create arrow (or highlight) for queries executing in Access Macr.

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

Guest

I would LOVE to have the ability to know what query is executing in an Access
macro even though I've Set Warnings (off). If the Macro would simply
highlight the executing query...or put an arrow to the left hand side of the
executing query that would be great too...anything.

Is this a function I can activate somehow?
 
David,

To the best of my knowledge, it cannot be done the way you're visualizing
it. I have a similar case (in VB code, not a macro) and the trick I use is
display the current process name on a form. A good idea you just gave me
would be to have all the query names on the form in a column, and make
visible an arrow or tick or something next to each, or bold it, or
whatever, as they execute, so the user knows not just the current process,
but also which position it is in the list. Not sure it can be done with a
macro, though, chances are you will need to resort to VB code, in which case
converting your macro to code is a good start. Then you would need an line
at the beginning to open the progress form, like:

frmName = "frmProgress"
DoCmd.OpenForm frmName

Bolding / Unbolding labels on the form can be handled by:

Forms(frmName).Controls("Label1").FontBold = True / False
Forms(frmName).Repaint

HTH,
Nikos
 
David

You could make a form, with a series of labels, each with the name (or
description) of one of your queries, one under the other, and another
label with an arrow symbol on it, placed to the left of each query
label, and make all the arrows invisible. Then, use an OpenForm action
at the beginning of the macro to open this form. Before each query
runs, make the arrow next to that query's label on the form visible,
using a SetValue action, and set it back to Visible = No after the
OpenQuery action. Will that serve your purpose?
 
Back
Top