Sample call: test = FieldExist(CurrentDb.Name, "EmployeeTable", "EmployeeNbr") '------------------------------------------------------------------------- ' FieldExists: Determine if a field exists in an Access table '------------------------------------------------------------------------- Public Function FieldExists(DatabaseName As String, _ TableName As String, FieldName As String) As Boolean 'DataBaseName is the file/path name of the database 'with the field you want to test 'tablename is the table, fieldname is the field 'if database or table does not exist, an error is raised Dim oDB As Database Dim td As TableDef Dim f As Field On Error GoTo ErrorHandler Set oDB = Workspaces(0).OpenDatabase(DatabaseName) Set td = oDB.TableDefs(TableName) On Error Resume Next Set f = td.Fields(FieldName) FieldExists = Err.Number = 0 oDB.Close Exit Function ErrorHandler: If Not oDB Is Nothing Then oDB.Close Err.Raise Err.Number Exit Function End Function '---------------- END FieldExits ---------------------------------------
Samples of VBA code I'm using in my daily tasks.
Friday, March 12, 2010
Does filed exist in Access table
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment