• Progress Bar (Access 2002)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Progress Bar (Access 2002)

    Author
    Topic
    WSrrdavis
    AskWoody Lounger
    April 8, 2004 at 8:16 pm #403454

    I’m looking to include a progress bar in one of my applications. Having never used one before, they seem to be a little daunting. I have a couple of examples, but really at a loss as how to implement them. Does anyone have a recommendation on how to implement a pop-up form process bar. (The progress bar in the status bar is not noticeable enough or useful in my situation.)

    Reply | Quote
    Viewing 2 reply threads
    Author
    Replies
    • WSHansV
      AskWoody Lounger
      April 8, 2004 at 9:01 pm #812339

      Microsoft has an example of creating a progress bar using native Access controls, with very detailed instructions: HOW TO: Simulate a Progress Bar in a Form Without Using an ActiveX Control in Access 2002. There is an example database using a similar idea attached to post 209085.

      post 234022 contains example code for the ActiveX progress bar control.

      Reply | Quote
    • WSHansV
      AskWoody Lounger
      April 8, 2004 at 9:01 pm #812340

      Microsoft has an example of creating a progress bar using native Access controls, with very detailed instructions: HOW TO: Simulate a Progress Bar in a Form Without Using an ActiveX Control in Access 2002. There is an example database using a similar idea attached to post 209085.

      post 234022 contains example code for the ActiveX progress bar control.

      Reply | Quote
    • WSbushaw
      AskWoody Lounger
      April 8, 2004 at 9:18 pm #812349

      If you’re comfortable with VBA,here are a couple possibilities:

      I’ve only used progress bars (in their own pop-up form) when I’m running looping VBA code (For…Next, Do While…Loop, etc.) — where the progress bar can be updated during each pass through the loop. If this fits your need, there are several approaches — (1) there’s an ActiveX control “Microsoft ProgressBar Control” (in the Microsoft Windows Common Controls library — from the VBA editor, select Tools…References and check this library in the list; then you can find it in the list after selecting Insert…ActiveX Control when in Form design view). This control has a Min and Max property to define the range of the progress bar (e.g. 0 to 100 for a percent complete). Then, in your loop you just set the control itself to the desired value within the range (e.g., the desired percentage). (2) You can add two rectangles to your form to “build your own” progress bar. Both rectangles should have the same Top, Left, and Height properties. Use fill colors to give the appearance you want. Then in your loop, recalculate the Width property of one of the rectangles (the “moving bar”) as a percentage of the width of the other rectangle (the fixed “full range” outline) based on how many times you’ve been through the loop relative to the total. Make sure the “moving bar” rectangle is in front of the full range outline rectangle (unless the latter is set to transparent).

      I hope this is enough to get you started — it’s a little sketchy. If not, holler and I (or someone else here) will help fill in the gaps.

      I don’t know of a way to display a progress bar during a long query or other activity that you can’t “interrupt” (to update the progress bar control) during it’s execution.

      Reply | Quote
    Viewing 2 reply threads
    Reply To: Progress Bar (Access 2002)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    May 2025
    S M T W T F S
     123
    45678910
    11121314151617
    18192021222324
    25262728293031

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.