Advertisement Jump to content
Sign in to follow this  

listfields and access database in VB

This topic is 4903 days old which is more than the 365 day threshold we allow for new replies. Please post a new topic.

If you intended to correct an error in the post then please contact us.

Recommended Posts

hey! - i dont know if i put this the wrong place, if so - sorry! (i tried to post it on in the VB forum, but their AI script decited that i wasnt allowed to post if - no reason given - how lame is that?) in my program i got a list1 witch displays all the records in my DB. now what i need to do is, when i click on a object in the list1 the program should seach the database for the matching object and get info from one of the fields in the table. problem is i cant figure out a way to do it, properly because my knowlage of databases is pretty poor. its an access DB, if that matters. i got this: Private Sub List1_Click() If Data1.Recordset("GotIt") = False Then // *1 Label4.BackColor = "&H000000FF&" Else Label4.BackColor = "&H0000FF00&" End If End Sub *1: meant to check the GotIt field - but it doesnt get anyinfo on the object to search for. it cant use the listindex to find the entry in the DB, cuz ill be sorting the list and not the DB. i guess what im looking for is something like a search fucktion, maybe like: get the list text value find it in the DB read GotIt field and set variable to GotIt fields value. check if variable value is false then do this else do that end i dont know, hope some of you can help me! thanks - niux

Share this post

Link to post
Share on other sites
Sign in to follow this  

  • Advertisement

Important Information

By using, you agree to our community Guidelines, Terms of Use, and Privacy Policy. is your game development community. Create an account for your GameDev Portfolio and participate in the largest developer community in the games industry.

Sign me up!