login page

[Johanvdw]

Guys, thanks to a member (charles), who helped me developed a nice delivery note system, I would love some help to add a login system to it. When an employee are logged in, his credentials(username, tel no and signature) must automatically added onto the reports(Delivery note & gatepass). Can somebody help me with this?

 

[Ken Sheridan]

When an employee are logged in, his credentials(username, tel no and signature) must automatically added onto the reports(Delivery note & gatepass).

Rather than closing the login form once a user has successfully logged in, hide it by setting its Visible property to False in the form's module. You'll then be able to reference controls in the login form from other objects. In the attached little demo file the user logs in and enters a hashed password. If they then open either of the bound forms their user name and permissions to the form are shown in unbound controls in the form header.

 

[Isaac]

Guys, thanks to a member (charles), who helped me developed a nice delivery note system, I would love some help to add a login system to it. When an employee are logged in, his credentials(username, tel no and signature) must automatically added onto the reports(Delivery note & gatepass). Can somebody help me with this?View attachment 121852View attachment 121853View attachment 121854

Do your employees each work under a unique network login? If so, just grab that information and put it all in a table with various other attributes as needed. Then use (any one of multiple methods) to get their logged-in network username at runtime and look up their permissions from the table. such as Environ(username)

 

[Gasman]

Rather than closing the login form once a user has successfully logged in, hide it by setting its Visible property to False in the form's module. You'll then be able to reference controls in the login form from other objects. In the attached little demo file the user logs in and enters a hashed password. If they then open either of the bound forms their user name and permissions to the form are shown in unbound controls in the form header.

I just used to store static information like that in TempVars() for further use in the app.

 

[DickyP]

Ken's reply makes sense as it is functionally the same as creating a login class (for those with long memories you'll remember using hidden forms as classes in Access 95 before they were formally introduced into Access). I always do this in a class I name 'ThisApp' which contains everything I need to have 'on-tap': often only one or two items but usually a range of them.

 

[Mark_]

Do your employees each work under a unique network login? If so, just grab that information and put it all in a table with various other attributes as needed. Then use (any one of multiple methods) to get their logged-in network username at runtime and look up their permissions from the table. such as Environ(username)

Giant benefit to using the OS login is you don't have to develop security. You have a major corporation working out how to keep your system safe.

 

[Isaac]

Giant benefit to using the OS login is you don't have to develop security. You have a major corporation working out how to keep your system safe.

Thank you! Exactly. Same story as 'backups' concerns. If you work in any company with major systems like network logins, as well as file server backup schemes, or SQL dba's, some of those concerns really aren't yours, they're a dedicated team apart. Giant benefit for sure

 

[tvanstiphout]

Rather than having users remember another login, simply ask Windows who is logged in (see code in link below). This is assuming that each user has their own login.

If you are also on a Domain network, you can use the techniques and code I wrote about here to provide group-level security, so different groups can have different levels of access in the application.

 

[Johanvdw]

Do your employees each work under a unique network login? If so, just grab that information and put it all in a table with various other attributes as needed. Then use (any one of multiple methods) to get their logged-in network username at runtime and look up their permissions from the table. such as Environ(username)

Yes they do. I will have a look at it. Thank you

 

[Johanvdw]

I guess you didn't look at the sample I posted.

I did. Thank you. I am working at this moment with MichaelSmart (Another member) who is helping me. Thank you for all the options and advice