How do I read an Access Table by key?

[PRD]

I have a 25,000 record Table with a key. I am familiar with the MoveFirst, MoveNext, etc. commands but cannot seem to find any infomation which will tell me how to read a Table by the key - a ‘MoveKey’ command if you will.


Rather than reading through all 25,000 records with the MoveNext command to find the record I’m interested in it would be nice to go right to the record with one read. Can you give me the syntax for reading a record by the key?


Also, what would the syntax be if the record cannot be found (in the ancient language of COBOL we called this an ’Invalid Key’ clause). Thank you for your time.

 

[jdraw]

See http://www.blueclaw-db.com/access_findfirst.htm
for an example of FindFirst.

I think we'd refer to not finding a record by a given key as Record Not Found --indicating such a record does not exist.

 

[PRD]

jdraw -

Thank you for your help. Is there a manual or other Websites you can recommend that will cover programming commands in more detail? The manuals I have are pretty basic (and useless). Thank you for your time.

 

[smig]

if you find the record on a form use the .FindFirst as suggested.
if you open a recordset use the WHERE clues to filter only the record you want.

 

[jdraw]

Some useful sites
http://www.fontstuff.com/access/index.htm
http://www.functionx.com/access2003/index.htm
http://www.accessmvp.com/strive4peace/

free video tutorials here
http://www.datapigtechnologies.com/AccessMain.htm