Where would I start looking for help?

Hey all,

I have a module I'm creating and one of the things it does is execute an Import TextFile into a table in my database. After that I would like to check that table to see if any records exist. What is the best way to do something like that or where could I look to find out?

Thanks,
ari

Try:

Dim i As Integer
i = DCOUNT("[FieldName]","tblImportedTable")
If i 0 Then
MsgBox "Data Exists"
... appropriate code here
End If

and check the Help files for details on DCount (and other D-) functions.

Hope this helps!

Howard Brody

----- ari wrote: -----

Hey all,

I have a module I'm creating and one of the things it does is execute an Import TextFile into a table in my database. After that I would like to check that table to see if any records exist. What is the best way to do something like that or where could I look to find out?

Thanks,
ari

That worked, thanks.