VBA for Progress/Load bar on my Form

[nwood]

Hello,

So I have a button that runs Acces VBA to run Excel macros and Access Queries. I have gotten the button to work, but now I am trying to figure out a way to add a progress bar to my form that shows progress to the end user.

I have looked online and haven't been able to figure out how to do it myself. I am relatively new to Access so I would appreciate any help!

[ranman256]

ProgBar.value = N / Total
doEvents

be sure to add the doEvents so the form will update.

[nwood]

ProgBar.value = N / Total
doEvents

be sure to add the doEvents so the form will update.

So where would I put this code? I have seen online people make rectangles and text boxes to do it, so would it be something like that? Would I put this code between all my each action in my code. I am confused

[ssanfu]

Watch this youTube video https://www.youtube.com/watch?v=0SqcA9vIRs0


https://stackoverflow.com/questions/...n-in-ms-access
http://www.granite.ab.ca/access/progressbar.htm
https://bytes.com/topic/access/insig...s-meter-access

[ranman256]

In the button click, or macro.
what are you watching the progress of?

[nwood]

In the button click, or macro.
what are you watching the progress of?

I am watching the progress of VBA code being executed in Access. I'd like the progress bar to be based on time, not on completion of certain events.

[ssanfu]

Interesting, but not very feasible, IMO. The length of time code takes to execute depends on the CPU speed, FSB speed, amount of RAM, amount of data (more data = slower), network speed (if BE is on a network), possibly hard drive RPM (5400 vs 7200 rpm, SATA vs SSD),......


If you knew the number of lines of code to be executed, you could update the progress bar after x number of lines, but it wouldn't be time based.......