Starup options

[paulscherm]

I would like to set the properties (options) in the Startup Form on the Tools menu in vba such as (allowfullmenus - true or false). I have Access 2003. Can anyone get me started? :banghead:

 

[bob fitz]

Take a look at the VBA help files. Search for "Set Startup Properties from Visual Basic" The explanation is well documented.

 

[paulscherm]

Did that, and it directs me to "CreateProperty" which I don't know how to do in vba.

 

[CJ_London]

Here is a link for how to create properties with examples

http://msdn.microsoft.com/en-us/library/office/bb221004(v=office.12).aspx

It's for 2007 rather than 2003 but the principle is the same

 

[bob fitz]

paulscherm

Take a look at the attached db.
It uses a function called “fnSetShowDbWindow(bln)” which sets the “StartUpShowDBWindow” property to true or false depending on the Boolean value parsed to it in the bln argument. If the property does not exist it throws an error, so code is added to its error handling routine to create the property.
Post back if you need more help.

 

[paulscherm]

Thanks, I believe this will work. What I wanted to do was "uncheck" the "AllowFullMenus" checkbox when the file opens. I think I can change the property in the mdb to that and it should work - right?

 

[bob fitz]

Thanks, I believe this will work. What I wanted to do was "uncheck" the "AllowFullMenus" checkbox when the file opens. I think I can change the property in the mdb to that and it should work - right?

Yes, that should work. Just curious, but why the need to do it with code.

 

[paulscherm]

Distributing file as a .mde file and want to be sure users can't access certain toolbars.

Thanks again.

 

[bob fitz]

Distributing file as a .mde file and want to be sure users can't access certain toolbars.

Thanks again.

I don't know how much knowledge your users have but it is possible to change the properties of a db, using vba from another db, without even opening your db.