I am using Access 2010. The table (PCRR) contains a field with the datatype of "hyperlink."
Now, on the form that is based on the PCRR table, I need to allow the user to browse a particular directory and pull back the filename that they want and place the full pathname/filename in the hyperlink field.
How do I go about setting the default location of the hyperlink to a direct pathname (not using mapped drives and/or search drives).? Again, the user will click on the hyperlink field on the form and the "edit hyperlink" will open to the direct pathname/folders.
The final step is that the user will execule a report and export out to a pdf the report, which will contain the hyperlink in it. This pdf report can then be sent to other people for the information, plus be able to open the hyperlink to the selected file above.
Can anyone help me with how I go about doing this?
Thanks in advance for your help! I have been researching this all day.