UtterAccess.com
Thank you for your support!      
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Reading HTML from Access in Access    
 
   
ghubbell
post Sep 17 2004, 08:56 AM
Post #1

UA Administrator
Posts: 3,243
From: Rigaud, Quebec, Canada
A Q!
I've been searching for a couple of days for this - can't find a thing. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/crazy.gif)

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!" (IMG:http://www.utteraccess.com/forum/style_emoticons/default/ohyeah.gif)
Go to the top of the page
 
+
danishani
post Sep 17 2004, 09:12 AM
Post #2

UtterAccess VIP
Posts: 4,150
From: Washington, USA
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.
Go to the top of the page
 
+
ghubbell
post Sep 17 2004, 09:17 AM
Post #3

UA Administrator
Posts: 3,243
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!
Go to the top of the page
 
+
danishani
post Sep 17 2004, 09:28 AM
Post #4

UtterAccess VIP
Posts: 4,150
From: Washington, USA
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
Go to the top of the page
 
+
danishani
post Sep 17 2004, 12:39 PM
Post #5

UtterAccess VIP
Posts: 4,150
From: Washington, USA
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
Go to the top of the page
 
+
ghubbell
post Sep 17 2004, 03:12 PM
Post #6

UA Administrator
Posts: 3,243
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!
Go to the top of the page
 
+
danishani
post Sep 21 2004, 09:24 AM
Post #7

UtterAccess VIP
Posts: 4,150
From: Washington, USA
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
Go to the top of the page
 
+
ghubbell
post Sep 21 2004, 09:48 AM
Post #8

UA Administrator
Posts: 3,243
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! (IMG:http://www.utteraccess.com/forum/style_emoticons/default/acclaim.gif)

Thanks again Daniel,

Gord o!
Go to the top of the page
 
+
danishani
post Sep 21 2004, 11:39 AM
Post #9

UtterAccess VIP
Posts: 4,150
From: Washington, USA
Glad to help u Gord (IMG:http://www.utteraccess.com/forum/style_emoticons/default/frown.gif)

Daniel
Go to the top of the page
 
+
nikh
post 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.
Go to the top of the page
 
+
danishani
post Oct 19 2004, 04:04 AM
Post #11

UtterAccess VIP
Posts: 4,150
From: Washington, USA
Welcome to Utter Access Forums!!! (IMG:http://www.utteraccess.com/forum/style_emoticons/default/frown.gif)

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... (IMG:http://www.utteraccess.com/forum/style_emoticons/default/wink.gif)

Cheers,

Daniel
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Reply to this topicStart new topic

 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 4th February 2012 - 11:21 PM