Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    3

    Unanswered: ADO / login / Database

    Hello people i've got a prob with my code you see im making a login but the thing is i've got my data base and in their i have my UserName fields and password fields yea and my controls on my visual basic are connected to the fields in my data base yea but when i come to code it and everything when i go if txtpass.text = adofirewall.recordesource!Password then
    mshbox "yes"
    else
    msgobox "no"
    end if
    i get an error saying Qualifer must be collection ???? what i dont understand
    and even when i change it to Recordset!Password it just keeps saying yes all the time even when i check the data base its stupid i just need it to work for the user name and password its been doing ma head in now for like 3 months nothing please help me

  2. #2
    Join Date
    Mar 2004
    Location
    www.scirocco.ca
    Posts
    346
    Please post the code that you are using.
    http://www.scirocco.ca/images/banner...occobanner.gif

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

  3. #3
    Join Date
    Apr 2004
    Posts
    3
    here is the source code

    If txtpass.Text = adofirewall.Recordset!Password Then
    MsgBox "password correct"
    Else
    MsgBox "you are denied"
    End If
    End Sub

    hope u can help me

  4. #4
    Join Date
    Apr 2004
    Posts
    3

    Exclamation

    IS SOME ONE GOING TO HELP ME THEN

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •