Control of StartUp Properties

[XP]

In Office 2003, I'm trying to code a back door using an AutoKeys macro; I
want this program to switch on certain components disabled through the
StartUp dialog box. It seems to be working, but to use it, I have to open the
FE, run the program, close the FE and re-open again before my commands "take".

Is there a way to make these commands function on the DB without having to
reopen it? OR, is that just the way it works...?

An example of my code follows:

CurrentDb.Properties("StartUpShowDBWindow").Value = True
CurrentDb.Properties("StartupShowStatusbar").Value = True
CurrentDb.Properties("AllowBuiltInToolbars").Value = True
CurrentDb.Properties("AllowSpecialKeys").Value = True

Thanks for your input.

 

[Douglas J. Steele]

That's just the way it works. As far as I know, those properties are read
only when the application is opened, and never requeried.

 

[XP]

Thanks Douglas. One more question please. I need to reset the property so
that the default main menu bar is made visible again, and reset to its
original state, but this generates an error:

CurrentDb.Properties("StartupMenubar").Value = True

How can I get that to reset without an error?

Thanks again.

 

[Douglas J. Steele]

AFAIK, that's not a property that can be addressed in that way.

Afraid I don't have sample code for playing with it.

 

[XP]

FYI,

After digging quite a bit, I found that this property is reset by setting it
to empty string:

CurrentDb.Properties("StartupMenubar").Value = ""

In testing, this worked for me...