Link pdf to database using a button to rename and hypelink

[Wysy]

Hi,
I have a database with records that have a corresponding pdf file in a directory. Each record one pdf file. I would like to have a form where there is a button to click and then after choosing the right pdf file, a hyperlink would be added to the record hyperlink field. Is there anyway? There is over 200 files and i do not want to enter the path informations one by one.
thanks
Andrrew

 

[arnelgp]

sorry, you mean you have an OLE field or attachment field in your table, is that it and you want it to replaced this with a Hyperlink field.

the simplest way is to create a form, based on your table and drag your hyperlink field in the form.
you can insert the pdf, by right clicking on the hyperlink field control on your form and selecting Hyperlink->edit hyperlink.

 

[Wysy]

No, i meant to be able to press a button to manage the path insert for the linked pdf. However i have found the accmdInsertHyperlink and it does exactly what i wanted.
Thanks for the help.
A