Search results

Hello. Have a quick question that I can't seem to figure out...looking for some help. What I have: I have a table called [Tasks] which has the following relevant fields: [Task ID] [Location] I have a form that people use to create new tasks and update current ones. Location on the form is a...

Thanks. I'm just having a bit of difficulty. What would the query look like then?

Hello. I have a table called [Attachments Table], which has the fields: AttachNbr as autonumber Task ID as number FileN as hyperlink URLText as long text I want to copy the URL of the hyperlinks stored in the FileN fields to the URLText fields. However, when I run an update query I am...

Thanks Chuck for the reply. One more question - if I have multiple attachments in one Attachment field (i.e [Scan] field), what would the Append query have to be in order to export the filenames of all the attachments? For example, right now if Task 3 has Task3.txt and Task3-2.txt, only...

Hello Chuck. Thanks for posting this. I'm having some issues implementing this code however. I've followed your procedure so far and have my On Click to RunCode. as SaveAttachmentsTest("C:\Attachments") and I'm getting errors about invalid number of arguments. Then, I tried...