No records INTO table

Topic

New Reply

Hello. (Access 2003).
I’m using DoCmd.RunSql from Visual Basic to execute make-table (INTO) queries. But I end up with a few
blank tables.
How can I test the SQL statement to see if it returns no records? Thanks, Andy.

Reply | Quote

Replies

Can’t you do a DCount on the table or query with the same where condition as in the sql statement ?
Something like this :

NumberOfRecords = DCount(“*”,”MyTableOrQuery”,”WhereStatement”)
If NumberOfRecords > 0 Then
DoCmd.RunSQL strSQL
End If

Reply | Quote

Hey, I like that!
I was going to create a recordset and count records..
Thanks, Andy.

Reply | Quote