Hi,
I have tables that include calculated fields, which calculate from values of other fields. For example, a FullName field will take the value of first, last and middle names such as:
Code:
FirstName & IIf(IsNull(MiddleInit),""," " & MiddleInit) & IIf(IsNull(LastName),""," " & LastName)
Now I want to take records from my "Changes" table and populate them into my "Real" table. Most fields will be in both tables. So I open a recordset of the "Changes" table and a recordset of the "Real" table. I loop through the "Changes" recordset and for each record I do an AddNew in the "Real" recordset, then loop through the Fields collection in the "Changes" recordset. If the Field is also present in the "Real" recordset, I assign the value from the "Changes" field to the "Real" field.
So here is the actual question: I want to ignore calculated fields during this process because, well, they're calculated. I've done a bunch of research to find out how to identify a calculated field in VBA, but can't find anything. I've tried the Attributes and Properties items to no avail. It's so easy to see this in the table designer, but I can't figure out how to see this information using VBA.
Any ideas? Thanks...