[AccessD] Cheecking field exists

A.D.TEJPAL adtp at hotmail.com
Thu May 18 12:38:27 CDT 2006


Maritn,

    Function Fn_FieldExists() as given below, would return True if field exists, otherwise False.

Best wishes,
A.D.Tejpal
---------------

====================================
Function Fn_FieldExists(ByVal FieldName As String, _
                      ByVal TableName As String) As Boolean
    On Error Resume Next
    Fn_FieldExists = Not IsError(DLookup(FieldName, TableName))
End Function
====================================

  ----- Original Message ----- 
  From: Martin Reid 
  To: Access Developers discussion and problem solving 
  Sent: Thursday, May 18, 2006 20:43
  Subject: [AccessD] Cheecking field exists


  Is there an easy way to check if a field exists in a particular table vai vba?
   
  Maritn
   
  Martin WP Reid
  Training and Assessment Unit
  Riddle Hall
  Belfast
   
  tel: 02890 974477


More information about the AccessD mailing list