Results 1 to 5 of 5
  1. #1
    chalupabatman is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Aug 2016
    Posts
    114

    Access Background Worker?

    Does MS Access 2016 have a Background Worker that can be implemented to keep the UI from freezing and allowing you to write to a label to update the user on the steps taking place?

    Can someone link to a good tut on how to do this?

  2. #2
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,879
    Do you mean like a progress bar?

  3. #3
    chalupabatman is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Aug 2016
    Posts
    114
    Quote Originally Posted by moke123 View Post
    Do you mean like a progress bar?
    A way to keep the UI from freezing when running VBA

  4. #4
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,879
    I may be wrong but I believe Access is single threaded so it cant do more than 1 thing at a time.
    If you want to alert a user that the program has not frozen while a procedure is running you can employ a few methods to do so, one being a progress bar.

  5. #5
    chalupabatman is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Aug 2016
    Posts
    114
    Quote Originally Posted by moke123 View Post
    I may be wrong but I believe Access is single threaded so it cant do more than 1 thing at a time.
    If you want to alert a user that the program has not frozen while a procedure is running you can employ a few methods to do so, one being a progress bar.
    Makes sense, I have gotten spoiled working with winforms and .NET using background workers, I just assumed that VBA would be able to do the same thing.

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

Similar Threads

  1. Replies: 5
    Last Post: 08-25-2018, 04:55 PM
  2. Replies: 5
    Last Post: 10-23-2016, 07:35 AM
  3. Add worker working time
    By Japi67 in forum Forms
    Replies: 6
    Last Post: 11-07-2015, 02:07 PM
  4. Outstanding Worker
    By Micky in forum Queries
    Replies: 11
    Last Post: 04-09-2012, 02:14 PM
  5. Asynchronous programming or background worker
    By troubleduser in forum Programming
    Replies: 0
    Last Post: 12-03-2010, 01:46 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
  •  
Other Forums: Microsoft Office Forums