Field name in a table?

[easycode]

I need to pull a fieldname from a table, does anyone know how to do it?

i have a table called Subject:
-Subjectcode
-Description
-Type
-Notes
-Alertmess
-Date

i need to verify by code if this table has the field "Alertmes" because in previous versions instead of this field i have "Alertcode". Then How can i get the name of a field?

Thanks

 

[RoyVidar]

Brute force ...
[tt]dim fld as dao.field
on error resume next
set fld = currentdb.tabledefs("subject").fields("Alertmes")
if err.number <> 0 then ' err 3265 I think
' doesn't look like it's there
end if
on error goto <ordinary errorhandler>[/tt]

Roy-Vidar

 

[easycode]

i was thinking in something like that, i was hoping there was a command to do it automatically.

Thank you Roy

 

[RoyVidar]

Abrakadabra?

Roy-Vidar