change form automatically

[garbett_d]

i have created a database and i have created a front screen, i have done this so that when you open the access file it automatically shows this screen, like a welcome page, is there any way that the page can some how be changed to the next screen? i tried using a macro but this only gives you the option to click on the screen to change this?

is there a way to somehow put it on a timer so that after 10 seconds it will change?

i have been raking my brain trying and cannot find an answer, if anyone could help me it would be much appreciated?

 

[ColinEssex]

The "welcome page" you mention is known as a splash screen.

I did a search for you on these forums and here's a link to help you.

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=43087&highlight=splash+screen

Col

 

[garbett_d]

i have tried alot of these but i am very new to VB therefore the coding means very little to me, in understanding terms! is there not a way to do this using a macro of some sort because i couldnt understand where i was going wrong with the coding?

cheers for your patience.

dan

 

[ColinEssex]

Ok - tell us what you have done so far.........Have you created the form you want to use as the splash screen?
Col

 

[garbett_d]

yeah my form's have been created!
all that it needs is code? (i think?)

 

[ColinEssex]

Ok- so in the properties of the form, find the OnTimer bit, put curser on the line, select EventProcedure from the drop down and pop in this code -



Private Sub Form_Timer()
DoCmd.Close acForm, Me.Name
End Sub

Then set TimerInterval for the form to 3000 (for 3 seconds)


Thats it - Bobs your Uncle

Col

 

[garbett_d]

buddy, you are an absoulute star!

thank you for that!

 

[garbett_d]

i just realised, in the heat of all the excitment lol! (it works!)
i dont know how to make the other screen pop up after that one has gone?
do i need to type sumit in there?

 

[ColinEssex]

After the "DoCmd.Close" bit add this new line

DoCmd.OpenForm ("YourFormName")

Col

 

[garbett_d]

yeah, got it sorted now!
finally!