 |
Reading HTML from Access in Access Version: 2003 (11.0)
Posted on 09/17/04 09:56 AM
Posted by ghubbell - UA Administrator
Posts: 1941 - Loc: Rigaud, Quebec, Canada
Forum: Access Forms
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
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!" 
|
 |
● Re: Reading HTML from Access in Access Version: 2003 (11.0) [Re: ghubbell]
Posted on 09/17/04 10:12 AM
Posted by danishani - Utter Access VIP
Posts: 3575 - Loc: The Netherlands (Holland)
Forum: Access Forms
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
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
|
|
● Re: Reading HTML from Access in Access Version: 2003 (11.0) [Re: danishani]
Posted on 09/17/04 10:17 AM
Posted by ghubbell - UA Administrator
Posts: 1941 - Loc: Rigaud, Quebec, Canada
Forum: Access Forms
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
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 
|
|
● Re: Reading HTML from Access in Access Version: 2003 (11.0) [Re: danishani]
Posted on 09/17/04 10:28 AM
Posted by danishani - Utter Access VIP
Posts: 3575 - Loc: The Netherlands (Holland)
Forum: Access Forms
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
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
|
|
● Re: Reading HTML from Access in Access Version: 2003 (11.0) [Re: ghubbell]
Posted on 09/17/04 01:39 PM
Posted by danishani - Utter Access VIP
Posts: 3575 - Loc: The Netherlands (Holland)
Forum: Access Forms
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
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
|
|
● Re: Reading HTML from Access in Access Version: 2003 (11.0) [Re: danishani]
Posted on 09/17/04 04:12 PM
Posted by ghubbell - UA Administrator
Posts: 1941 - Loc: Rigaud, Quebec, Canada
Forum: Access Forms
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
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
|
|
● Re: Reading HTML from Access in Access Version: 2003 (11.0) [Re: ghubbell]
Posted on 09/21/04 10:24 AM
Posted by danishani - Utter Access VIP
Posts: 3575 - Loc: The Netherlands (Holland)
Forum: Access Forms
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
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
|
|
● Re: Reading HTML from Access in Access Version: 2003 (11.0) [Re: danishani]
Posted on 09/21/04 10:48 AM
Posted by ghubbell - UA Administrator
Posts: 1941 - Loc: Rigaud, Quebec, Canada
Forum: Access Forms
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
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
|
|
Re: Reading HTML from Access in Access Version: 2003 (11.0) [Re: danishani]
Posted on 09/21/04 12:39 PM
Posted by danishani - Utter Access VIP
Posts: 3575 - Loc: The Netherlands (Holland)
Forum: Access Forms
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
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
|
 |
● Re: Reading HTML from Access in Access Version: 2003 (11.0) [Re: danishani]
Posted on 10/19/04 04:44 AM
Posted by nikh - New Member
Posts: 1 -
Forum: Access Forms
|
• Edit
• Reply
• Quote
• Quick Reply
• Print this post
• Bookmark Post
• Notify Moderator
• Top of page
|
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.
|
|
|
 |
| Navigate |
|
|
|
