Duane Hookom-Query By Form

[J]

I found this great app developed by Duane Hookom and incoroporated it into a
small app I developed for our family. Everything works great except that if
there is a Hyperlink field and you export the query results to Excel, the
file path is getting truncated or corrupted somehow and does not work. Is
anyone else using this application and have you run into/resolved the same
issue?

 

[Duane Hookom]

Thanks for the compliment. I never use hyperlink fields and so I had never
tested the qbf with them. What do you get if you attempt to push the results
to HTML, CSV, Word Table, or one of the other formats.

This could be an Excel limitation.

 

[J]

You're welcome. The problem exists regardless of what I export it to but it
doesn't appear to necessarily be related to your app. I also ran a query and
did a copy/paste into Excel and the hyperlink did not work. Then I used the
Office Links option and analyzed with Excel and the hyperlink works fine.
Someone also suggested that I define a Hyperlink base in Database Properties
but that didn't seem to have any effect. The hyperlinks work just fine from
within Access but when they're exported, who knows. Help!

 

[Howard]

Which great app? could you post a link?

I know Duane has loads of great stuff, but that the problem .I feel like a
kid in a candy shop - where do you start!
Howard

 

[Duane Hookom]

The Query By Form at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.