Startup Screen

[Vic_Orr]

How do i make a screen pop up when i open an access database. Then the screen disappear and a menu screen appear. Can this be done without the aid of code because i cant do coding

 

[Mile-O]

Simple, simple and would be better with code but because you don't want to do it with code we'll use nasty macros.

On your first form - set it's TimerInterval property to 5000

Make a macro that closes your first form and then opens your second form.

Make a second macro that opens your first form - this must be called autoexec.

On your first form's OnTimer event, ensure it runs the first macro.

Open your database and ta da! a splash screen.

 

[Vic_Orr]

Thanx that has helped a lot

 

[Vic_Orr]

Is it possible to make it full screen??

 

[IMO]

Also, if you save an image file with the same name as the db to the same folder as the db, this will show on startup instead of the Access flash screen.

IMO

 

[Mile-O]

Is it possible to make it full screen??

Make a third macro that maximises.

Run this macro on the form's OnLoad event.

 

[RWood]

I'm interested in this...
How do you achieve this in code?

 

[J.Windebank]

IMO, thanks, that is a fantastic hint, is this documented anywhere?

 

[IMO]

RWood,

Example attached


J.Windebank,

It must be documented somewhere but I really can't remember where I've seen it, sorry.

IMO

 

[Mile-O]

I'm interested in this...
How do you achieve this in code?

One way would be to convert the macros to code and look at the structure.

I personally would set my TimerInterval to 1000 and in the form's OnTimer() event put this:

Static intCount As Integer

If intCount = 5 Then
   DoCmd.Close acForm, Me.Name
   DoCmd.OpenForm "frmMyNextForm", acNormal
End If

intCount = intCount + 1