Main form ... command button to open in design mode?

G

Guest

good day all,

I have my db set up to open to my main "switchboard" when I open my db. I
was wondering if there was a way to open the db in design mode (maybe with a
password) so that I could easily make behind the scenes modifications...

Any suggestions?

Thanks,

Brook
 
D

Duane Hookom

Hold down a shift key when opening your MDB or press F11 or view the
database window.
 
D

Duane Hookom

You could use code like:
DoCmd.SelectObject acTable, "tblOneOfYourTables", True
 
D

Douglas J Steele

It should probably be pointed out that in Access 2000 and newer, you must
have the database opened exclusively to be able to save any changes you
might make.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Switchboard error message 1
Accessing Database design mode 5
Access how to open existing database from another database using Access - VBA 0
" There was an error executing the command" 3
Open form if conditions are met 1
Opening an Access db within vba 1
Command Button - Please help. 2
Invalid use of Null when trying to add a command button to a form? 0

Top