Creating A Locked User Interface

[skoz44]

We have been utilizing an inexpensive pre-made vehicle database for a while and I'm in the process of creating one in Access too allow me greater flexibility in design of it. The problem I've run into is all the database samples I've seen all contain a user interface that is not locked, thus the tables are accessible to the user. I'd like to hide all the things that a user does not need access to create a look similar to the attached.

Where do I look to learn how to do this and does anybody have a sample database that contains this I can look at?

Thanks,


Aaron

[ranman256]

you can create a copy of your form, remove the fields you dont want others to see , save
then look at the user, then determine whether to open the full form , or abbrev. form.
this form can also be set to lock fields so user cant change them.

If that is so, then you will want a user table ,tUsers that has each userID and rights for that user.
the userID is captured when the main form opens
vUser = Environ("Username")


Then you can determine that users rights from his login.

vRights = dlookup("[rights]","tUsers","[userid]='" & vUser & "'")


select case vRights
   case "All"   'all rights
      docmd.openform "frmEdit"


   case "RO"    'read only
      docmd.openform "frmRO"
end select

[cbende2]

In Form Properties, under the "Data" tab, you can set "Allow Editions" to "No."

You may also be talking about the "Navigation Pane" which is on the left side of access.

If you want to hide this, go to File>Options>Current Database>(Uncheck) Display Navigation Pane.

If you save your database like this, you will now have to hold the "Shift" key while opening the database, and once the database is open you can let go of the "shift" ket. This will bypass your macro to open the main form. And it will also display your navigation pane.

[June7]

And also disable ribbon, function keys, and shortcut menus so they can't expand the navigation pane.

The posted image appears to show custom ribbon.
Review:
http://www.accessribbon.de/en/
https://msdn.microsoft.com/en-us/lib...ffice.12).aspx

However, holding down shift key when opening accdb will bypass those option settings and everything is wide open.

[cbende2]

OR...

If you install runtime version of access on the users machines, you wont have any of these problems. However, you lose complete functionality of ribbon.

[ItsMe]

OR...

If you install runtime version of access on the users machines, you wont have any of these problems. However, you lose complete functionality of ribbon.

Are you sure about that? I go through extra steps to disable the ribbon.

[skoz44]

Those are exactly the answers I was looking for. Thanks to all.

[skoz44]

Now how do I mark this thread as solved?

[June7]

Thread Tools dropdown above first post.