D Dirk Goldgar Nov 6, 2003 #2 jpeddie said: how do I create an index on an access table with vba code? Click to expand... You can do with DAO objects, by using the TableDef.CreateIndex method; see the online help of Index Object. Or you can build and execute a SQL CREATE INDEX statement.
jpeddie said: how do I create an index on an access table with vba code? Click to expand... You can do with DAO objects, by using the TableDef.CreateIndex method; see the online help of Index Object. Or you can build and execute a SQL CREATE INDEX statement.
T Tim Ferguson Nov 6, 2003 #3 how do I create an index on an access table with vba code? Click to expand... This comes straight from the Help files: strSQL = "CREATE INDEX NewIndex " & _ "ON Employees " & _ "(HomePhone, Extension);" db.Execute strSQL, dbFailOnError Hope that helps Tim F
how do I create an index on an access table with vba code? Click to expand... This comes straight from the Help files: strSQL = "CREATE INDEX NewIndex " & _ "ON Employees " & _ "(HomePhone, Extension);" db.Execute strSQL, dbFailOnError Hope that helps Tim F
