Basic VBA question

[timarndt@core.com]

Okay, I'm pretty good at Excel VBA and am moving slowly into Access projects.

I am confused a little by the object model I would think the following expression would set the variable x to the number of records in an existing table named tblData:

x = tblData.Records.Count

Doesn't work. So my basic question is how do I interact with a table. Does it always have to be through creating a recordset?

Thanks,
Tim.

 

[dk]

Yes, use a recordset to work with the data within the table and use a DAO TableDef object or ADOX Table object if you want to work with the table definition i.e. it's structure.

 

[bat17]

also with Access you need to move to the last record before you do a count as it does not download all of the records in a recordset untill it needs them and this can give a false count.

Peter