VBA to bring up database window

[James Ivey]

Access Newbie
VBA beginner

On Startup, I've got the database window hidden.
I've got a splash screen with a Close Form button on it.
When user clicks on the Close Form button, I would like the splash screen to
close, AND have the database window come up - same as hitting the F11 key.
Is this doable?

Private Sub closeForm3_Click()
On Error GoTo Err_closeForm3_Click
DoCmd.Close
Exit_closeForm3_Click:
Exit Sub
Err_closeForm3_Click:
MsgBox Err.Description
Resume Exit_closeForm3_Click
End Sub


James

 

[mray29]

try
DoCmd.SelectObject acTable, , True

This will open the db window showing the Table tab.

 

[James Ivey]

Sweet. That works like a charm.

Thanks!