Closing 1 form and opening another

[mulefeathers]

How can close a welcome screen and open another form. I have tried use the Timer function but with little suscces.

I used this code but it doesn't do anything:

Private Sub Form_Timer()
DoCmd.Close acForm, "splash"
DoCmd.OpenForm "frmmain"
End Sub

Then I added this code:

Me.TimerInterval = 10000

Still nothing.

[RuralGuy]

It should work. Try Opening the frmMain *before* closing the Splash form with
DoCmd.Close acForm, Me.Name, acSaveNo

[mulefeathers]

This is what I have but still nothing.

Private Sub Form_Timer()
Me.TimerInterval = 10000
DoCmd.OpenForm "frmmain"
DoCmd.Close acForm, Me.Name, acSaveNo
End Sub

[JjJSeVdT]

Are you just trying to do this without a button? I usually use the welcome screen as an acknowledgement screen and set the button to close the form and open the new form.

[mulefeathers]

Yes just have it automated instead of a button.

[RuralGuy]

The Timer can do this operation successfully. Set your TimerInterval to 1000 so things happen faster for now and put in a MsgBox to make sure the event is firing.

[RuralGuy]

Are you still using ac2003 or have you moved on to a later version of Access. The later versions require a Trusted Location for code to work.

[mulefeathers]

The event is not firing. I used

Private Sub Form_Timer()
Me.TimerInterval = 1000
MsgBox "test box"
End Sub

[mulefeathers]

Access 2010

[RuralGuy]

Have you set your Trusted Location yet? http://www.btabdevelopment.com/ts/2010TL

[RuralGuy]

Access 2010

32 or 64 bit?

[mulefeathers]

32 or 64 bit?

It is a 32 bit

[mulefeathers]

Have you set your Trusted Location yet? http://www.btabdevelopment.com/ts/2010TL

No i have not. All of the users will be using 2003. I think I'm going to install that version and try re-writing this database. 2010 was giving me some problems and it's been very weird today.

[RuralGuy]

ac2010 can run ac2003 db's just fine. It is just that ac2010 requires the Trusted Location to enable code.