Popping up database window 1

[davidmulcair]

My client wants the ability to access the db development window when in my security's 'admin' mode. Is there a line of code that will pop up this window? I want to attach it to a button..


Thanks

David

 

[Frink]

Hallo,

You can use:

  DoCmd.SelectObject acTable, "TableName", True
  DoCmd.RunCommand acCmdWindowHide

to select an existing table in the database window, then execute the Hide command from the Window menu
To unhide you just have to run the SelectObject line above

- Frink

 

[ScottMusich]

Depending what the security is on the database you can have the user just hit F11 to popup a hidden database window. Or hold Shift as the database open in Access. Not sure how you have it setup, but these are the simple solutions. Scott Musich
Database Analyst/Programmer