Using DAO I want to return the number of columns/fields from a particular access table to my vb application.
Thanks in anticiaption
Printable View
Using DAO I want to return the number of columns/fields from a particular access table to my vb application.
Thanks in anticiaption
Define your recordset:
dim RS as DAO.Recordset
Open your recordset:
RS.Open <SQL>,other parameters
GetFields:
Debug.print RS.Fields.Count