|
| |
|
|
accessman
Posts: 74
Joined: 9/13/2005
Status: offline
 |
delete columns - 1/29/2006 20:40:24
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?
Thanks.
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
