Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Deleting columns from VBA

Status
Not open for further replies.

eojhan

Technical User
Jun 21, 2002
5
US
I can't find any examples in the help on how to do this, but I'm sure it must be simple. Could someone help get me started?

Owen
 
Actually, I just found it in another thread. I was searching for "delete column" but I switched to "delete field" and found thread705-298511:

TrojanRabbit (Programmer) Jun 21, 2002
Delete a field from a table or a field control from a form? To delete it from a table, use the following:

CurrentDb.TableDefs(<tablename or index>).Fields.Delete <fieldname>

I don't think you can delete form controls in VBA.

Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top