F11 Key

  • Thread starter Thread starter Joe Cilinceon
  • Start date Start date
J

Joe Cilinceon

I was wondering if it is possible to have the main database window open from
a button on a form instead of using F11 to do it. This is after you have
unchecked the Display Database Window to off in the Startup settings. If so
what would you have to add to the On Exit control button in the way of code.
 
Use the SelectObject action, with the final argument set to True, e.g.:
DoCmd.SelectObject acForm,,True
 
Thanks Allen but the SelectObject would be what? I'm talking about openning
the main window that shows all the tables, query etc. I have it shut off at
start and when I close my form I want it to then appear.
 
There is no built-in command specifically for showing the database window.

The SelectObject command lets you select an object, and the last argument is
InDatabaseWindow. If you use True for that argument, you are selecting the
object in the database window. In order to do that, Access has to show the
database window.

So, SelectObject is the way to show the database window.

Let us know if it does not work for you.
 
Nope it didn't work, at least just Select Object didn't. I was thinking that
you needed to know the object name to use this. Thanks for the attempt
anyhow it is appreciated.
 
Ok I have it now. I didn't have it as the last statement but had it just
before the close form statement. That now works perfectly.
 
Back
Top