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!

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

Using an index and seek

Status
Not open for further replies.
dennis9988

dennis9988

IS-IT--Management
May 25, 2006
1
US
I want to use code such as the following from VBA:

set rs1 = db1.openrecordset("tablename",dbOpenTable)
rs1.index = "index1"
rs1.seek....

but no matter what I try it does not want to let me just open the table and seek. I think the ODBC driver does not have that capability.

I tried DAO and ADO.

Thanks
 
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
Using Err.Raise question
Replies
2
Views
350
mintjulep
M
feipezi
  • Locked
  • Question
How to pull data from MS Access DB and place on an Excel spreadsheet with WHERE clause? 2
Replies
10
Views
264
feipezi
feipezi
aldi07
  • Locked
  • Question
update a front-end databases with a new release using vba
Replies
2
Views
132
aldi07
aldi07
dgillz
  • Locked
  • Question
Back coloring an entire row if a duplicate is found in a dynamic range 1
Replies
18
Views
323
SkipVought
S
JAB_123
  • Locked
  • Question
I want to use an excel file for inp
Replies
3
Views
166
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top