473,320 Members | 1,884 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Nobody knows how to return a especific row?¿¿?

5
how to return a especific row whitout specifying fields only by it's position?¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿¿
Oct 23 '06 #1
4 1155
Killer42
8,435 Expert 8TB
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
bfirpo
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
Killer42
8,435 Expert 8TB
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
tara99
106 100+
Hi

Why don't you try DLook ou function.

regards,
Oct 24 '06 #5

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

Similar topics

1
by: Sullivan | last post by:
When I run a CGI script (Python) with Python's CGIHTTPServer, it should run with the UID of the user 'nobody' (as the documentation says). But if I let the CGI script e.g. create a file, it...
5
by: | last post by:
I can´t find anything *usefull* about replacement strings, even on google! Anyone know how to deal with the ReplacementStrings from the LogEntry class? When you read a LogEntry.Messages that...
74
by: Suyog_Linux | last post by:
I wish to know how the free()function knows how much memory to be freed as we only give pointer to allocated memory as an argument to free(). Does system use an internal variable to store allocated...
6
by: Peter Oliphant | last post by:
I've now asked how three times in this forum with no answers. So I went to the 'windowsforms' newsgroup, and found this post, also unanswered, with the same problem: "Hello, I've tried to...
3
by: throwaway_addr_12345 | last post by:
OK, looked at the faq, went to faqts.com (discovered irt.org ain't there and webdeveloper.com is hung, but nil else), read every blessed thing I could find on events and handlers at quirksmode...
68
by: James Dow Allen | last post by:
The gcc compiler treats malloc() specially! I have no particular question, but it might be fun to hear from anyone who knows about gcc's special behavior. Some may find this post interesting;...
1
by: VBA | last post by:
How can i select (highlight) an especific line in a textbox?? -- - Starving to learn and Happy to help - Victor :)
4
by: Jason | last post by:
I'm troubleshooting a program that I didn't build, so forgive me on this one. It's called email.php, and it looks like a program that the original developer must have downloaded from somewhere. ...
4
by: Fro | last post by:
Hi, the operating system (Unix) considers a php-server as a user with name "nobody". For example, if my php-script saves a file uploaded by a user, the owner of the file will be "nobody". I...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.