I'm struggling with outputting a result field in a MS Access 2003 query. Need to output the field as a hyperlink. I've properly constructed the destination URL and the hyperlink target, but cannot get MSA2003's query for format the field properly.
Can a field result in a Query be formatted as a hyperlink?
Hot Topic
- MS Office document and image writer print driver
- what about rss
- MS Office document and image writer print driver
- Security of source code in vba
- Optimise VBA for Multi-Processors
- MS Access, how to mazimize a form's window size?
- MS Office document and image writer print driver
- Certification of web based applications
- SQL Server 2005 Resourse Kit exception
- Form Requery
Microsoft ISV
- How do I do to work with two XML files in VBA
- Losing primary display on Windows 2003 SE w/ single Radeon display
- saving exel data
- What version of Team System do EmpowerISV members get?
- Compiling a VBA project is increasing its size
- help on list box (Access)
- close excel when finish
- Acces1 1.0 converted to Acces 2003 but the old medical program does not run.
- Can no longer enter wscript for debug
- Detecting which version of MS Office is installed (for templates)?
Can a field result in a Query be formatted as a hyperlink?
Kevin Lew
Hi,
I don't think what your looking for can be done without changing the data type of the field to hyperlink in the table. You can do simple data type conversions from Integers to Strings in queries using CInt, CStr, etc, but there's no CUrl.
You could try displaying the field on a form in such a way that it acts like a hyperlink.
Hope that helps
Bosse A
Per the support engineer:
For this case, I think Derek has already pointed the perhaps key reason of the problem encountered.
Please let us know if you were able to solve the problem.
-brenda (ISV Buddy Team)