Open Access in Design Mode From Within Access

[burrina]

Is this a dumb question? Can I for instance while my db is open, open it in design mode from my form via code?

 

[MarkK]

An Access database doesn't have a design mode. Objects in the database do, so you can design forms, reports, tables and so on, but not the database as a whole.

You can use a form to control the mode of other objects, so you can make a button on a form open a different form in design view, but when a form is in design view, its code can't run, so a form can't design itself.

Hope that helps,

 

[burrina]

Sorry, I meant in Exclusive Mode. This works below to open it but it does not bypass the login screen? And of course it does not close the active db either.
Maybe I can't get there from here!

Dim varShellString As String
varShellString = """C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE ""C:\Users\David\Documents\frmPermission.mdb /Excl"
Dim varAccApp As Variant
varAccApp = Shell(varShellString, vbMaximizedFocus)

 

[MarkK]

Can't get where from where? Maybe describe in greater detail the entire scope of your problem.
Cheers,