PDA

Click to See Complete Forum and Search --> : How to count columns of the MS Access database using Visual Basic programming?

Fumiryu
October 25th, 1999, 08:27 PM
Can anyone please tell me how to count the horizontal COLUMNS in Microsoft Access database using Visual Basic programming? Thank you.
sriky
October 26th, 1999, 07:43 AM
your question is confusing. columns are never horizontal, they r vertical...considering u want to count the number of fields, i.e columns, open up a recordset and use the 'fields' property.

iFldCount = rs.fields.count