Interact with webpage

[Guest]

Is there a way to interact with a webpage? In my db I house a field which I
need to pass to a control on a webpage and activate the search. Can this be
done?

The webpage in question is http://www.mls.ca and my db will populate the mls
number.

Thank you for your advice,

Daniel P

 

[Alex Dybenko]

Hi,
Looks like that you can just run your page as:

http://www.mls.ca/Disclaimer.aspx?Mode=5&id=123

where 123 is a mls number, to active search. You can use shellexecute API to
open browser, can be found at www.mvps.org/access

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Douglas J. Steele]

In addition to Alex's suggestion, see whether my April, 2006 "Access
Answers" column in Pinnacle Publication's "Smart Access" is applicable to
what you're trying to do. You can download the column (and sample database)
for free at http://www.accessmvp.com/DJSteele/SmartAccess.html

 

[Guest]

Alex,

sadly, and don't ask me why, the id does not correspond to the mls number.
For instance, if you do an mls search for mls#1323821 the id used in the url
is 5752310??? i have found no correlation between the two, this is why I am
trying to figure out how to manipulate/interact with the webpage (simulate
entering the number into the control and clicking the search button. if you
have any other ideas, I would greatly appreciate them!

Thank you for your help,

Daniel P

 

[Guest]

Douglas,

I will read your article. Thank you for the link.

Daniel P

 

[Guest]

Douglas,

Any chance you could illustrate how I could pass a string to a specific
control. For instance on the www.mls.ca website I wish to populate the
control named '_ctl0_txtMlsNumber' and then activate the button right next to
it '_ctl0_btnMLSSearch'

Thank you

Daniel P

 

[Douglas J. Steele]

Sorry, I think you're going to have to contact them and find out what the
algorithm is to translate from MLS number to whatever they show in the URL
after you click on the button.

 

[Alex Dybenko]

Hi Daniel,
strange, but I entered 123 as mls and got same in url. Anyway - as Doug
suggested - best way - to contact site developers

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com