Hello everyone again
ok i have a login form which will ask for username and password and the username and password is ok then the login form will be closed and the main menu form will be open now how can i pass the id of my username from the login form in to the main menu?
Thanks for your help

Best Regards,
Hamed Gholamian

Hi Hamed,

If you are using the built in Access Workgroup funtionality you can use the access function CurrentUser() to get the current user name. For example, if you need to display the logged in user in a text control on your main form you can do something like this -

=[CurrentUser] & " is logged on here."

HTH

Jon

no ok this is the scenario
table = tbusers
fields = id,ingun,ingps,ingac
and i use this fields in my login form
now if the username and password is ok then the login form will be closed and the main menu will open
but how can i pass the value of id(which w=is username id)pass in the second form(main menu)
because i want to show the current username


Best Regards,
Hamed Gholamian

Have you tried passing the values in the openargs of the openform method? If you have got the details already on the login form you can just pass the details and handle them when the main form loads. Decalre a private variable in the declarations of your main form and use that.

DoCmd.OpenForm "frm_Main", , , , , , txtUserName

Then when the main form opens handle the value -

'Declarations
Private strUser as string

Private Sub Form_Load()
    If Not IsNull(OpenArgs) Then
        'populate the mod level var with the openargs
        strUser = OpenArgs
        'or perform some other action if required???
    End If
End Sub

Alternativly if you need to access this value globally create a new module and declare the strUser variable as public. when your password form closes just populate the global variable. -

strUser = txtUserName

The variable will then be accessible to all database objects.

Any good???

let me try it and see what happen

Best Regards,
Hamed Gholamian

Hamed,

Sorry, Ignore the part about global variables. You would need to create a class module for this to work. The easiest way is to use the openargs argument of the openform method.

Hamed,

You can create an unbound text box on your main menu. Once you have verified the user, open the main menu BEFORE YOU CLOSE THE LOGIN SCREEN.
Set the value of your unbound text box to your user id, and THEN close your login form.

Good Luck,

Kevin

ok that was a first thing which i had done and it was fine but one problem how can i close that form without notifying the user and ask user to close it?

Best Regards,
Hamed Gholamian

are you using vb code to verify the user id and password? If so, after you have verified it, use the docmd.closeform to close the login form.

does that help?

Kevin

yes i use vb code but if i close the form how can i tell my other form to use the same id when there is no form i even public my intiger but it doesnt work

Best Regards,
Hamed Gholamian