Search results

I need to trim a lot of tables. Is it possible to delete table fields with reference to the field number instead of field name? The command 'tblMyTable.Fields.Delete ("FieldName")' takes a string (field name) as input. I rather like to - in a loop - delete say, Sub DeleteFields() For i =...

Problem: Field names in my table A is built by a character followed by a number, e.g. A1, where 'A' signies the variable and '1' an ID of a person. My second table B have the same field name structure, like B1, B3 etc. This table is constructed as a result of a complex Pivot query, and I have...