ADO Delete Method (Fields Collection)

Home | About me | EXCEL VB Programming (XL97-2003) | ACCESS Programming | EXCEL VB.Net Programming | EXCEL Spreadsheet Functions |  Material Management  |  Guestbook
 

 

ADO Fields Collection >> Delete Method

The Delete method designates that a specified Field object is to be deleted from the Fields Collection.

You must call the Update method of the Fields Collection to make this deletion. This method has one parameter.

Syntax

Fields.Delete Index
 

This method has five optional parameters.  

Parameter

Description
Index The Index parameter is either the name property or the ordinal position (index) in the collection of the Field object.

Example

objRecord.Fields.Delete 3