Can search results from an ASP be called from Access....

[crpjaviman]

Hi everyone,

Is there a way of bringing up or sending a command line from Access to a website for results from a table.

Let me explain a little more:
I can bring up the website from Access with the Shell command. At this website, the criteria needs to be entered and then submitted.

I want to be able to send the server the command to bring up the results without having to go through this previous website.

Thanks,
crpjaviman

 

[Guest_imported]

umm... maybe this will help... lets say I wanted to search google.com for a specific piece of info... say I searched google for ford trucks... once the results are displayed I copy the address from the web browser (google brought me back this-->

[URL unfurl="true"]http://www.google.com/search?hl=en&lr=&ie=UTF-8&oe=UTF-8&q=ford+trucks[/URL]

)and I use it in my code... example:

for this url my search string is at the last of the addy... and the spaces are replaced by the + symbol which is not really important for this example) so I could in code search for anything I want... example...

Dim strSearch As String
Dim strURL As String
strSearch = "Ford trucks"
strURL = "[URL unfurl="true"]http://www.google.com/search?hl=en&lr=&ie=UTF-8&oe=UTF-8&q="[/URL] & strSearch
Shell ("C:\Program Files\Internet Explorer\iexplore.exe " & strURL)

FYI: Internet Explorer will replace those spaces for me so this code actually works....also Internet Explorer can take a file argument like many other programs... so

Shell("c:\pathtoexplorer\iexplorer.exe [URL unfurl="true"]http://www.yahoo.com")[/URL]

will open internet explorer and bring up yahoo