Is there any way with VBA that I can trap when a user does a manual query refresh via the 'Data/Refresh All' key-in? I need to know when the query table has been refreshed. Thanks.
Printable View
Is there any way with VBA that I can trap when a user does a manual query refresh via the 'Data/Refresh All' key-in? I need to know when the query table has been refreshed. Thanks.
Not sure if this would be of any help...
http://support.microsoft.com/kb/213187
Thanks. Not quite sure how this works but I'll play with it some. I'm guessing you can actually create a new event type.