problem in closing a error

[vivek.shankar]

hi
i have the folowing piece of code

Call SendMessage(GetWindow(FindWindow("#32770", "Manual Import"), GW_CHILD), BM_CLICK, 0, 0)

hello = FindWindow("#32770", "Microsoft Visual Basic")

the first line clicks on a button
the control goes to next page and all details from clipboeard are copied to this page
after this a error pops up.....hope can i close that error box.........2nd line is for closing the error box.........but i dont know how to call it after the pasting process is completed

thanks and regards
vivek.s

[dglienna]

couldn't you just use an ON ERROR routine? I don't know where the error is occurring, or what it is.

[vivek.shankar]

hi,
i dont have to resolve the error.........cause i am automating the application using vb code..........and i ahve to close errors wherevre they popup.......well my situation is like this.....

1) i click on the submit button
2) in the next page whetever is iin the clipboard gets pasted automatically
3)now a error message box arises
4)now i have to close the error b message box.
5)but problem is i ahve to wait till the pasting operation completes......

how can i achieve this?

thanks and regards
vivek.s

[vivek.shankar]

hi
like IE_BUSY ..... is tehre any way to wait till pasting operation is complete?

thanks

regards
vivek.s

[vivek.shankar]

HI GURU!!!
is there any way which i cud make use of?

thanks and regards
vivek.s

[nareth]

While Not hello
hello = FindWindow("#32770", "Microsoft Visual Basic")
Wend

[vivek.shankar]

this will go into infinite loop..........cause the error message box appears after pasting the contents from clipboard........and pasting will not occur and application will hang......
any other way out?
thanks and regards
vivek.s

[nareth]

not true, when it finds the Window handle the loop is terminated

but what do you want to do anyway

[vivek.shankar]

i tried it before......

this is what i want to do

1) i click on the submit button
2) in the next page whetever is iin the clipboard gets pasted automatically
3)now a error message box arises
4)now i have to close the error b message box.
5)but problem is i ahve to wait till the pasting operation completes......


u want me to put this loop between step 1 and step2

so it hangs up..........i wud like a way to put it between step 2 and step3.........for that we have to know when the pasting operation gets completed.........any options?

thanks and regards
vivek.s

[nareth]

page? what page? please atach your project or something because i dont get the point

[vivek.shankar]

hi,
well i have attached the screen shot of the form........the error box appears on top..........behind that is the pasted text.........now the error box appears after the text is pasted.........so i have to suppress the error box after the pasting operation gets completed.........

thanks and regards
vivek.s

[nareth]

you forgot the attachment

[vivek.shankar]

hi
i am not able to attatch the file........it goes to cannot find server page........how can i do it?

thansk and regards
vivek.s

[vivek.shankar]

regards
vivek.s

[nareth]

when posting a post under reply; under options; you see Atach file,

zip up your project files first and then just attach the zip file

[vivek.shankar]

hi
i have jus attached snap shot of screen that i see.....

thanks and regards
vivek.s

[nareth]

how are you pasting? and from what is that error box? maybe you can prevent it from showing up?

[vivek.shankar]

what i am actually doing is .........automating a msaccess application using vb code.......so i am not supposed to touch the msaccess code.........i have to just close any error box that arises......i clicked a button in another form ..........and it opens up this form and copies all the data from clipboard.........and this error message arises after that.......(the error message is due absence of some table i guess......but i am not supposed to do anything with that access application).........now aim is to close that error box.......

thanks and regards
vivek.s

[nareth]

use spy++ to get the class of the error box then use FindWindow API to get the Window Handle(use the loop i gave) then after the loop send a message to the error box using the Window Handle with SendMessage API the message to send is WM_CLOSE

this mgiht help you

[vivek.shankar]

that was exactly what i did

Call SendMessage(GetWindow(FindWindow("#32770", "Manual Import"), GW_CHILD), BM_CLICK, 0, 0)

while hello=0
hello= FindWindow("#32770", "Microsoft Visual Basic")
wend



but what happens is

Call SendMessage(GetWindow(FindWindow("#32770", "Manual Import"), GW_CHILD), BM_CLICK, 0, 0)

while hello=0
hello= FindWindow("#32770", "Microsoft Visual Basic")
wend

pasting happens here

window appears here


so the loop is making pasting operation wait infinitely.........so i need a way to find when pasting completes.......jus like IE_BUSY for browser


thanks and regards
s.vivek

[nareth]

err.... i have no idea what you are doing.... you might want take a look at MSAccess object for VB6

[vivek.shankar]

sorry........i wud explain more clearly

this is the button the first form which i am clicking.
Call SendMessage(GetWindow(FindWindow("#32770", "Manual Import"), GW_CHILD), BM_CLICK, 0, 0)

now the control is transferred to next form.
here all the data from clipboard is copied.
after this a error message box arises.

now for closing this u wanted me to include the following

while hello=0
hello= FindWindow("#32770", "Microsoft Visual Basic")
wend


My question is:

how wud i find when the pasting operation gets completed to use this code

while hello=0
hello= FindWindow("#32770", "Microsoft Visual Basic")
wend


because if i use this before the text is pasted then the pasting operation would wait infinitely.this is beacuse the error message appears only after pasting operation gets completed.

thanks and regards
vivek.s

[nareth]

whenever the paste operation is completed it would show the error so the loop gets terminated, there it is the solution

[vivek.shankar]

but in this case paste operation does not start till the loop gets completed.so is there anyway to find the completion of paste operation.

thanks and regards
vivek.s

[nareth]

i cant do anything with tis much code

[vivek.shankar]

thsi is the only code in that page...........anyway thanks a lot!!

Regards
vivek.s

[RobDog888]

vivek, I couldnt view your screen shot, but what are you pasting
into? Grid, tabel, or ??? Maybe if you already know the number of
rows you are pasting then perhaps you could make some knind
of check against the table to see when those number of rows are
completely added?

[vivek.shankar]

hi guru,
yes they r pasting into a table and each line pasted is a record......how can determine the no. of recored from data in clipboard.and even if i do how can follow the no.of recored copied?

thanks a lot!

regards
vivek.s

[RobDog888]

Well it would depend on how you are getting the data to the clipboard.
To check in the access table, get the recordcount before and then
keep checking until the recordcount mathces your variable that
would how the rc.

HTH

[vivek.shankar]

Thanks a lot!u have given me a cool solotion!i wud implement it!

thanks a lot!!

regards
vivek.s

[RobDog888]

No prob. Glad to help