How not to output when OutputTo function returns no records?

[clarencelai]

Hi..

I have a question regarding the DoCmd.OutputTo function.

I am automating some email scheduling with file attachments generated from OutPutTo function.

However, some of the daily OutPutTo functions do not necessarily return any records. For such cases, my program is still attaching empty files (with no records) in the email.

How can my program check that the OutputTo function did not return any records?

Much appreciated if anyone could advise.

Cheers!
Clarence

[missinglinq]

I would think you need to check your table or query to see whether it contains any records before carrying out the operation. DCount() should do the job!

If DCount("*", "YourTable") > 0 Then
  MsgBox "Carry out your OutPutTo Operation"
Else
  MsgBox "Don't carry out your OutPutTo Operation"
End If
 

Linq ;0)>

[clarencelai]

Hi Linq,

Thank you very much for your assistance.

Have a great day!

Clarence

I would think you need to check your table or query to see whether it contains any records before carrying out the operation. DCount() should do the job!

If DCount("*", "YourTable") > 0 Then
  MsgBox "Carry out your OutPutTo Operation"
Else
  MsgBox "Don't carry out your OutPutTo Operation"
End If
 

Linq ;0)>