HyperLinkPart fails in Access Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Data Access Page that uses a Query. The Query contains the function
HyperLinkPart. When I run inside of Access, the DAP works great. When I
save to an HTML and run from IE 6.0, I get "Undefined Function HyperLinkPart
in expression"
If I remove the HyperLinkPart function from the Query, then the HTML page
loads and works, but, I don't have the hyperlink that I need.

Anyone out there seen this?

Thanks!
 
HyperlinkPart is actually a method of the Access application object and
therefore isn't available when you're running a query from outside
Access.

You can probably replace it with an expression that uses the string
handling functions offered by the database engine you're using. If it's
a Jet - mdb - database, this pretty much means the standard VBA string
functions such as Instr() and Mid().
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hyperlinkpart and dlookup problem 7
Convert Query field display from text to hyperlink 3
Access #Error & Excel Pivot 0
Use In() Expression as Query criteria with guts from Function 1
combining a hyperlink and table data to form complete link HELP!!! 1
Parameter Query Won't Run 0
Format() function in Access 2003 4
undefined function 'chr' in expresssion 2

Back
Top