If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
delete columns
part 1:
tbl.Fields.Delete tbl.Fields(0).Name tbl.Fields.Delete tbl.Fields(1).Name tbl.Fields.Delete tbl.Fields(2).Name part 2: tbl.Fields.Delete "field0" tbl.Fields.Delete "field1" tbl.Fields.Delete "field2" From the above codes: the part 1 does NOT work. the part 2 work. If I run the part 1, then it give out the following message: "Cannot delete a field that is part of an index or is needed by the system." Can we have a way to run as similar as the part 1? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Tricky Delete Problem | Ida | Running & Setting Up Queries | 12 | November 21st, 2005 04:37 AM |
delete | Rich1234 | Using Forms | 3 | October 10th, 2005 02:37 PM |
How can I DELETE a CONTACT from the Contacts Folder without an Err | Frustrated & Fuming in Fairview | Contacts | 1 | July 5th, 2005 08:52 PM |
delete extra columns and rows | matt charlton | General Discussion | 1 | June 7th, 2005 08:46 PM |