Log in form with user level template (1 Viewer)

[lubega]

Hello Members,
Am kindly requesting for a template already designed with login form combined with user level template. Am not a programmer and not able to design one with the vba codes and languages. I need a template that I can incorporate into my Inventory database so that login is limited to user rights related to responsibilities on the database forms.

Thanks and regards

NB: Am using Ms Access 2016

 

[theDBguy]

Hi. Not sure if it's a template, but take a look at this demo from the Sample Databases forum.

Password Login Screen with session login recording

This demo has been expanded from my earlier version to include the creation of a login session. Whereby once a user logs in a new session is created and is subsequently closed when the user logs out. As this is not split you will only ever see yourself as being logged in but the logic is there...

www.access-programmers.co.uk

 

[isladogs]

The example app suggested by @theDBguy should do what you want.
Please ensure you use the latest version from post #21 or you can download it from http://www.mendipdatasystems.co.uk/password-login/4594469149