X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Vba To Attach File To Record From Other Table, Access 2013    
post Oct 26 2019, 05:08 PM

Posts: 8
Joined: 28-August 19

Im having trouble trying to do the following:

table2 contains [category] and [attachment] fields. table1 contains user records. The goal is to select a category in a user record and then pressing a command button to attach the matching attachment from table2. I could not get an update query to do this as I got errors at first saying I cannot update a multifield and then trying just the attachement filedata i would recieve a window asking for input for the filedata. We would like to store files in a table to make updating attachments easier and prevent the uploading of the wrong attachment to the user record.

Im can understand VBA but have no idea where to start.

Any help would be greatly appreciated.

Go to the top of the page
post Oct 26 2019, 05:12 PM

UA Moderator
Posts: 77,703
Joined: 19-June 07
From: SunnySandyEggo

Hi Mario. See the code behind this demo and let me know if you have any questions.

Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
post Oct 27 2019, 07:46 AM

Posts: 7,115
Joined: 22-December 10
From: England

Multi value fields often have little idiosyncrasies.

Depending on how 'wedded' to them you are, it may be worthwhile re-designing the database.
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    28th March 2020 - 04:20 AM