hello forum how do I append attachement in another table with vba?
running the query gives me this error.
help me please!!!
My project
esempio.zip
hello forum how do I append attachement in another table with vba?
running the query gives me this error.
help me please!!!
My project
esempio.zip
Attachments use Recordset2
Not having used attachments, I would probably add via a recordset if it balks at the query method, though you have not shown your sql code?
So just a guess really.
For other members the message appears to be as attached when I tried it.
Presumably you would need to add all three subfields?
Might be better just to add the key for that record and attachment in some way?
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
I would guess you need a record set to do it. I don't use them either.
Are you aware of the pitfalls in using attachment fields? Suggest you google it.
If this helped, please click the star * at the bottom left and add to my reputation- Thanks
Review https://learn.microsoft.com/en-us/of...chments-in-dao and https://www.access-programmers.co.uk...hments.169056/
Attachment field is a type of multi-value field but has to be treated differently because data is coming from drive location.
Also Review https://www.devhut.net/adding-attach...cess-database/
Last edited by June7; 02-26-2023 at 06:47 PM.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Hi Nicola
As suggested by other Forum Members, I would not use attachment fields but use another related table to store the FilePath to
the specific Documents associated.
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
If you insist in your original quest please have a look at this link from theDBGuy with a sample showing you how to do it:
http://www.accessmvp.com/thedbguy/de...attachment.php
Cheers,