Toolbars/Startup for User Groups

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sweyer - 10 May 2006 20:43 GMT

I have a database set up with Full Data Users and then Admins. I would like
to be able to hide a toolbar or buttons on a toolbar for users in the Full
Data group, but then show all for Admins. Then I would like to have the
Database window appear upon startup for Admins (along with the switchboard)
and have only the switchboard appear for Full Data Users. Is there a way to
do this without coding? I know NOTHING about coding or macros in Access and I
was hoping to not have to figure it out right now. Thanks!

Reply to this Message

Keith Wilby - 11 May 2006 08:50 GMT

>I have a database set up with Full Data Users and then Admins. I would like
> to be able to hide a toolbar or buttons on a toolbar for users in the Full
[quoted text clipped - 6 lines]
> and I
> was hoping to not have to figure it out right now. Thanks!

Do your Full Data Users know about the "bypass" key? If they don't then
just set the startup options to hide what you don't want them to see (Tools
... Startup). You can get in as normal by using the "bypass" key, that is,
hold down the shift key when you open the app.

If they do know about the "bypass" key then some coding will be required.

HTH - Keith.
www.keithwilby.com

Reply to this Message

sweyer - 11 May 2006 18:49 GMT

Awesome.....I'm a new Access user and I didn't know about the "bypass" key. I
doubt the few users I have would know about the bypass key. Thanks that
worked perfectly!!!!!!

>>I have a database set up with Full Data Users and then Admins. I would like
>> to be able to hide a toolbar or buttons on a toolbar for users in the Full
[quoted text clipped - 11 lines]
>HTH - Keith.
>www.keithwilby.com

Reply to this Message