Kelvin, the Access Splash screen shows itself, then closes so fast on newer faster computers that it's almost useless to try to incorporate it as something useful in your program. Access give us no control on how long the splash screen remains on the screen. So here is the best thing to do.
First open any graphic program that you can control the canvas size. Make a .bmp file that consists of one single pixel that is gray, adjust the canvas size to be 1 pixel x 1 pixel in size. Save this file as the same name as your .mdb file.
Example: If the Access file is named MyDb.mdb, then name the .bmp file to MyDb.bmp. This file must be placed in the same folder where the .mdb file resides.
This will basically make the default Access file invisible (almost, only one gray pixel).
Now to get a Splash screen that you can control:
Build a form to emulate the splash screen, with all the bells and whistles you wish. Then set this form as the startup form in Access. In this form, use the On Timer event to open the next form. Use the Timer Interval to control how long you want the splash screen to remain open and when to open your next form.
I hope this explanation does confuse you. It really is quite simple. You can reuse the .bmp file in any app by just copying the file and pasting it in the folder where you wish to use it, and rename it to the name of this different database. (remembering to retain the .bmp extension)
Hope this helps, s-) (......love those Emoticons)
RDH
[sig]<p>Ricky Hicks<br><a href=mailto: rdhicks@mindspring.com> rdhicks@mindspring.com</a><br><a href= > </a><br> [/sig]
One other point that I forgot to mention in my previous post.
I have encountered problems with this approach if the file name consists of more than eight (8) characters in Access 97. So try to keep the name of the .mdb file eights characters or less.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.