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
I can see the attachment FileData, FileName and Filetype when I go into query view, but when I attempt to create an update query that will take the FileName and populate the new field, I get an error that states
Enter Parameter Value with the ReportAttach.FileName below.
Does anyone know how I can get the Filename into a new field
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 the table contain one field of data type Attachment and changes to this field doesn't seen to trigger the After Update macro.
How do I save changes to an Attachment data type?
I want to use a macro directly from the table rather than using code triggered by the update form since I don't want the history saving to be bypassed by people making updates directly to the table.
The attachment itself doesn't have to be resaved, but I want the history table to show that a change have been made
Can someone please help, it takes a long time to add each attachment seperately.
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?
Here where the issue is: it seems that I can't add one field representing the file to be visible in the form.
There is number of file metadata such as: .FileData, .FileFlags, .FileName, .FileTimeStamp, .FileType, .FileURL.
I would only like to display an icon, or a filed representing the attachment.