Hey, im not getting the .CreateIndex or .Execute commands that are mentioned in examples given to this question previously. Im referencing ADO Ext 2.5 for DDL and Security, ActiveX Data Objects 2.1 Library and DAO 2.5/3.1 Compatibility Library. Am I missing something?
With newTBL
With .Columns
.Append "Folder", adWChar
.Append "Barcode", adWChar
.Append "QTY", adInteger
End With
.Columns("Folder"
.Attributes = adColNullable
.Columns("Barcode".Attributes = adColNullable
.Columns("QTY".Attributes = adColNullable
'Set index = .createindex("Folder"
'index.Primary = True
'index.Unique = True
'.Indexes.Append index
End With
~*Gwar3k1*~
"To the pressure, everything's just like: an illusion. I'll be losing you before long..."
With newTBL
With .Columns
.Append "Folder", adWChar
.Append "Barcode", adWChar
.Append "QTY", adInteger
End With
.Columns("Folder"
.Attributes = adColNullable.Columns("Barcode"
.Attributes = adColNullable.Columns("QTY"
.Attributes = adColNullable'Set index = .createindex("Folder"
'index.Primary = True
'index.Unique = True
'.Indexes.Append index
End With
~*Gwar3k1*~
"To the pressure, everything's just like: an illusion. I'll be losing you before long..."
