Updating records with attachment fields
My problem: I recently gathered some data in the attachment fields in the development copy of the database and wanted to transfer the additions to the production table. The update query came back with a message to the effect that you can't use an attachment field in an update query.
Has anyone else encountered this problem? If so, what is the workaround? VB or manual re-entry of the data
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I want to remove all the pdf from all the records in this table automatically with VBA or something,
Updating Records in MS Access;
Form and Data Access Page based update;
Updating data using the Update action query;
Updating the column using ADO.
ID is Primary Key (DataType=AutoNumber)
Problem_ID is (DataType=Number) (Indexed Yes No Duplicates)
The form "Problem Records Details" has an Unbound object called Attachment. I have tried the following as the control source:
1) SELECT [Attachment] FROM [Attachments] WHERE [Problem_ID]=Forms![Problem Records Details]![ID];
Only the attachments where Problem_ID of the attachments table equals the ID of the record displayed on the "Problem Records Details" form.
It's a split back end database that has around 1800 records.
Is there any way whatsoever to extract those attachment files from the Attachment field to an external source? I'd rather not have to go through an individually back up 2 - 3 files per record for 1800 records.
Optimistically, this is how it would work:
There is a field called NUMBERONE that is the main entry for the DB (all of it hinges on that; it will never be duplicated).
Each NUMBERONE has an attachment field (2007) that contains anywhere from 0 to 4 attachments.
I would like to be able to run something that will make a folder NUMBERONE and put all the attachments in it.
However, this field is not populated until I close and reopen the database.
How can I have the form display the attachment name as soon as the attachment is added?
I would like to add a field on the main form that will show an attachment icon (like a paper clip) if any of these fields in the single forms’s subform are not empty.
How do I reference this ONE picture with the 100 records without having to upload the same picture one by one on each record?