How to loop through the "Set Options from Visual Basic", Acc97 vba? 1

[Werneck]

Hi,

How to loop through the "Set Options from Visual Basic" (from menu\tools\options) to get their names and values with the Application.SetOption method on Access 97 VBA.

Thanks

 

[RickSpr]

There's no real way to get a complete list with code. If you have a copy of Access 97 Developer's Handbook, they're all listed in an appendix.

You can also look in the registry under HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Access\Settings. The key names are the SetOption arguments. (There are a few exceptions, mostly registry keys that aren't valid SetOption arguments.)

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[Werneck]

It worked fine, Rick!

Is it the same Application.SetOption method on Access 97 VBA to set the options for the inicialization menu? How to get the options names?

Thanks

 

[RickSpr]

I don't know what you mean by the initialization menu. Do you mean the Startup dialog box? If so, no, you can't find those in the registry, and you can't set them with the SetOption method. The Help file is your best resource. Look up Startup Properties, and find the example code for setting them from VBA.

Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[Werneck]

Rick,

I finally found it in the portuguese version of the acc 97.
It's working!

Thank you
Cesar Werneck