Pedro Janssen
pedro at plex.nl
Sun Jun 12 16:50:37 CDT 2005
Hello Group, i am using a function that Neil Kling provided me in the past. When running it from an expression i get an error: Invalid number of arguments. Who can help me with this Pedro Janssen Function DeleteTableLink(strTableName As String) As Boolean On Error GoTo Err_DeleteTableLink Dim db As Database strTableName = "tblDebiteurAlgemeen" Set db = DBEngine(0)(0) db.TableDefs.Delete strTableName db.TableDefs.Refresh DeleteTableLink = True Exit_DeleteTableLink: Exit Function Err_DeleteTableLink: Select Case Err Case 0 'insert Errors you wish to ignore here Resume Next Case 3265 'Item doesn't exist in collection Resume Next Case Else 'All other errors will trap Beep MsgBox Err.Number & "; " & Err.Description, , "Error in function basObjectHandlers.DeleteTableLink" Resume Exit_DeleteTableLink End Select Resume 0 'FOR TROUBLESHOOTING End Function