Hi everybody,
How can I add a fields in table by using Recordset.
I try to use:
--------------------
Dim db As DAO.Database
Dim rst As Recordset
Set db = CurrentDb
Set rst = db.OpenRecordset("Table1"
rst.Fields ????? Append dont work
So what is the object how must used in this case, to permet me to add new field like (string or integer)
cordially
How can I add a fields in table by using Recordset.
I try to use:
--------------------
Dim db As DAO.Database
Dim rst As Recordset
Set db = CurrentDb
Set rst = db.OpenRecordset("Table1"
rst.Fields ????? Append dont work
So what is the object how must used in this case, to permet me to add new field like (string or integer)
cordially