Progress bar... possible in access?

[neosam]

Can anyone tell me if its possible to insert a progress bar in access, the way you do in VB???

[FishVal]

You may use some ActiveX, for example MSComctlLib.ProgressBar.
Something tells me it may be exactly the same you use in VB.

[neosam]

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??

[FishVal]

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

[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?

[FishVal]

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

[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.

[aprpillai]

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 **

[tdw]

Thanks a lot, I'll try it

[ADezii]

Here's something very simple you can look at using the built-in Access Status Bar
http://bytes.com/forum/thread645816.html

[ADezii]

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.