Check field availability

[Guest]

From an Access, I would like to check for a field's availability in a
specific table. How should I go about it?

 

[John Vinson]

From an Access, I would like to check for a field's availability in a
specific table. How should I go about it?

What's the context?

You could use the Table's Fields collection and trap the error if the
field doesn't exist:

Dim tdf As DAO.Tabledef
Dim db As DAO.Database
Dim fld As Field
On Error GoTo Proc_Error
Set db = CurrentDb
Set tdf = db.Tabledefs("MyTableName")
Set fld = tdf.Fields("TheFieldIWant")
If fld Is Nothing Then
<handle the error>
Else
<do something with it>
End If

John W. Vinson[MVP]