J
Julia B
Hi,
I've designed an Access 2003 application, where the users have a front end
file linked to a backend file on a server. Users can only see forms via
menus, and each of the forms has a Toolbar & Shortcut menu with restricted
menu options. Both include the advanced filter button. The Toolbar also
includes copy, paste, undo & redo. When I use the application and press the
Advanced Filter option, I still get the copy, paste, undo & redo toolbar
items when the filter window opens. However some other users lose them. The
toolbar disappears.
I've designed the application, but I've been opening it with what I think
are the same permissions as the other users so am completely confused.
FYI the Startup options of the application are DisplayDatabaseWindow, Status
Bar, Allow Full Menus, Allow Built in Toolbars and Use Access Special Keys
all checked and everything else unchecked. The menu setup is done via the
autoexec macro running code depending on the user id & role stored in a
table. Which does this:
If rsUsers.Fields("UserType") = "IT" Then
ChangeProperty "StartupShowDBWindow", dbBoolean, True
ChangeProperty "StartupShowStatusBar", dbBoolean, True
ChangeProperty "AllowBuiltinToolbars", dbBoolean, True
ChangeProperty "AllowFullMenus", dbBoolean, True
ChangeProperty "AllowBreakIntoCode", dbBoolean, True
ChangeProperty "AllowSpecialKeys", dbBoolean, True
ChangeProperty "AllowBypassKey", dbBoolean, True
'if the user is edit, then show the appropriate menu and disable db
functions
ElseIf rsUsers.Fields("UserType") = "Edit" Then
DoCmd.OpenForm "MainMenu"
ChangeProperty "StartupShowDBWindow", dbBoolean, False
ChangeProperty "StartupShowStatusBar", dbBoolean, False
ChangeProperty "AllowBuiltinToolbars", dbBoolean, False
ChangeProperty "AllowFullMenus", dbBoolean, False
ChangeProperty "AllowBreakIntoCode", dbBoolean, False
ChangeProperty "AllowSpecialKeys", dbBoolean, False
ChangeProperty "AllowBypassKey", dbBoolean, False
'else the user if a reader open the reader menu
Else
DoCmd.OpenForm "MainMenuReadOnly"
ChangeProperty "StartupShowDBWindow", dbBoolean, False
ChangeProperty "StartupShowStatusBar", dbBoolean, False
ChangeProperty "AllowBuiltinToolbars", dbBoolean, False
ChangeProperty "AllowFullMenus", dbBoolean, False
ChangeProperty "AllowBreakIntoCode", dbBoolean, False
ChangeProperty "AllowSpecialKeys", dbBoolean, False
ChangeProperty "AllowBypassKey", dbBoolean, False
End If
rsUsers.Close
I've been running in Edit mode, which is what the users are.
Any help appreciated!
Julia
I've designed an Access 2003 application, where the users have a front end
file linked to a backend file on a server. Users can only see forms via
menus, and each of the forms has a Toolbar & Shortcut menu with restricted
menu options. Both include the advanced filter button. The Toolbar also
includes copy, paste, undo & redo. When I use the application and press the
Advanced Filter option, I still get the copy, paste, undo & redo toolbar
items when the filter window opens. However some other users lose them. The
toolbar disappears.
I've designed the application, but I've been opening it with what I think
are the same permissions as the other users so am completely confused.
FYI the Startup options of the application are DisplayDatabaseWindow, Status
Bar, Allow Full Menus, Allow Built in Toolbars and Use Access Special Keys
all checked and everything else unchecked. The menu setup is done via the
autoexec macro running code depending on the user id & role stored in a
table. Which does this:
If rsUsers.Fields("UserType") = "IT" Then
ChangeProperty "StartupShowDBWindow", dbBoolean, True
ChangeProperty "StartupShowStatusBar", dbBoolean, True
ChangeProperty "AllowBuiltinToolbars", dbBoolean, True
ChangeProperty "AllowFullMenus", dbBoolean, True
ChangeProperty "AllowBreakIntoCode", dbBoolean, True
ChangeProperty "AllowSpecialKeys", dbBoolean, True
ChangeProperty "AllowBypassKey", dbBoolean, True
'if the user is edit, then show the appropriate menu and disable db
functions
ElseIf rsUsers.Fields("UserType") = "Edit" Then
DoCmd.OpenForm "MainMenu"
ChangeProperty "StartupShowDBWindow", dbBoolean, False
ChangeProperty "StartupShowStatusBar", dbBoolean, False
ChangeProperty "AllowBuiltinToolbars", dbBoolean, False
ChangeProperty "AllowFullMenus", dbBoolean, False
ChangeProperty "AllowBreakIntoCode", dbBoolean, False
ChangeProperty "AllowSpecialKeys", dbBoolean, False
ChangeProperty "AllowBypassKey", dbBoolean, False
'else the user if a reader open the reader menu
Else
DoCmd.OpenForm "MainMenuReadOnly"
ChangeProperty "StartupShowDBWindow", dbBoolean, False
ChangeProperty "StartupShowStatusBar", dbBoolean, False
ChangeProperty "AllowBuiltinToolbars", dbBoolean, False
ChangeProperty "AllowFullMenus", dbBoolean, False
ChangeProperty "AllowBreakIntoCode", dbBoolean, False
ChangeProperty "AllowSpecialKeys", dbBoolean, False
ChangeProperty "AllowBypassKey", dbBoolean, False
End If
rsUsers.Close
I've been running in Edit mode, which is what the users are.
Any help appreciated!
Julia