Do more with
Open in new window
Dim obj As DAO.Recordset
Set obj = CurrentDb.OpenRecordset("SELECT * FROM Table1")
MsgBox ("There are " & obj.RecordCount & " records")
MsgBox ("There are" & obj.Fields.Count & " table")
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.