suppose there is name and phone no in ms access database. i want to reterive the selected fields ie, by giving text in textbox and prompt for go command, i want to display that selected data (names or phone no) to display as table in alphabetical order.this should be done in vb 6.0 code.

Yes this can be done if you use

"Select Field1 from TableName where Field1 Like '" & Text1.Text & "' Orderby Field1"'"

I hope this might help you

this should be done in vb 6.0 code.

why not. yes done.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.