I need to create a splash screen to display on startup of my database. I already know the trick of placing a .bmp of certain size with the same name as your database in the same directory of your database and it will replace the Access splash screen, but I need to go one step further... I have already created a "blank" form with my image as the background, removed all record selectors and navigation controls, made the form popup and modual, set the border style to none, and set this form to open on startup of my database.
To back up a minute I have a lot of code attached to the "original" startup form of my DB, and sometimes it could take upto 15-20 seconds to complete (depending on the computer). So the .bmp splash screen would display for only a second, then the DB would "hang" until the code completed. So what I did now was create a splash screen form and attached all my startup code to that form, then attach code at the end to open my main form and close the splash screen form after the code completed. This essentially "in theory" would keep the splash screen displayed as the startup code was running, eliminating the hang described before.
My problem is though that for whatever reason all my code runs before the form displays on the screen. I have placed the code in the on open event and the on current event. Is there any other event I should put my startup code into so the form displays first then the code is ran?
To back up a minute I have a lot of code attached to the "original" startup form of my DB, and sometimes it could take upto 15-20 seconds to complete (depending on the computer). So the .bmp splash screen would display for only a second, then the DB would "hang" until the code completed. So what I did now was create a splash screen form and attached all my startup code to that form, then attach code at the end to open my main form and close the splash screen form after the code completed. This essentially "in theory" would keep the splash screen displayed as the startup code was running, eliminating the hang described before.
My problem is though that for whatever reason all my code runs before the form displays on the screen. I have placed the code in the on open event and the on current event. Is there any other event I should put my startup code into so the form displays first then the code is ran?
