Can options in Tools => Options be set programmatically?

[deko]

Is it possible to set options in the Tools >> Options dialog
programmatically? For example, I want to create an Access 2002 MDE that
will set, on startup, various options in the View, General, and Edit/Find
tabs of the Options dialog. Can this be done? Are there any developer
resources for doing this?

Thanks in advance.

[Wayne Gillespie]

On Thu, 06 May 2004 21:50:08 GMT, "deko" <no****@hotmail.com> wrote:

Is it possible to set options in the Tools >> Options dialog
programmatically? For example, I want to create an Access 2002 MDE that
will set, on startup, various options in the View, General, and Edit/Find
tabs of the Options dialog. Can this be done? Are there any developer
resources for doing this?

Thanks in advance.

Search help for SetOption.

eg
Application.SetOption "Default Record Locking", 0
Application.SetOption "Selection Behavior", 1
etc
Wayne Gillespie
Gosford NSW Australia

[deko]

> Search help for SetOption.

Great! That's exactly what I needed.

From the "SetOption Method" help entry in the VB editor:

The SetOption method provides a means of changing environment options from
Visual Basic code. With this method, you can set or read any option
available in the Options dialog box, except for options on the Modules tab.