Search results for query: *

no, the URL is created by prefixing the tbl.[id] field. So, while I can change the datatype of the tbl.[id] to hyperlink, this doesn't automatically change the expression that uses tbl.[id] into a hyperlink datatype.

hi, I can see what this has done, but it hasn't made the whole expression Hyperlink data type. Just making the tbl.[ID] column hasn't then implicitly cast the rest of the expression as Hyperlink data type. Can you think of anything else?

hmm, so it could be as simple as a CAST()? IIf(tbl.[ID] Is NOT Null, CHTML('http://www.website.com/?id=' + tbl.[ID]) + '&s=somevalue', IIf (tbl.[ID] Is Null, 'No Link' ) ) I've made up CHTML as I don't know the exact function to do this, if possible. Does anyone know if...

hello, no, it's not for a HTML table, it's just a query, and one of the fields creates a web address from the data available. I'd just like for that address to be clickable and to actually work, both from Access query view, and should I copy and paste to Excel, or export as Excel. The rest of...

hello. it's a query, which I either copy and paste to a XLS spreadsheet, or I export to XLS. In both instances, I'm looking for a way to automatically make a field display as working HTML. The URL address is generated autonatically from the query, it just doesn't present itself as HTML. Is...

Hello I've got a query which creates a URL address by prepending and appending a value. Nothing shocking so far, but the field is returned as a text datatype. How would I go about making the value return as a working HTML URL? I guess I'm looking for a way for Access to recognise that if a...

Hi Harley Thanks, that bit of VBA worked a charm.

Hello I'm struggling to work out how to remove all non-alphanumerical characters from a given field(s). I can do one at a time, SELECT REPLACE(field, 'value to replace', 'what to replace with') FROM tbl But I need to do this for all non-alphanumerical characters, including spaces. Can anyone...