Hi guys, How to check if file is stored in attachment field? What I want is that when uploading an attachment for a document there should be an output status column of "Completed". This is very convenient.
Does anyone know how to use the query? Thanks!
Hello,
Attachments are provided as recordsets in a DAO.Recordset2. This can be opened and then you can determine the number of records in the recordset.
For an example of access, see here:
https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/recordset2-object-dao (https://learn.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/recordset2-object-dao)