AutoExec Macro

[M.Simpson]

My AutoExec macro will not make my files "Read-Only" it goes to the beginning
form properly, but won't put it in a read-only mode, I use Find Form,
GoToControl,
please help, no one ever responses to my questions!

 

[Ken Snell [MVP]]

You determine the "readonly" status of the form in the Data Mode arugment of
the OpenForm action in the AutoExec macro. Choose Read Only from the choices
for Data Mode.

 

[Steve Schapel]

Alternatively, set the AllowEdits property of the form itself to No.

 

[Ken Snell [MVP]]

Yes, but I believe that setting is overridden by the Data Mode argument in
the OpenForm action call?

 

[Steve Schapel]

Ken,

If a Data Mode argument is specified, then yes, it will override the
form design settings. But if no Data Mode argument is specified, then
the form design settings hold. So why not use the form design, and
forget the Data Mode argument?

 

[Ken Snell [MVP]]

True enough.... guess I've just gotten a bit "gun-shy" when a form closes in
a way that saved the settings when the form was open (crash, click the red
"x", other unexpected things), so I usually write code/macro that runs in
the Open or Load event to always "restore" the form to the "defaults" that I
expect it to have in the "newly opened" state. Not often that this weird
saving happens, mind you, but ... < g >