Using Update Query with Attachment Field
I had a bunch of tables connected to the client information table in 1-1 relationships so I went to combine it in one big table.
[sidenote: I read that this was horrible database design to have it spread out in tables with 1-1 relationships plus it's keeping me from inputting the information in one form because the client itself has to be inputted before I can input the documents since the document tables pull from the client name which isn't established whenI try to put it in at once.
If I'm really not that in the red with having multiple 1-1 tables then I'd love it if someone could help me make a form that would let me put in the clientinformation and the documents at once with out running into the issue of the form not knowing to create new records in the document tables with the name of the client automatically in there]That's where I'm hitting my issue;
I've been using an update query to move over the text/date/number information from the documents tables to the new master table but it won't let me transfer the attachments I've attached because it's considered a multi-value field.
We've already populated the thing and so it would really suck to have to go through by hand and re-attach the thousands of documents.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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
When I open in form view and right-click on the text box (for attachment) the manage attachments selection is greyed out. If I go to the table I can open the attachment.
Any idea why this isnt working in the form
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 want to remove all the pdf from all the records in this table automatically with VBA or something,
I thought the attachments was just a link to where the picture reside but apparently it is embedding the picture.
How can I link the attachment file from Table 1 on to this form and I want the images to change as the records are changed.
For example, if the fieldalready has "ABC" and I want to update the field of multiple records to have "DEF", then the field will be "ABCDEF" after the update is run.
I looked at the crosstab query, but that looks like it is for numbers and not text. The append query does whole records not just certain fields. butI thought I would ask before I wrote off the possibility.
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.