CTRL + F

[a]

Hi All
I post this question to many forumus
How can i search open web site by code from access 2003
Example
If you have a web site like www.Yahoo.com
I have access2003 form and command button and 2 string
What I want:
When pressing the access 2003 command button
The code search on the open web site (yahoo.com)
And if find the value assign 1 to a variable SearchResult

Command_1_click
Dim StringSearchTheWeb
StringSearchTheWeb = "value you want search here"
' if the code find the value of StringSearchTheWeb assign 1 to the variable
Dim SearchResult As Integer

' web site is already open
'
Here your code to search the open web site
After finish searching and find exact result assign 1 to variable
SearchResult
Notes:
I don't want use find dialog box appear I want working in a hidden mode
Thank you for all your help
I search the web msdn all forums i don't reach any answer until know

 

[Stefan Hoffmann]

hi,

I post this question to many forumus
How can i search open web site by code from access 2003

Define "open web site".


mfG
--> stefan <--

 

[a]

hi

what do you mean Define "open web site"

i think you mean (www.yahoo.com) open web site (you can see the web page on
your computer) navigate the web site as usual

the operation should be like this:

access 2003 form is open

www.yahoo.com is open

beside each other (minimized - maximized) any

i will not use object browser control for many reason

so you have the url (www.yahoo.com) and opened updated last edited

and open form (access 2003)

so

the command_button

go to www.yahoo.com

search

find

assign value

end sub

 

[Stefan Hoffmann]

hi,

what do you mean Define "open web site"

A "web site" is just plain data. You can display (render) it in many
ways and with many programs.

E.g. if it is opened in Word, you can use Word Automation to search in it.

So, inspect the program rendering the web site, if it is capable of
automation.


mfG
--> stefan <--

 

[a]

Your solution is so far what I want

(www.yahoo.com) is a example of the url or web site

The web site will change every 5 or 10 second depend on the input

Again (yahoo) is example

I will give you another example:

If you automate the process of searching in (yahoo)

You will send value to yahoo web site by code from access



You have command button in access

You press the command button

The search result will appear

Every time you enter the value in access 2003 and press search the yahoo
will display the result



Again

I want every time press search from access form yahoo display the result of
searching



Here is what I want

The Code I want use : use (((((((find)))))) only CTLR + F on the web site
yahoo web site

On the first page only ok

If find any word assign 1 to the variable

Have a good day