Doubt in vb application

hello sir,
       I have data records as "staff code"& "test" in MS access
In vb List box I have to dispaly the tests that are passed by there staff code.even same staff code may passed different
tests,that should be displayed in the list box..

          thank you
sivaraAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

askmeaksCommented:
Although, you question seems hazy, you'd had better tried ADO's Command object & Recordset object to parse the SQL queries in response to your needs, and build up the listbox by using the recordset. A simple example may be like :

Private Function PopulateStaffCode() as Boolean
On Error goto ErrorHandler
Dim xConn as new ADODB.Connection
Dim xRs as new ADODB.Recordset

xConn.Open "<Connection String>"
xRs.Open "Select staffcode from <table name>",xConn, & _
adOpenForwardOnly,adLockOptimistic,adCMDTable

lstStfcode.Clear
while not xRs.EOF=TRUE
   lstStfCode.AddItem xrs.Fields(0).value
   xRs.MoveNext
Wend
PopulateStaffCode=TRUE
Exit Function
ErrorHandler:
lstStfCode.Clear
PopulateStaffCode=FALSE
End Function

Private Function PopulateTestRecord() as Boolean
Dim xConn as New ADODB.Connection
Dim xRs as New ADODB.Recordset

xConn.Open "<Connection String>"
xRs.open "select test from <table name> where staffcode=" & trim(lstStfCOde.item(lstStfCode.ListIndex)),xConn,adOpenForwardOnly, & _
adLockOptimistic, adCMDTable

lstTestRec.Clear
While Not xRs.EOF=TRUE
   lstTestRec.AddItem xRs.Fields(0).Value
   xRs.MoveNext
Wend
PopulateTestRecord=TRUE
Exit Function
ErrorHandler:
lstTestRec.Clear
PopulateTestRecord=FALSE
End Function


The first function will populate a listbox named lstStfCode by code of all the staff. The next function will populate the next listbox named lstTestRec by details of all the test performed by the staff selected in the first listbox.

May be it will help. For more details you may contact me at v_basic@rediffmail.com
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.