I use an access database (2016) that I developed to track products and submit product label pdfs to various government agencies. I use the database to review the products and develop a subset of products that I am going to submit. After reviewing, I wind up with a form which lists all of the products that need to be submitted. On that form is a field which is a hyperlink to the pdf file location, all it does is open the pdf. I am trying to automate the process to select the hyperlinked pdfs and place a copy of them in a separate folder (this folder location will not change) so that I can upload them to an ftp site.
I will be doing this for several hundred records/hyperlinked fields at a time, all coming from the one final form.
Help? I am not proficient at VBA, although I have successfully used it to develop my database based on examples from forums such as these.
I will be doing this for several hundred records/hyperlinked fields at a time, all coming from the one final form.
Help? I am not proficient at VBA, although I have successfully used it to develop my database based on examples from forums such as these.