How would I locate a database object, e.g. table, using VBA? After locating the object how would I add a column or field to the table?
Thanks!
Dave
Depending on the Access Version you are using, the most efficient way to locate Database Objects are the CurrentProject and CurrentData properties which are readily acessible via the Access Help Files. To add a Column/Field to a Table, you can use DAO, ADO, SQL, etc. Give me some more details, and I'll provide a Code Template.