By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,504 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

Progress bar... possible in access?

P: 47
Can anyone tell me if its possible to insert a progress bar in access, the way you do in VB???
Mar 17 '08 #1
Share this Question
Share on Google+
10 Replies


FishVal
Expert 2.5K+
P: 2,653
You may use some ActiveX, for example MSComctlLib.ProgressBar.
Something tells me it may be exactly the same you use in VB.
Mar 17 '08 #2

P: 47
You may use some ActiveX, for example MSComctlLib.ProgressBar.
Something tells me it may be exactly the same you use in VB.
In VB you use a timer control which is available as an ActiveX control, does access also have the same control??
Mar 18 '08 #3

FishVal
Expert 2.5K+
P: 2,653
In VB you use a timer control which is available as an ActiveX control, does access also have the same control??
In Access you have in form design view a toolbar with controls.
Click on [More controls] button and choose an appropriate ActiveX from the list of available ones - for example "Microsoft Progress Bar, version x.x". Normally, a relevant library reference (this case it is MSComctlLib, \WINDOWS\system32\MSCOMCTL.OCX) will be added to your project automatically. If not, then do it manually.
The object model of this control is very simple and intuitive, check availbale properties/methods/events in object browser.

Kind regards,
Fish
Mar 18 '08 #4

tdw
100+
P: 206
tdw
In Access you have in form design view a toolbar with controls.
Click on [More controls] button and choose an appropriate ActiveX from the list of available ones - for example "Microsoft Progress Bar, version x.x". Normally, a relevant library reference (this case it is MSComctlLib, \WINDOWS\system32\MSCOMCTL.OCX) will be added to your project automatically. If not, then do it manually.
The object model of this control is very simple and intuitive, check availbale properties/methods/events in object browser.

Kind regards,
Fish
I found this thread searching for a similar question.

I have a field that searches the database for duplicate values and pops up a warning if it finds one. This is because I want to allow duplicate values, but if the user enters one, he should be sure he meant it to be a duplicate (rather than not realizing it was already entered). It happens in the after update event. The problem is that the first time a new record is entered after the form is opened, this search takes several seconds.

I found the progress bar you mentioned above, however I don't know how to make show progress for the search I mentioned above. Is it possible?
Aug 11 '08 #5

FishVal
Expert 2.5K+
P: 2,653
Hello, tdw.

ProgressBar control may be updated by VBA code only. That means - if search procedure is being performed in several VBA instructions or in loop, then you may add code line to update ProgressBar control to reflect progress. On the other hand you may try use ADO events.

Regards,
Fish
Aug 15 '08 #6

tdw
100+
P: 206
tdw
Hello, tdw.

ProgressBar control may be updated by VBA code only. That means - if search procedure is being performed in several VBA instructions or in loop, then you may add code line to update ProgressBar control to reflect progress. On the other hand you may try use ADO events.

Regards,
Fish
My search procedure simply looks to see if an address (as in a street address for a house) had been entered before. It checks three tables: a New Orders table which contains quotes that haven't yet been approved by the customer, an Open Orders table which contains orders that are approved but not yet completed, and an Archived Orders table for orders that have been completed and closed out.

It seems to me from your answer above, that I could write code that advances the progress bar one third, after each table has been checked. I think I would stick the progress bar directly under the field for entering the address, and maybe throw in a Label that changes each time the progress bar advances, i.e. "Searching New Orders for duplicates", "Searching Open Orders for duplicates" etc.

If you know where I can find the programming code I need for advancing the progress bar, could you let me know? I haven't had luck with doing a search.
Aug 15 '08 #7

P: 23
Hi,

On the Question of Progress Bar, you can try the following examples and choose the one you prefer to use for your specific needs. Requred Code and examples presented here:

http://www.msaccesstips.com/2007/12/...ss-meter.shtml
http://www.msaccesstips.com/2008/01/progress-bar-on-form.shtml
http://www.msaccesstips.com/2008/01/...-counter.shtml

a.p.r. pillai
** Link Removed **
Aug 15 '08 #8

tdw
100+
P: 206
tdw
Thanks a lot, I'll try it
Aug 15 '08 #9

ADezii
Expert 5K+
P: 8,602
Here's something very simple you can look at using the built-in Access Status Bar
http://bytes.com/forum/thread645816.html
Aug 16 '08 #10

ADezii
Expert 5K+
P: 8,602
I threw together possibly the simplest Progress Bar of all using only a Form, Label Control, and a couple of lines of code. Take a look and see if it suits your needs.
Aug 17 '08 #11

Post your reply

Sign in to post your reply or Sign up for a free account.