Help in user variable @ access 2010

[Lourenço]

Hi to all.

Im working in an Access DB. and im whit a problem
at entering my Db, i have created a login form.
the form testes the user and the passwornd in the login table.

if the user and pass ar correct (after cheking the table) i can enter to the next form. Befor i close the login form, i can put in the text box of the next form (main form) the correct name from lhe correct login.

so far so good.

the problem is, when i avance to other form and came back i lost the var value that i have colet in the login table.

how i can use the value that i had put in the loginform, in all forms, to helping me to use the same username at all tables? and keep disable the admin botton is the user have not admin privelige

thanks

I had upload the DB here in case of someone whant to analise:
https://meocloud.pt/link/086701b2-9c39-4e53-9c5a-28147fe400d3/Help%20DB/[/url]

The user / pass whit no admin level is: user / user
the user / pass whit admin level is admin / admin

Thanks in advance

 

[sneuberg]

Probably the easiest way is to use a Tempvar. Look at http://www.iaccessworld.com/how-to-set-temporary-value-tempvars/ and
https://msdn.microsoft.com/en-us/library/office/ff821458.aspx

 

[Lourenço]

THANKS sneuberg

That was REALLY what i was searching for

 

[The_Doc_Man]

The other way I use is that I have a "security" general module that contains the subroutines for every test I would use on a user. I put some public variables in the top of the general module (before the first function/subroutine), which means they are visible to ANY class module. But where we might be different is that I don't close my opening form until I'm about to exit - so the security module stays open, too. That happens because my opening form is a dispatcher or switchboard and stays open - but not always "on top" (see "Bring to Top" as a topic). So when I open another form, the controlling form stays there to prevent my users from seeing the navigation pane and ribbon when they exit the SECOND form.