nuritat
asked on
Access 2007 create index by vb
Hi
I'm trying to create an index to a table on Access 2007
like this:
Set idx = tdf.CreateIndex("PrimaryKe y")
With idx
.Fields.Append .CreateField("field1")
.Fields.Append .CreateField("field2")
End With
idx.Primary = True
tdf.Indexes.Append idx
it used to work for me on earlier versions of access but now I get an error on " .CreateField"
saying: "Method or data memeber not found"
any idea?
Thanks
I'm trying to create an index to a table on Access 2007
like this:
Set idx = tdf.CreateIndex("PrimaryKe
With idx
.Fields.Append .CreateField("field1")
.Fields.Append .CreateField("field2")
End With
idx.Primary = True
tdf.Indexes.Append idx
it used to work for me on earlier versions of access but now I get an error on " .CreateField"
saying: "Method or data memeber not found"
any idea?
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'd like to aword the points
I think you closed this question by mistake. You can generate a request in Community Support for Moderator review to reverse this.
ASKER
No, It was not a mistake, the answer was perfect I even awarded the points already, why should I open it again?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I already awarded the pointes twice, whats worng?
Hi nuritat. It seems to be sorted now. Thankyou.
ASKER
adding the DAO.index was enough