[airprince]

Greetings!

Please help me know how to SELECT record from the database in Visual Basic using MS Access Database. Like for instance I want only to view all record with LASTNAME = "GONZALES". All other records without that kind of LASTNAME with not appear on my report.

Hope you could help me.

Thanks.

Airprince

[digioz]

Read up on how to use the Query Builder in Microsoft Access, if you don't know how to write SQL Statements:

http://www.qodbc.com/qodbcoffice.htm

Also, for future questions please at least put "some" effort into trying to use search engines and read tutorials on the subject you need.

[bhar]

Hi,

Some hints:

Set rs=New ADODB.Recordset
rs.CursorLocation=adUseClient
rs.Open "SELECT LastName FROM Table WHERE ..... (condition)",CN,adOpenDynamic,adLockOptimistic,adC mdText

Where CN is the connection object (Should be opened )

TRy this Title:"Develop an Inventory management Application Uisng Microsoft's Visual basic" by VK publishers

Regards
bhar