Check to see if Table Field Exists in VBA

[rittiger15]

I have a database that imports data from previous versions of the same database. The problem I run into is that one of the fields changed names since the first version.

Version 1
field name = FIELDA

Version 2
field name = FIELDB

I need the database to look at the table and determine which version it is importing data from so that it knows which query to run. I was hoping for something like:

If Table1.FIELDA exists then
query1
else
query2
end if

Is this possible?? I can't find a way to reference table fields in VBA.

I am open to any suggestions, whether I need to change my SQL or code or both.

Thanks in advance,
Chris

 

[SkipVought]

Hi,

The Recordset object has a Fields collection.



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com