Setting Global Options

[PeterM]

Is there a way to set global options within VBA. I'm particularly interested
in setting the security level to low (to eliminate that annoying start up
message), setting the status bar to false and "Behavior Entering Field" set
to start of field. Is there some place that lists the options that can be
set?

Thanks for the help!

 

[Tom van Stiphout]

On Thu, 4 Mar 2010 19:30:04 -0800, PeterM

For the latter two check the SetOption keyword in the Help file.
The first one requires a registry setting. You can google or bing for
it.

-Tom.
Microsoft Access MVP

 

[PeterM]

Thanks Tom, exactly what I needed!

On Thu, 4 Mar 2010 19:30:04 -0800, PeterM

For the latter two check the SetOption keyword in the Help file.
The first one requires a registry setting. You can google or bing for
it.

-Tom.
Microsoft Access MVP


.

 

[Allen Browne]

Peter, to add to Tom's suggestion, the names to use with SetOption is not
always obvious, so here's the list for Access 2003:
http://msdn.microsoft.com/en-us/library/aa172326(office.11).aspx

And for Access 2000:
http://msdn.microsoft.com/en-us/library/aa140014(office.10).aspx

 

[De Jager]

Thanks Tom, exactly what I needed!