TURNERMICH
Technical User
I am using Access2000 Mdb file.
Set db = OpenDatabase("c:\accounting\accounting.mdb"
Set td = db.OpenRecordset("TheData", dbOpenTable)
Set td2 = db.OpenRecordset("DataUnique", dbOpenTable)
Set td3 = db.OpenRecordset("Results", dbOpenTable)
td3.Index = "MainKey"
=============================
The Key "MainKey" is made up of...
Rdate Date
TheItem Numeric
TheNumber Numeric
============================
td3.Seek ??????????????
Appreciate some help with the SEEK command to look up the combined Key.
Set db = OpenDatabase("c:\accounting\accounting.mdb"
Set td = db.OpenRecordset("TheData", dbOpenTable)
Set td2 = db.OpenRecordset("DataUnique", dbOpenTable)
Set td3 = db.OpenRecordset("Results", dbOpenTable)
td3.Index = "MainKey"
=============================
The Key "MainKey" is made up of...
Rdate Date
TheItem Numeric
TheNumber Numeric
============================
td3.Seek ??????????????
Appreciate some help with the SEEK command to look up the combined Key.