Search results

  1. C

    Security using passwords in a table

    Code The code is: Private Sub cmdOpen3_Click() ' Dim cnn As ADODB.Connection ' Dim rst As ADODB.Recordset 'Check to see if data is entered into the UserName combo box If IsNull(Me.cboUserName) Or Me.cboUserName = "" Then MsgBox "You must enter a User Name."...
  2. C

    Security using passwords in a table

    Still no joy. I have re-set the combo box to a number and when it gets to that line of code it still states that I have cancelled the previous opertation. Am I right in thinking that the "strpassword" is looking through the password field in the table to see if any match what is in the text...
  3. C

    Security using passwords in a table

    Security I have done this. txtpassword is a text box on my form password is a field in my table tblnames is the name of my table username is a field in my table cmbusername is a combo box on my form It looks as if it should work but it doesn't!
  4. C

    Security using passwords in a table

    Security When I put in the following code: If Me.txtPassword.Value = DLookup("strpassword", "tblnames", "username=" & Me.cmbUserName.Value) Then it states that I have canceled the previous operation. Any ideas?
  5. C

    Security using passwords in a table

    Could anyone given me some (relatively) simple code that would compare a password on a form with a password in a table and if correct allow another form to be opened?
Back
Top Bottom