About MS RemoteData Control 2.0

[Yong-Hyun Jin]

Hello, Codeguru.


My name is Young-hyun Jin.

I am studing Microsoft RemoteData Control version 2.0 but I meet the problem.


First of all, please see the belows.


Microsoft RemoteData Control 2.0

myRdc : MSRDC type


In the Visual Basic Code ;


on Error goto error_handle


........


myRdc.Connect = "DSN=...;UID=....;PWD=...;"

myRdc.SQL = "select ... from ...."

myRdc.Refresh


........


error_handle:

MsgBox Err.Number & ":" & Err.Description

........


When errors occur using a wrong SQL, MSRDC shows an error message.

And, as you see, you recognize that an error message is showed again because I set the code "on Error goto error_handle"

(As you may know, in this case, the error message is executed in twice)


But I wanna try to display only one message.


I need your assistance.

Your kind reply will be appreciated.


Thank you in advance and

best regards,

Young-hyun Jin.