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.

Recommended Answers

All 2 Replies

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.