Jump to content
  • Advertisement
Sign in to follow this  
Niux

listfields and access database in VB

This topic is 4842 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 programmersheaven.com 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
Advertisement
Sign in to follow this  

  • Advertisement
×

Important Information

By using GameDev.net, you agree to our community Guidelines, Terms of Use, and Privacy Policy.

We are the game development community.

Whether you are an indie, hobbyist, AAA developer, or just trying to learn, GameDev.net is the place for you to learn, share, and connect with the games industry. Learn more About Us or sign up!

Sign me up!