how to refer to if attachment count is zero vba

[aspen]

good day

I have a form (Datasheet view) based on a table "Table1". I frequently moove attachments from one record to another and as a result some of the records in the table has zero attachments (no attachment). what i am trying to do is have a code or macro on the after update event of the form to delet the record if the attachment field is null or zero .
my attachment field name is 'Files'. I have tried various tqunique to refer to attacment field. like if is null, is null, count zero. I think its a bit defferent than a normal field.
can some one please help me in writing the code " if field name 'files' attachment count is zero do comand delet record". I searched google and very few examples were there
but non worked.

please help


thank you

[pbaldy]

I haven't needed this (don't use the attachment data type), but a quick Google found this:

http://stackoverflow.com/questions/7...crosoft-access

[aspen]

Thanks pbaldy

if we use this coding for a text field it works but not for attachment daata type
If (IsNull(.Files)) Then
DoCmd.RunCommand acCmdDeleteRecord
is there a defferent way to refer to attachment data type
I cheched the link but i couldnt understand the second part PART 2 - Use the custom function in your Access query. I have never done anything like that in a query. I pasted that coding in sql window of the query "SELECT Table1.ID, AttachmentCount("Table1","MyAttach","[ID]=" & [ID]) AS [Num Attach]
FROM Table1;" . It created a field inthe query "Num Attach: AttachmentCount("Table1","MyAttach","[ID]=" & [ID])". In datasheet view it showed a "0" in each field. But my table had attachments in some fields.
What do you think i am doing wrong

Thank you

[aspen]

Dear pbaldy

Thank you so much. I got it working. I did some mistake may be. Now i have the record set count right so maybe i can make a delet query some thing.
Thank you very much for the for the quick response.

have a good day

thank you