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
    Ski Town USA
    Posts
    2,023

  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
    Ski Town USA
    Posts
    2,023
    Tommy,
    My posting had sample code and downloadable examples.
    Alan

  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