I want to determine if a field exists in a table. Thus far I have figured out I need the following code:
Dim DB As DAO.Database
Dim TD As DAO.TableDef
Set DB = CurrentDb
Set TD = DB.TableDefs("tbl_parameter")
What I want to do is find out if the field 'Comments' exists in the tbl_parameter table. If it does I will then copy the contents to a new field in a new table.
Where do I go from here?