Implement progress bar

[Frenchy646]

Hello guys,

Right, so, I've been posting quite a few times recently, and with the amazing help I've received, my program is complete ! (thank you to all those who have responded to my previous queries )

Anyway, I have running code to import information, from Excel, to my Access database.
However, the office computers are quite slow, and on the more imposing Excel sheets (>5000 rows, around 40 columns ), the code runs, but Access then suddenly becomes unresponsive after about 20 minutes of running.
I was wondering whether it is possible (I'm sure it is, but I just don't know how ) to implement a progress bar when the module starts running.
I.e I would like a progress bar to appear when the user clicks on import, indicating the progress, in %, using information on the amount of rows/columns my code has gone through.

Any ideas ? Would this require a new function or sub ?

[OBP]

I posted previously that you can use the form's Status bar to display a message, it should be possible to use the Form's Timer function to update this regularly, it might not be possible to give the %, but you display how long it has been working. But I am not sure the timer can overcome the Import though.

[orange]

I did some searching and found an approach at Datapig. I don't know if you can adapt what is given there, but it is a video tutorial that may help.

http://www.datapigtechnologies.com/flashfiles/progressbar.html

good luck

[orange]

See, an example that may be helpful at

http://www.access-programmers.co.uk/forums/showthread.php?t=201590