Hyperlink missing in VBA-made SQL query

[Emmjay]

Hi,
I have a table in a database where one field is a hyperlink to files on local network. I am using VBA to custom a SQL query based on some input from the user and return this field along with others from the table.

My problem is that in the query table returned the hyperlink field no longer works - it is no longer blue and underlined and you can't click on it to follow the link and open the file. However, if I make a basic query from the same table using the Access query builder, the hyperlinks work fine.

The SQL created by my VBA code is of the general form:

SELECT DocRef, DocTitle, DocAbstract, DocLink, DocAuthor, DocDate
FROM TechDocs
WHERE DocType IN ('ResRep', 'Misc') AND (DocAbstract LIKE '*Cure*');

where DocLink is the field that is the hyperlink, and "Cure" is the search term entered by the user.

This has been bugging me for a while but I just can't seem to work out why this is ... Any help is greatly appreciated!

 

[reclusivemonkey]

I believe the "wildcard" character you need to use in SQL is "%" not "*"...

http://www.w3schools.com/sql/sql_where.asp

 

[Emmjay]

As this is in Access 2000 the wildcard character is '*', I'm not sure when that was changed but '%' doesnt work for me. That aside, my problem is not selecting records, but that the hyperlink is missing from the result. The field is there but I can't click on it. Is there something in my SELECT statement that I need to change??

 

[Emmjay]

As this is in Access 2000 the wildcard character is '*', I'm not sure when that was changed but '%' doesnt work for me. That aside, my problem is not selecting records, but that the hyperlink is missing from the result. The field is there but I can't click on it. Is there something in my SELECT statement that I need to change??