Progress of linking tables...

[vanillapod]

Hi, my database is split into a front and backend. Anyway the front end deletes all linked tables when it is opened, gets the path for the backend on a network server and then links to the appropriate tables, this is done everytime the dbase is opened for various reasons.
Anyway i've got a form that tries to display the progress of deleting / re-linking tables but using the onload / onopen events It only shows the form once the code has been run and the process has finished... i want the code to be run as soon as the form opens and then for various text boxes to become visible informing the user at which stage the code is at, can anyone help? i bet its something easy....
Cheers
Gary

 

[Ed2020]

Personally I'd create a form and add the ActiveX Progress Bar control.

You can then add a value to the progress bar every time you have relinked a table (e.g. if you have 10 tables add 10% every time a table has been linked).

Make sure you repaint the progress bar everytime you have changed its value so that the change is displayed.

Much easier than creating your own progress bar.

Does this help?

Ed Metcalfe.

 

[vanillapod]

Cheers for the response Ed2020 , i've used that b4, thing i was wondering was would i have any problems roling the DB out to other PCs, will the progress bar activeX control be installed on all PCs running Access???

 

[Ed2020]

Vanilla,

Should be no problem. The progress bar is part of the default package. I've never had any problems using it.

If that doesn't work you could always manipulate the Access progress bar, but I've never thought that as satisfactory as the ActiveX one.

Ed Metcalfe.

 

[vanillapod]

Hey cheers Ed2020 yep i'll go with that option instead of my original idea, all this just to keep those little users amused and happy!
cheers again