Results 1 to 6 of 6

Progress/Status Bar on Form

  1. #1
    Tomfernandez1 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Feb 2011
    Posts
    69

    Progress/Status Bar on Form

    Greetings,

    I have a Form with a command button that when executed will copy a database from one location and pastes it into another location. This command usually takes up to 20 seconds to complete. During that time, I would like to show a progress bar on the Form, so users know that work is being done behind the Form.

    Any ideas for how this can be done? I have little VBA knowledge.

    I currently use 2003 Access. Your help is much appreciated!

    Tommy

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Lake County, IL
    Posts
    1,979
    If an answer has "resolved" your issue, then make sure to mark your thread as "solved." Did my answer help? Click on the '*' below.
    Relational Database Principles
    DataPig Access Tutorials
    Debug your Code​

  3. #3
    ajetrumpet is offline Banned
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,696
    also do make sure to make the form modal. otherwise the users might start clicking around everywhere. clicking a lot when something is processing will always confuse the processor even if the clicks are just on the screen in various places. clicking is a command regardless of where you click.

    ms also has an article on how to do it with timers here: http://support.microsoft.com/kb/304581

  4. #4
    Tomfernandez1 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Feb 2011
    Posts
    69
    Adam - I was able to insert the Progress Bar Control, Version 6.0, but I have no idea on how to use it. Essentially what I need is for the Progress Bar to run while the command is running. Might you have a sample code that I could use?

    -Tommy

  5. #5
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Lake County, IL
    Posts
    1,979
    Tommy,
    My posting had sample code and downloadable examples.
    Alan
    If an answer has "resolved" your issue, then make sure to mark your thread as "solved." Did my answer help? Click on the '*' below.
    Relational Database Principles
    DataPig Access Tutorials
    Debug your Code​

  6. #6
    Tomfernandez1 is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Feb 2011
    Posts
    69
    I see. Perfect! Thanks for the help!
    -Tommy

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Progress Bar
    By pkstormy in forum Code Repository
    Replies: 3
    Last Post: 09-21-2012, 09:27 AM
  2. Replies: 9
    Last Post: 09-19-2010, 08:18 PM
  3. Sample Reporting/Exporting/Progress Bar
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-31-2010, 01:29 AM
  4. Replies: 3
    Last Post: 05-20-2009, 03:58 PM
  5. How to use progress bar
    By marianne in forum Access
    Replies: 19
    Last Post: 04-01-2009, 08:06 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums