Martin Reid
mwp.reid at qub.ac.uk
Fri Sep 22 12:19:04 CDT 2006
I believe someone on the list created an error generator. I believe it might be JC? Anyway I have been using it a lot for code examples and just to be politically correct want the owner to know. Example below
Function CopytoWss()
On Error GoTo Err_CopytoWss
DoCmd.SelectObject acTable, "Contacts"
DoCmd.RunCommand acCmdExportSharePointList
Exit_CopytoWss:
Exit Function
Err_CopytoWss:
MsgBox Err.Description, , "Error in Function CopytoWss"
Resume Exit_CopytoWss
Resume 0 '.FOR TROUBLESHOOTING
End Function
Martin
Martin WP Reid
Training and Assessment Unit
Riddle Hall
Belfast
tel: 02890 974477