How to check table is empty or not?

's Computer Specifications

Hi guys,

Does anyone know the code to check the table is empty or
not?

Thanks.

Tim.

's Computer Specifications

Thanks Tim.

Tim.
>-----Original Message-----
>Try DCount("[fieldname]","tablename")=0.
>Tim
>
>>-----Original Message-----
>>Hi guys,
>>
>>Does anyone know the code to check the table is empty or
>>not?
>>
>>Thanks.
>>
>>Tim.
>>.
>>
>.
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to check for empty table	MJ_68123	Microsoft Access	2	2nd Dec 2008 05:32 PM
Check if a table is empty	=?Utf-8?B?Um9iVUNTRA==?=	Microsoft Access Form Coding	3	1st Feb 2007 10:45 PM
check if table is empty	andrewbda@gmail.com	Microsoft VB .NET	4	27th Dec 2006 04:18 PM
How to check if table is empty	=?Utf-8?B?aG9kYXJp?=	Microsoft C# .NET	2	17th Jan 2005 02:14 PM
expression to check if table is empty	Jason Morin	Microsoft Access Macros	1	7th Jan 2004 02:28 AM