Hi,
I have a database form that captures information off a physical form using a simple vba program. The physical form, once signed off, needs to be scanned and saved to a network folder. When the clerk is capturing the form in VBA, I would like them to be able to add a link to the copy of the physical file saved in pdf on a network folder.
Currently, the form opens and dates are captured, people, departments etc, the last one would ideally say PDF copy. They would hopefully be able to navigate to the folder, select the file and then back to the form. When clicking save in the form, the date in column 1, the name column 2 etc, all captured from textbox controls. The last column, in my case, N, would hopefully be a hyperlink to the pdf file that was scanned before capturing the information off the physical form.
So where it says link to site, if they can paste the address of the file to hyperlink to, then excel hyperlinks it on the database sheet 2, or if they could browse to the file that would be better.
I am struggling to explain clearer.
Is it also possible to add a print button, that could print a blank pdf copy of the form in question? The form, a pdf version of the vba form, is saved in the same place that the excel document is. That would be ideal.
Thank you.
I have a database form that captures information off a physical form using a simple vba program. The physical form, once signed off, needs to be scanned and saved to a network folder. When the clerk is capturing the form in VBA, I would like them to be able to add a link to the copy of the physical file saved in pdf on a network folder.
Currently, the form opens and dates are captured, people, departments etc, the last one would ideally say PDF copy. They would hopefully be able to navigate to the folder, select the file and then back to the form. When clicking save in the form, the date in column 1, the name column 2 etc, all captured from textbox controls. The last column, in my case, N, would hopefully be a hyperlink to the pdf file that was scanned before capturing the information off the physical form.
So where it says link to site, if they can paste the address of the file to hyperlink to, then excel hyperlinks it on the database sheet 2, or if they could browse to the file that would be better.
I am struggling to explain clearer.
Is it also possible to add a print button, that could print a blank pdf copy of the form in question? The form, a pdf version of the vba form, is saved in the same place that the excel document is. That would be ideal.
Thank you.
