Determine if Access Table is Empty (no Records)

[dobber]

Help, Help

Does anyone know of a procedure for Access 2000 that
will look at a table, determine if it is empty (contains
no records), and then return a True/False?

I've tried everthing I can think of, and I'm stuck on this
code for the day.

 

[tlbroadbent]

Have you tried DCount?

r = IIf(dcount("*", "table&quot>0,True,False)

If r > 0 then True (table contains rows) else False (table is empty).

However, it is just as effective to test the result of DCount("*","table&quot. Result = 0 is the same as False while Result > 0 is same as True. Terry

;-) USER, n.: The word computer professionals use when they mean "idiot." -Dave Barry

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm

 

[dobber]

Thanks Terry,

That's exactly what I needed. I'm fairly new at
Access and I wasn't even aware of dcount.