Hi guys and gals.
I've got a database front end on each users local drive, with the tables on a network drive.
When the user loads the database it loads the splash screen ok as it's local, but when they click the 'OK' button to load frmReturnsReport, it sometimes takes up to 10 seconds to open.
I want to create a 'loading' form which has some sort of moving indicator (be it a bar or text) that displays while it's connecting to the network database tables, and when the frmReturnsReport form opens, the 'loading' form closes.
I'm guessing maybe some sort of constant check for the FrmReturnsReport being open, but i've no idea how to do it, or the moving indicator for that matter.
Anyone got any pointers as i've not come accross anything in the forum that suits what i'm after.
Regards
Griff
I've got a database front end on each users local drive, with the tables on a network drive.
When the user loads the database it loads the splash screen ok as it's local, but when they click the 'OK' button to load frmReturnsReport, it sometimes takes up to 10 seconds to open.
I want to create a 'loading' form which has some sort of moving indicator (be it a bar or text) that displays while it's connecting to the network database tables, and when the frmReturnsReport form opens, the 'loading' form closes.
I'm guessing maybe some sort of constant check for the FrmReturnsReport being open, but i've no idea how to do it, or the moving indicator for that matter.
Anyone got any pointers as i've not come accross anything in the forum that suits what i'm after.
Regards
Griff