ChristineMD
Board Regular
- Joined
- Jul 29, 2008
- Messages
- 53
So I absolutely know this is a completely hinky way to accomplish what I need, but I'm wondering why the export to HTML doesn't just do this. I wanted to store urls to images from our website in a table, and have them display on a report - that just doesn't seem to be as easy as I think it should be.
So, I imbedded all my html tags in the query fields (i.e. all the table tags, and img srce tags to the links - and then force the export text function to save the file as html, which works, but is just such a cheat, in a way. And access still barks at me about the file extension it doesn't *really* want to save it with an html extension. But when I open up the file in a browser it looks just the way I want (almost), and I can print it, which is ultimately what the requestor wants. If I take this query with all the imbedded tags and export it as html, it ignores the img src tags!
I've searched high and low on the web for ways to include internet links to images on reports, and they just ain't easy! I saw some inferences out there that XML to HTML translation would do what I want, but would either require some tedious coding or another tool ($$)
So I guess here's the question: does anyone know if the XML translation tools generally do this? Can I take a plain old URL (not with imbedded img src tag, just http://blahblahblah.jpg and turn it into an image that will display? Anyone have a tool to reccommend? I'd prefer to to spend anything on this, while chances are I would have to do something like this again in the future, it really is kind of a one off kind of thing. Maybe my solution is the best for me. It honestly just seems very stupid!
Will Crystal Reports do this by any chance?
The only thing I want it to do that it doesn't with my hack, is put the data into a table that is two columns wide. I know I'd have to write something in VB, and I'm not a VB coder.
I'm on Access 2010 btw... which is just ridiculous... I saw questions and complaints about this on the web all the way back to Access 97. I guess I have to bite the bullet and learn VB
So, I imbedded all my html tags in the query fields (i.e. all the table tags, and img srce tags to the links - and then force the export text function to save the file as html, which works, but is just such a cheat, in a way. And access still barks at me about the file extension it doesn't *really* want to save it with an html extension. But when I open up the file in a browser it looks just the way I want (almost), and I can print it, which is ultimately what the requestor wants. If I take this query with all the imbedded tags and export it as html, it ignores the img src tags!
I've searched high and low on the web for ways to include internet links to images on reports, and they just ain't easy! I saw some inferences out there that XML to HTML translation would do what I want, but would either require some tedious coding or another tool ($$)
So I guess here's the question: does anyone know if the XML translation tools generally do this? Can I take a plain old URL (not with imbedded img src tag, just http://blahblahblah.jpg and turn it into an image that will display? Anyone have a tool to reccommend? I'd prefer to to spend anything on this, while chances are I would have to do something like this again in the future, it really is kind of a one off kind of thing. Maybe my solution is the best for me. It honestly just seems very stupid!
Will Crystal Reports do this by any chance?
The only thing I want it to do that it doesn't with my hack, is put the data into a table that is two columns wide. I know I'd have to write something in VB, and I'm not a VB coder.
I'm on Access 2010 btw... which is just ridiculous... I saw questions and complaints about this on the web all the way back to Access 97. I guess I have to bite the bullet and learn VB
