Hai friends could you help me?
In VB if i've connected ms access project through a data control to my form..... and i've added many records to my database... and I've set "yarn no" as my primary key... if later I've to update my stock details... I need to retrieve the data s from the record once i've entered the yarn.no (i.e)primary key value....
so can anyone help
Jump to PostDo you mean a query that will retieve the data you recently added? if that's the case hope this would help...
" SELECT * FROM [[I]tablename[/I]] WHERE Yarn_No = '" & txtYarnNo.Text & "' "
Do you mean a query that will retieve the data you recently added? if that's the case hope this would help...
" SELECT * FROM [[I]tablename[/I]] WHERE Yarn_No = '" & txtYarnNo.Text & "' "
you ned t open the recordset by passing the primay key value at runtime as suggested in the previous post.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.