Hello,
How can a login form be created with password and security levels? I am not that experienced so please not too complicated.
Thank you very much,
Bill
Hello,
How can a login form be created with password and security levels? I am not that experienced so please not too complicated.
Thank you very much,
Bill
The way I typically do this is to have a 'login' form that passes a user ID to my 'main' form. The control holding the user ID is locked/disabled so the user can't change it while they're logged in. Then base all button/form accessibility based on the user ID. I typically do that part by having a 'security level' sorted from 1 to x and each control (button, field, etc) I want to show or suppress based on security level I have a routine to hide or show those controls.
I didn't create a user table or security table yet. I am sorry I never did a login form.
I do however have a main Switchboard form setup though.
Bill,
Steve Bishop has several youtube videos on this.
Try google with this criteria youtube ms access steve bishop login form
Good luck.
Thank you Mr. orange I will do that.
for the benefit of other responders, crossposted here
https://www.access-programmers.co.uk...d.php?t=305569
This is not cross posted
Hi Hpool,
I have created my own switchboard management system based on the original Microsoft switchboard manager.
https://www.niftyaccess.com/nifty-switchboard-builder/
I would be interested in collaborating with you on future developments of both of our systems...
Sent from my Pixel 3a using Tapatalk
Hi Hpool
Couldn't help but notice several of my code modules in your navigation pane screenshot.
Hope you are finding them useful.
Just to add that before you reinvent the wheel, there are many existing examples available online that cover much if not all the items you have listed.
For example this password login in form with session info http://www.mendipdatasystems.co.uk/p...gin/4594469149
Hi Colin,
I am and I am trying to put a number of the most useful modules in one place.
Which bits are the code you wrote? who name will it have?
I am also trying to create a decent UI.
Regards
The highlighted modules are all from my applications - possibly from the control the Application Interface app available at http://www.mendipdatasystems.co.uk/c...ace/4594365418 and various forums.
Some of the code was written by others who I've acknowledged.
The rest of the code is mine or modified by me unless stated otherwise in the modules.
My full name is in modResizeForm e.g in FixFormzSize if you want to state authorship
The highlighted modules are all from my applications - possibly from the control the Application Interface app available at http://www.mendipdatasystems.co.uk/c...ace/4594365418 and various forums.
Some of the code was written by others who I've acknowledged.
The rest of the code is mine or modified by me unless stated otherwise in the modules.
My full name is in modResizeForm e.g in FixFormzSize if you want to state authorship
Hi,
Yes i found theses a few weeks ago, really great code, many thanks. I've added as is so all acknowledgments as still there.
Would it be worth starting a GitHub and putting all the best bits of code in one place?
Regards
Hi
You can already find all my example apps, code samples and extended articles in one place.
Check out my website http://www.mendipdatasystems.co.uk/
I have thought about starting a GitHub area as well but other things are higher priority for now.
Anyway I'm glad you're finding the code useful.
At some point I really should add my own name as the code author on each module where relevant...
Ive never put my name to anythingHi
You can already find all my example apps, code samples and extended articles in one place.
Check out my website http://www.mendipdatasystems.co.uk/ some great stuff there.
I have thought about starting a GitHub area as well but other things are higher priority for now. Ok i can start one.
Anyway I'm glad you're finding the code useful. Yes very
At some point I really should add my own name as the code author on each module where relevant...
I wrote a right menu constructor. need to find where it is.
Was working on a context calculator, IE for dates if on a date.