Doug Murphy
doug at murphyscreativity.com
Tue May 27 11:00:12 CDT 2003
Jim, Thank you. That makes sense. Is there a property of a hyperlink that indicates which type it is? I guess I could develop a routine using the dir function to check paths but it would be better to use a built in property. Doug -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence (AccessD) Sent: Monday, May 26, 2003 5:51 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] HyperLinks Hi Doug: There are kind of links, the relative or virtual link, that is the kind you have in your database and absolute links. A relative link only works from a known position, in this case your DB is in a known position (it knows where it is in the relative scheme of things.) When you select a hyper-link within the database it checks it and then prefixes the hyper-link with it's location to create the full link. HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Doug Murphy Sent: Monday, May 26, 2003 6:02 PM To: accessd at databaseadvisors.com Subject: [AccessD] HyperLinks Hello List, I have a question on the use of hyperlinks to point to files. I have a database that exists in a directory; C:\My Files\DBdirectory for example. In this directory there is a subdirectory holding files. The database has a table with a hyperlink field in it that contains the relative path to a file in the subdirectory. In other words the path to a file might be subdirectory\filename. It is my understanding that the hyperlink should contain the full path to a file such as C:\My Files\DBdirectory\subdirectory\File name. The interesting thing is if I double click on the hyperlink the file will open even though the hyperlink holds only the path relative to the database. Is this the way it is supposed to work or is this a feature of hyperlinks in being able to resolve relative paths? The reason I ask is that I am trying to extract the path to the file from the hyperlink and do a file copy. This doesn't work with the relative path as you would expect. If there is more info in the hyperlink than I am extracting that would give the full path how do I get to it? Thanks. Doug _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com