Referring to access records - Should be easy but not for me.

[pedie]

Hi, i have question on how to refer to range in access?
Suppose i want to edit ID no 107 instead of looping how can i go and directly refer to that record and edit/delete....

Thanks everyone

 

[james_lankford]

I'm doing it pedie's way, but only because I'm loading a text file into access every week and even though the file is fixed width, the data is formatted poorly (sometimes midnight is 24:00, sometimes its 00:00, sometimes its 12:00am; and there are other problems too)
so I find it easiest just to open a recordset for the table, then read the file line by line, fix and clean the data and then addnew/update the recordset

I used to work for a guy who, everytime he wanted to change data in a table, would open a recordset, seek to the correct location and edit or delete the record

and since I worked for him he insisted I write all the programs that way,
I really hated it ha ha

but, yes, sql is definitely the way to go
there is so many wonderful things you can do with sql that you can't even do with the query builder

this is an ok intro to sql
http://www.w3schools.com/sql/sql_syntax.asp

that site has some good tutorials on a variety of subjects
http://www.w3schools.com/sitemap/default.asp

 

[pedie]

Thanks again everyone for helping....