ADO Question

[Guest_imported]

Hi!!!

I have a ADO Control (I selected it from the ToolBox) in a form....

This ADO connects to another PC and It is working fine, but when the other PC is turned off an error message appears:

"ADOName: Couldn't find "Table" in location"

This is because the other PC is Turned off, but how can I do it to skip this error message because is a control in a form that it is not in code, and when I load this form this control is loaded and never find the root if the other pc is turned off and show me the error....

The situation is this: when the other PC is turned off I Use other local table, but the error message appears anyway, I put "Ok" to the error and I work fine....

But If I can disappear that error would be great!!!

Any help I will appreciate it!!!

MenyR

 

[MuraliKrishnaK]

Use a trap to catch the error. Something like...

On error goto errorhandling
...
...
errorhandling:
' write the code what to do when the error occurs


Murali Krishna

 

[stoolpigeon]

Just set up an error trap- catch the error and resume next if you can do so w/out any negative ramifications.

 

[Guest_imported]

The problem is .... where can I put "On error Resume Next", remember that is a control ADO it is not Declared in the code....

Thanks

MenyR