Recent content by Emmjay

Fixed! I have fixed this problem by rewriting the query without the UNION. Access 2000 does not seem to like that command :) In the end I used lots of nested ANDs and ORs, which work just as well. :D

Hi, I have a query that I build using VBA based on some user input. One of the fields I pull out is a hyperlink to particular files on our local network, so the user can click the link and open the relevant file. My problem is that if the SELECT statement contains one (or more) UNIONs the...

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...

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...

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...