M
Mark Vanderslice
Hi.
I need to turn AllowFullMenus on at database startup for admin users only.
On startup options screen, AllowFullMenus is unchecked (false).
I've tried this in flash screen's Form_Open event:
If <user is admin> Then
CurrentDb.Properties("AllowFullMenus").Value = True
Else
CurrentDb.Properties("AllowFullMenus").Value = False
End If
....but of course, it doesn't take effect then because the database is
already open. If an admin user starts the database, closes it, then reopens,
they do have the full menus...but the users are lawyers and I don't think
they can handle that complex a procedure.
I'd prefer not doing custom menus or toolbars as this is otherwise a fairly
basic app. Is there a way to simply force this setting change to be applied
immediately?
TIA...
I need to turn AllowFullMenus on at database startup for admin users only.
On startup options screen, AllowFullMenus is unchecked (false).
I've tried this in flash screen's Form_Open event:
If <user is admin> Then
CurrentDb.Properties("AllowFullMenus").Value = True
Else
CurrentDb.Properties("AllowFullMenus").Value = False
End If
....but of course, it doesn't take effect then because the database is
already open. If an admin user starts the database, closes it, then reopens,
they do have the full menus...but the users are lawyers and I don't think
they can handle that complex a procedure.
I'd prefer not doing custom menus or toolbars as this is otherwise a fairly
basic app. Is there a way to simply force this setting change to be applied
immediately?
TIA...