Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Macros / May 2005

Tip: Looking for answers? Try searching our database.

Macro Status

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mark - 26 May 2005 15:16 GMT
Currently I run a month end macro which calls about 20-30 queries in order –
due to server issues this process can take up to 2 hours is there anyway I
can get Access to show a status box during this time? (a box which shows
which query is being run)

Cheers

Mark
Ken Snell [MVP] - 26 May 2005 15:35 GMT
You could create a form with a label on it. As the first step in the macro,
open the form in normal mode. Then, just before you run a query, use the
SetValue action to set the caption text in the form's label -- something
like this:

   Action: SetValue
       Expression:  Now running query [name]....
       Control Name:  Forms!YourFormName!LabelName.Caption

Then close the form as the last step in the macro.

Signature

       Ken Snell
<MS ACCESS MVP>

> Currently I run a month end macro which calls about 20-30 queries in
> order -
[quoted text clipped - 5 lines]
>
> Mark
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.