Hello,
Im trying to open a certain form in Access 2007 on startup and not show the navigation pane. I remember there was an option to show a splash screen in Access 2003. How do you do that in 2007?

Thanks in advance!

Josh

Hi Josh,

(IMG:style_emoticons/default/welcome2UA.gif)

Are you talking about?

Office button > Access Options > Current Database > Display Form

Hope that helps...

Thats actually what Im looking for. I cant believe I missed that! Thanks DB Guy!!!

I actually have another question now. (IMG:style_emoticons/default/smile.gif) If I wanted to do a splash and make it disappear after a set interval? I know its an event but I dont remember which one it is..

Hi
Should get you started... How to create a Start-Up Form (Splash Screen) that displays when the database is opened:

HTH's
(IMG:style_emoticons/default/thumbup.gif)

Thanks Larry. I didn't have all the event procedures now I see them. Now if I want to open another form called main, how would I modify this code?

Private Sub Form_Timer()
'On the forms timer event close the start-up form
DoCmd.Close acForm, "frmStartUp"
'Open up the main switchboard form when the start-up form closes
DoCmd.OpenForm "frmSwitchboard"
End Sub

Hi
Try....

(IMG:style_emoticons/default/thumbup.gif)

Hi,


(IMG:style_emoticons/default/yw.gif)


In case you are interested... if you create a BMP image for your splash screen, give it a name that is the same as the name of your database application, and then put the BMP file in the same folder as your database application; see what happens when you open your application.

Good luck with your project.

Ok I got that to work but now every 5 seconds, it launches the main form on top of what I am working on. How can I make it stop doing that?

Hi,

Just curious if you saw the bottom part of my reply above. You might want to give that a try.

Cheers

DBGuy, COOL! never knew about this. (IMG:style_emoticons/default/thumbup.gif)

Hi Trapper,

When Access opens a database file, it looks for an image file with the same name. If not found, you get the Access logo.

Cheers

Hi Jsblackmaro

In your form_timer event on the splash form the first command must be Me.SetTimerInterval = 0
That stops the timer, otherwise, as you have observed the event will keep firing.

And while dbGuy's solution is nifty, in many cases the application simply open to fast for anyone to enjoy the splash screen ;-)

Unless of course they have shift opened an Acces file many times, because every time you do a line is added to your registry (I have no clue why). That was the case in 2000 anyway. Haven't checked it for 2010 yet.

This makes Access progressively slower in starting up, so when you have about 500 lines in there you will see your splash screen.

Hth

Jock

where do I find the path

Office button > Access Options > Current Database > Display Form

Hi Daviddu,

(IMG:style_emoticons/default/welcome2UA.gif)

That path was for Access 2007. Access 2010 doesn't have the office button anymore. So, if you're using 2010, the new path is:

File > Options > Current Database > Display Form

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)