Hiya

Do you know if it is possible to run a query in access, so that it displays information in a table, but can it output a hyperlink to a doucument server to open say Word, PDF files? i know you can save someones email address, click on it and it opens outlook, but can you do it to get documents from an area of the computer?

h:/folder/doc1.doc

Kind Regards


Joey Bird

Normally queries as not see by humans. Only forms and reports.

You could use the hyperlink data type to store the path. This would allow the link to be click-able on a form.

I do not use teh hyperlink data type in tables unless it is a website URL.. I find it has to many issues with anything else. I prefer to store the path as test.

Here is how I handle it: Document Links

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015