By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,615 Members | 1,961 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,615 IT Pros & Developers. It's quick & easy.

Nobody knows how to return a especific row?真?

P: 5
how to return a especific row whitout specifying fields only by it's position?真真真真真真真真真真真真真真
Oct 23 '06 #1
Share this Question
Share on Google+
4 Replies


Expert 5K+
P: 8,434
how to return a especific row whitout specifying fields only by it's position?真真真真真真真真真真真真真真
In my opinion this has always been one of the biggest drawbacks of Access - the inability to siomply refer to each record by a specific record number. I accept that there are valid reasons for it, but it's extremely annoying.

One way to work around this is to add an auto-number field to your table, and use that as a unique record number.
Oct 23 '06 #2

P: 5
ok thanks, but what happens when you delete a register? you have to arrange the autonumeric field again? it's very annoying
Oct 23 '06 #3

Expert 5K+
P: 8,434
ok thanks, but what happens when you delete a register? you have to arrange the autonumeric field again? it's very annoying
Good point. And it's even worse than you think, because you can't "arrange" an autonumber field. You can't update it at all, it's completely automatic. Of course, this does make it more useful as a unique key, since once the number is assigned, that record will always have that number.

If you can't allow gaps between record numbers, and deleting is possible, then I guess an autonumber field is not the way to go. It was merely one possibility.

If you only need the "number" to be valid within a particular session, then perhaps you should investigate "bookmarks" in the Access doco.
Oct 24 '06 #4

100+
P: 106
Hi

Why don't you try DLook ou function.

regards,
Oct 24 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.