 Reading HTML from Access in Access |
|
Welcome Guest ( Log In | Register ) · View New Posts · View Unanswered Topics
  |
 Sep 17 2004, 08:56 AM
Post
#1
|
|
 UA Administrator Posts: 2,678 From: Rigaud, Quebec, Canada  |
A Q!
I've been searching for a couple of days for this - can't find a thing.  Imagine I'm storing entire webpages source HTML in a memo field in an Access Db. It's input through a nifty API call, so all that side is 100%. Now I want to see the results without moving the HTML 'string' out of Access: say, on an Access form via a control (Probably ActiveX). Although I could send the HTML string out (save it as a local file), then ask the native Web Browser control to read that file locally, I can't seem to find a way with it or any other for that matter, to read directly from tabled data. I really want to keep it all within Access for security reasons, so no loose files kicking about. Anyone heard or seen such a control? Anyone with VB and ActiveX authoring experience who'd like to 'whip one up' for me? Thanks in advance, Gord oh, p.s. "Please help!" 
|
 |
 
|
|
Sep 17 2004, 09:12 AM
Post
#2
|
|
|
UtterAccess VIP Posts: 3,575 From: The Netherlands (Holland) |
Hi Gord,
Try this out to export from an Access database to htm. Export a table or a stored query. CODE Dim sSQL As String Dim sFileType As String Dim sDestPath As String Dim sExt As String Dim sTableQuery As String sFileType = "HTML Export;" sExt = "htm" sDestPath = "C:\Temp\" sTableQuery = "tHTML" sSQL = "SELECT * INTO [" & sFileType & _ "DATABASE=" & sDestPath & "].[FileName" & _ sExt & "] " & "FROM [" & sTableQuery & "]" DB.Execute sSQL, dbFailOnError I hope this is useful to you. Daniel Edited by: danishani on 09.17.04. -------------------- "When u know something, then act as someone who knows, and when u don't know something, then act as someone who don't know, that is KNOWLEDGE!" - Confucius
|
|
|
|
|
Sep 17 2004, 09:17 AM
Post
#3
|
|
|
UA Administrator Posts: 2,678 From: Rigaud, Quebec, Canada |
Hi Daniel,
Dank U - ja, I have similar code, but the problem still exists: I really do not want to remove the HTML string from the table only to read it. It is almost essential that the HTML remains inside the Db, and is read from there. Gord o! |
|
|
|
|
Sep 17 2004, 09:28 AM
Post
#4
|
|
|
UtterAccess VIP Posts: 3,575 From: The Netherlands (Holland) |
Hi Gord,
Graag gedaan, after re-reading your question, I see what you want to achieve. Shall do some search... hope I find something for ya. Cheers, Daniel -------------------- "When u know something, then act as someone who knows, and when u don't know something, then act as someone who don't know, that is KNOWLEDGE!" - Confucius
|
|
|
|
|
Sep 17 2004, 12:39 PM
Post
#5
|
|
|
UtterAccess VIP Posts: 3,575 From: The Netherlands (Holland) |
Gord,
I hooked up something for ya, at least I do hope u are looking for something like this or simular... Take a look at this article. HTH Daniel -------------------- "When u know something, then act as someone who knows, and when u don't know something, then act as someone who don't know, that is KNOWLEDGE!" - Confucius
|
|
|
|
|
Sep 17 2004, 03:12 PM
Post
#6
|
|
|
UA Administrator Posts: 2,678 From: Rigaud, Quebec, Canada |
Thanks Daniel,
I'll look it over some more but I think all this one is doing is HTML'ing (converting to HTML) Access data by the external program, not just reading raw HTML code stored as a string in Access. I will however contact Herr Schmidt to ask if he knows, or if he can create a somewhat similar solution. Thanks again Daniel, Gord o! |
|
|
|
|
Sep 21 2004, 09:24 AM
Post
#7
|
|
|
UtterAccess VIP Posts: 3,575 From: The Netherlands (Holland) |
Gord,
Came accross a demo of Lebans, it seems to do what you are after, with some little adjustments. Hope its more like it... Daniel -------------------- "When u know something, then act as someone who knows, and when u don't know something, then act as someone who don't know, that is KNOWLEDGE!" - Confucius
|
|
|
|
|
Sep 21 2004, 09:48 AM
Post
#8
|
|
|
UA Administrator Posts: 2,678 From: Rigaud, Quebec, Canada |
Perfect Daniel - Dank U !
I'm only beginning to get a grip on the API calls and while I was heading this direction, Messrs. Lebans and Ashish have come through @ 100%. Special thanks to you for the excellent detective work!  Thanks again Daniel, Gord o! |
|
|
|
|
Sep 21 2004, 11:39 AM
Post
#9
|
|
|
UtterAccess VIP Posts: 3,575 From: The Netherlands (Holland) |
Glad to help u Gord
 Daniel -------------------- "When u know something, then act as someone who knows, and when u don't know something, then act as someone who don't know, that is KNOWLEDGE!" - Confucius
|
|
|
|
|
Oct 19 2004, 03:44 AM
Post
#10
|
|
|
New Member Posts: 1 |
Hi,
I've been following this thread with interest, and this is just what i am looking for too Thanks very much! Nik Edited by: nikh on Tue Oct 19 4:52:46 EDT 2004. |
|
|
|
|
Oct 19 2004, 04:04 AM
Post
#11
|
|
|
UtterAccess VIP Posts: 3,575 From: The Netherlands (Holland) |
Welcome to Utter Access Forums!!!
Glad to help you out as well, and great to have you as a member in here. Hope you like it as much as I do...  Cheers, Daniel -------------------- "When u know something, then act as someone who knows, and when u don't know something, then act as someone who don't know, that is KNOWLEDGE!" - Confucius
|
|
|
|
|
|
Lo-Fi Version | Time is now: 30th July 2010 - 11:15 AM |