How to Show Update Progress

[Guest]

I update a price list once per month. This involves comparing a table with
the manufactures price list to the prices in our table. Each part number is
checked and the price updated accordingly. There are approx. 85,000 part
numbers to check. This update takes >10 minutes to run. Is there a way to
show either a progress bar, or a record count so that the user has an idea
where you are in the update?

Thanks.

 

[Guest]

How do you perform the update? Query or code?

If by code then you could easily setup a progress bar. I have sucessfully
used the following one.

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='ProgressBar.mdb'

It is quite straight forward to setup and use.

 

[Steve]

Use an update query that contains your price list and the manufacturers
price list. Connect the part number in both tables. Update your part number
field with TblManufacturerPrice.PartPrice. This query should only take a few
seconds for 85,000 parts.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)