Simple Macro?

[StuInBerks]

Hi All

This is probably very simple, but have not yet worked it out.

I have a query which takes is data from a linked table, it can take up to 2 minutes to get all of the data due to the size of the linked tables. I want to use the basic macro command to display a message box stating to the user that "the query is running, please wait"

Im sure I can use a basic Macro but cant seem to work it out. Can anyone help?

Thanks

 

[Rob.Mills]

I wouldn't know how to do it thru a macro. Are you familiar with VBA? In VBA you can do things like show a progress meter in the status bar.

 

[StuInBerks]

Cheers Rob

I'm not really familiar with VBA and didnt want to go down that route if possible. I know there is a MsgBox action in the Macro builer. Does anyone have any ideas?

Thanks