Filter menu disappears for some users

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top