Solved

VBA Access 2000 - Status of macro run

Posted on 2011-03-23
4
470 Views
Last Modified: 2012-05-11
Dear Experts,

Could you please have a short look on the attached picture, I am not sure what is the name exactly of that status bar, but when a query runs in Access that used to be in the bottom left corner until it finish the run.

Is it possible to activate similiar at a code run?

Basically I have buttons which starts macros with the pressing, but I have no information in the meantime whether it finished already or not. This is why would target such status check

thanks,
Running-query.jpg
0
Comment
Question by:csehz
  • 2
  • 2
4 Comments
 
LVL 57
ID: 35197622
You can display the progress meter with some code by using the SYSCMD() function.  The function call looks like this:

ReturnValue = SysCmd(action[, text][, value])

and here are the constants you can use:

acSysCmdInitMeter      Initializes the progress meter. You must specify the text and value arguments when you use this action.
acSysCmdUpdateMeter      Updates the progress meter with the specified value. You must specify the text argument when you use this action.
acSysCmdRemoveMeter      Removes the progress meter.
acSysCmdSetStatus      Sets the status bar text to the text argument.
acSysCmdClearStatus      Resets the status bar text.

  Do you need more?

JimD.
0
 
LVL 1

Author Comment

by:csehz
ID: 35197839
Jim thanks, sorry I am not too familiar with this yet and hard to imagine in working, could you have a short look on the attached code, how it could be tested in a short example?

I have just imagined a short loop and until its run, the "Progress message" shouild be in the left bottom corner.
Public Sub Test()

    SysCmd acSysCmdInitMeter, "Progress message", 100
    SysCmd acSysCmdUpdateMeter, 100


For i = 1 To 100
i = i + 1
Next i

    SysCmd acSysCmdClearStatus

End Sub

Open in new window

0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 35198038
Here's a better test:

Public Sub Test()

    Dim intI As Integer

    SysCmd acSysCmdInitMeter, "Progress message", 10000

    For intI = 1 To 10000
        SysCmd acSysCmdUpdateMeter, intI
        DoEvents
    Next intI

    SysCmd acSysCmdClearStatus

End Sub


  So you can see what it's doing.  This type of progress meter works well when you know up front how much you have to process.

  However for something  like running macros, the best you can do is to say "Running macro x of y", or in other words, your on step x of y of a process.

  So developers will often use a continuious bar just to indicate something is occuring or a timed one.  

  To help you see the differences, I'm attaching a sample DB with various progress bars.

 Holler with any questions.
JimD.
ProgressBar.zip
0
 
LVL 1

Author Closing Comment

by:csehz
ID: 35198151
Jim thanks very much, both the small example and also the database with demos, you are very helpful I learned a lot of today
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question