Another litttle problem to allow All of you Colleagues to show how much better at Access than I am.
I have a client whose Access database contains an autoexec() function holding the following code snippet.
'owner can bypass startup code
If CurrentUser = "owner" Then
If Not UserYesNo("Do you want to run startup code?") Then
Set StartUpSHowDBWIndow = CurrentDb.CreateProperty(, , -1)
Set StartUpSHowDBWIndow = CurrentDb.CreateProperty(, , 0)
. . . other settings
The intention (apart from the usual one of preventing unprivleged users from mucking about with the database innards) is to create a nice background for a switchboard which is smaller than the screen size. This worked perfectly in Access 97, but after an upgrade to Office 2003, the window does not get hidden, but is merely disabled (i.e. greyed out). The effect is rather ugly and the client would like to see his system as he remembers it. Is there any other way I can code this process to give him what he wants.