command button: display database window 1

[Fredgarner]

How can I make a command button that sends the user to the database window? I do not want to rely on F11 as some of the users will not be very computer-literate.

 

[PHV]

Have you tried this ?
SendKeys "%{F11}"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PHV]

OOps, sorry for the typo:
SendKeys "{F11}"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lesw1433]

DoCmd.SelectObject acTable, , True

This will open the database window to the tables tab

DoCmd.SelectObject acForms, , True

This will open the database window to the forms tab

DoCmd.SelectObject acQuery, , True

This will open the database window to the queries tab

and so forth