Hyperlinks in FE Database and SQL Backend do not work HELP

[PB]

Hyperlinks work in access, but once it is converted to SQL backend hyperlinks
is not an option. There is no equivalent, does any one have a solution to
this, I really need to attach excel, word, PDF, emails to the database that
go along with the case files. Any help provided would be greatly
appreciated.

Thanks,
PB

 

[Arvin Meyer [MVP]]

Store the paths, and use the following code which works with the
ShellExecute api to open the files. Not only will it fix your problem, but
it will lower storage overhead and possible corruption:

http://www.mvps.org/access/api/api0018.htm

 

[PB]

Arvin,

Thanks for the info; I just have a few more questions do I write this code
behind the text box in say after update? Not sure where to put it. Also the
form I am using is continuous is that a problem? Thanks again for your help
it is appreciated.

Pb