Discussion Locked

Access 97 Splash Screen Problem

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I'm trying to set-up a splash screen for an Access 97 database. Everything works on it except that the form doesn't display.

The title bar for the splash form displays, but the form is empty. It looks fine if I just view it inside the databse, but when I autoexec it at start-up, it's empty.

Any ideas????

4 replies

by sl-campbell

You could just make bitmap of your choice, with the same name as your database(the extension remains .bmp) in the same diectory as your database!

On how to create one with a custom form check out this MS kb artikel: Q101374
at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q101374

I will outline what MS says:

For best results, the splash form should have its form properties set as follows:
ScrollBars: Neither
PopUp: Yes
Modal: Yes
RecordSelectors: No

'>Create a new module, and type the following functions.

Option Explicit

Dim gSplashStart
Dim gSplashInterval
Dim gSplashForm

Function SplashStart (ByVal SplashForm As String, ByVal _ SplashInterval As Integer)
' Open the splash form.
DoCmd.OpenForm

gSplashStart = Timer

gSplashInterval = SplashInterval
gSplashForm = SplashForm
End Function

Function SplashEnd ()
Dim RetVal

Do Until Timer - gSplashStart > gSplashInterval

RetVal = DoEvents()
Loop

DoCmd.Close acForm, gSplashForm
End Function

'Then save the new module as Splash.

Macro Name Action
---------------------------------------------
AutoExec RunCode

RunCode

AutoExec Actions
---------------------------------------------
RunCode

Function Name: SplashStart("YourSplashFormNameHere", 5)

RunCode
Function Name: SplashEnd()

by sl-campbell

I removed most of the comments in order to shorten the post. Go to the MS site above more more detail.
If you need more help then post a comment and I will get back to you!

This discussion is closed to new replies.