empty table

[tod4]

Hi,
How to check in VBA that I have table without any value (I mean for
example when I create a table with some fields but didn't fill any
fields with data yet).

Thanks
Piter

[Allen Browne]

If Table1 has a primary key field named (say) ID, the table has no records
if:
IsNull(DLookup("ID", "Table1"))

The actual count of records is:
DCount("*", "Table1")

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<to**@wp.pl> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

Hi,
How to check in VBA that I have table without any value (I mean for
example when I create a table with some fields but didn't fill any
fields with data yet).