Tue 29 May 2007, 11:57Delegate James said...
James has attended:
Access VBA course
Microsoft Access, VBA
Hi,
After creating a recordset, I was wondering how to add a new field onto a recordset and also the table that it is linked back to?
Thanks,
James
Tue 29 May 2007, 19:10Trainer Roy said...
RE: Microsoft Access, VBA
Looks like you want the Fields.Append operation:
Fields.Append Name, Type, DefinedSize, Attrib, FieldValue
Find this in the Object Browser and read the Help page. Note that you have to append the field before you open the RecSet.
Sorry you found the course a bit slow, but I think it was OK for the other guys.
/Roy
