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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brook - 24 Nov 2005 06:31 GMT

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

Reply to this Message

Duane Hookom - 24 Nov 2005 06:34 GMT

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

Signature

Duane Hookom
MS Access MVP

> good day all,
>
[quoted text clipped - 8 lines]
>
> Brook

Reply to this Message

Brook - 24 Nov 2005 06:56 GMT

Can this be done through a command button on my main form?

Brook

> Hold down a shift key when opening your MDB or press F11 or view the
> database window.
[quoted text clipped - 11 lines]
> >
> > Brook

Reply to this Message

Duane Hookom - 24 Nov 2005 08:10 GMT

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

Signature

Duane Hookom
MS Access MVP

> Can this be done through a command button on my main form?
>
[quoted text clipped - 18 lines]
>> >
>> > Brook

Reply to this Message

Douglas J Steele - 24 Nov 2005 13:32 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> You could use code like:
> DoCmd.SelectObject acTable, "tblOneOfYourTables", True
[quoted text clipped - 21 lines]
> >> >
> >> > Brook

Reply to this Message

Brook - 24 Nov 2005 14:31 GMT

Thank you...

That was exactly what I was looking for!

Brook

> You could use code like:
> DoCmd.SelectObject acTable, "tblOneOfYourTables", True
[quoted text clipped - 21 lines]
> >> >
> >> > Brook

Reply to this Message