Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 23rd, 2011, 08:48 AM
Registered User
 
Join Date: Mar 2008
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Document access in MS Access 2003

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
 
Old August 23rd, 2011, 04:13 PM
Friend of Wrox
 
Join Date: Sep 2010
Posts: 245
Thanks: 5
Thanked 24 Times in 23 Posts
Default

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





Similar Threads
Thread Thread Starter Forum Replies Last Post
Database migration MS Access 2003 to MS SQL 2000 ayazhoda SQL Server 2000 3 April 23rd, 2007 11:38 AM
MS ACCESS 2003 FRONTEND AND MS SQL SERVER 2005 DB mohankumar0709 SQL Server 2005 3 March 23rd, 2007 12:48 AM
Ms Access 2003 and SQL 2005 micdev SQL Server 2005 1 March 22nd, 2007 02:50 PM
MS Access 2003 Wizards russ_w_h Access 2 January 20th, 2007 11:23 AM
JRUN4 Unix with MS Access 2003 zaman1111 JSP Basics 0 February 10th, 2005 05:09 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.