User Login Form

[glen]

Friends I am creating a user login form.after studying this article Create User Login form I created form.


and everything is working fine except this point which I attaching in pic.
I cannot understand the SQL command for drop down list.

[June7]

That is the SQL statement for the combobox RowSource property.

[glen]

yes I create this statement for row source but it is not working.
when I try to select users from combo, then selection is not working.
and give message that "control can't be edited bcoz it is bound to autodata field lngempid.

[June7]

Change field name in tblEmployees from ingempid to lngempid

Don't bind the combobox - do not set ControlSource.

[glen]

yes now working.
but there is one other problem.I want that when id and password match and after click log on it jump Switchboard the log on form should be disappear.

[June7]

You can either close the form or set it not visible. I close my login form. Your code already has line to close the login form but it has the wrong form name. Also need to change the line that follows it to reference the Switchboard form instead of frmSplash_Screen. Fix the form names in the code.

Also, set the Login form as the default form when project opens.

[glen]

Yes June I set the login form as default now. And I also change the form name in code so its working now.

Now I want that without login no one should go in database.bcoz i check without login i can work in other tables and forms.
secondly I want to hide navigation bar and Ribbon menus.
I know to hide navigation from option but no idea about Ribbon menus.

[June7]

Hiding the ribbon and shortcut menus also options for the database. Make those settings the same place as hiding the Navigation pane. Note that pressing F11 will expose the pane unless you also disable the function key. That is done by deselecting 'Use Access Special Keys'.

Review http://forums.aspfree.com/microsoft-...at-303789.html

Also note, holding down the shift key while opening db will override most of these project settings.

[glen]

Thank you but I think this is little bit complicated for me. I will try it later.
tell me just about this option:
Now I want that without login no one should go in database.bcoz i check without login i can work in other tables and forms.

[June7]

As stated, set these options in the same dialog that you set the navigation pane as hidden. http://office.microsoft.com/en-us/ac...010235717.aspx

[glen]

I hide navigation pane but still without logon i can go to file > option and I can enable it again/
I want that without logon me or no one can go inside database.
Regards,

[June7]

Your procedure has code that if user fails to provide valid password the database shuts down. I did not test that and don't have your db with me now.

Try it, what happens? Debug. Review link at bottom of my post for debugging techniques.

[glen]

I am attaching my db again.
Plz you check and tell me.

[glen]

I modified this code in db like this.

'If User Enters incorrect password 3 times database will shutdown

LogonAttempts = LogonAttempts + 1
If LogonAttempts > 3 Then
MsgBox "You do not have access to this database.Please contact admin.", _
vbCritical, "Restricted Access!"
Application.Quit
End If

this is the real code.


'If User Enters incorrect password 3 times database will shutdown intLogonAttempts = intLogonAttempts + 1 If intLogonAttempts > 3 Then MsgBox "You do not have access to this database.Please contact admin.", _ vbCritical, "Restricted Access!" Application.Quit End If

[June7]

It works? Issue resolved?