Can Access view HTML code from IE?

[ColeChaW]

I'm playing around with the idea of reading values we enter into a web page form and inserting them into my little Access program to save us from typing data that's already entered.

I cannot link to the tables the web form uses directly because our IS dept. will not allow it. I do think that if I can get the source code imported from the open web browser, I can use the Instr() function to find what I need.

Is it possible to make a request to IE from Access?

 

[Bat17]

if you are using a browser to view the documents then you can probably save the file locally and link to that!

Peter

 

[dsigner]

If the data is in tabular form then copy and paste will work into Excel. An Excel table can be linked/imported to Access. This is a manual route which is quick and easy. Clearly it is not an answer if you want to rerun the process automatically but I think it worth playing with as it gives a good feel for the process.

 

[ColeChaW]

Thank you, I'm going to set up and try both of these to see how they work out. I'm trying to set this up to be a recurring, automatic request as the information on the open web browser is changing by the minute.

If this won't work out, I will put in a request to link to the SQL table (if IS will change thier mind and let me). Otherwise, we currently enter the data by hand without too much fuss.

Thanks for these ideas, I'll try them out and let you know if I find anything.

 

[MarkK]

Here's a fast and dirty sample db that displays HTML in a text box for a given URL.

 

[ColeChaW]

You guys are great. I'm learning all kinds of new stuff now that you have pointed me in the right direction. Shouldn't be too long before I have this all figured out.

 

[ColeChaW]

I created a form with an Active X web browser control on it and have navigated to the required web site. Now that it's all within Access, is the HTML source code at my fingers or am I barking up the wrong tree?

 

[MarkK]

Have you looked at the db I posted? The answer's in there.

 

[ColeChaW]

Sorry, not yet. I'm at work now and we're running Access 2000. I have 07 at home and will check out your DB tonight.

However, I am now referring to the input boxes on the web site and can read and write info to them. Of course, the real important data is in an HTML table, not an input box, so I still need to get the code into a string so I can parse it.

Thanks for taking the time to help me do this, it's really making a difference in my programming. So far I've cut our End of Mission to Paperwork time from 20 minutes to 5 minutes. If I can import all the data I can cut it again to 2 seconds and eliminate typing mistakes.

You guys are awesome.

 

[ColeChaW]

Thank you again.

This is what I have settled on using, and for now it seems to work well:

strHTML = Me.Browser1.Document.documentElement.innerHTML

Of course this only works with a website that is displayed in a browser control on one of my forms, but that is entirely workable.

Thanks for the DB lagbolt, there's a lot of really good code in there that'll I'll be using in my next update.

 

[MarkK]

Yes. Your solution is much simpler!