Search results

I hear ya' and been there with you (in a parallel db universe.) Now that's funny, one of the flavors of the db I used was called Universe. It had many names. Rocket Software has bought up most of the licenses to corner the revenue stream from legacy systems still in use.

Look at the Northwind Traders DB and tell me MS designed one way to get things done. 🤣 (I'm laughing at the Northwind Traders, not you.) Thanks for the form tip, but I've already solved the print one record on a form challenge.

Thanks for your comment. Yes, as stated previously, I've been looking at the link and db you generously provided to the actual question. Modification and testing underway. I'll agree many of the comments are useless, and I wouldn't object to their deletion. Other people may have the same...

Because I've done tests on DLookup, DMax and DCount in Access? Look at the readv with nested else statements. One line of code. How may SQL statements will that need? My plan is to avoid SQL Server, because it brings very little to the game for my user's needs. As to the comparisons, I addressed...

Except the relevant code is 5 lines or less, and the main Form program can modify, prefix or suffix an autonumber to do the kind of BE stuff I've been talking about. When I say Access is closed, I mean you have to use autonumbers their way or noway.

Gotcha and my experience was similar. Basically, I had a formalized way to transmit requests for change to the "BUPERS" and then transfigure, error check, report errors back, and update the primary table (file) with valid record change requests. Only it worked with dozens of clients against a...

Cool and lucky you, my first experiences were with a teletype machine and paper tape, which you had to type the program on to and then rerun through the reader to execute on the remote system. I then got "lucky" with assembly, Fortran and COBOL on punch cards. I'm guessing about 15 years before...

I can't see the post right now, but Nautical Nut Guy (who my post was directed at) said I'm trying to push a square peg into a round whole using sequential numbers (contrary to some of the posts by others and what M$ does with autonumbers). I never said primary keys have to be sequential. In...

Wow, if what you say is true, then how did my question get to four pages? Even if two of them are your snotty comments. As I said, two of the comments from moderators look promising. I guess you didn't notice that. Now, if you'll excuse me, I'll get back to coding a solution to my friend's...

I've followed your past advice on several things. For some reason the old post showed up to me in the daily list. It was a topic I'm interested in. I didn't find a solution here, but did search and thought to share a possible solution, if not for the original poster, then anyone else that might...

I never said Access won't work. I have said it's a bit difficult to find a solution to some issues I face. Okay, since you don't have an answer, and don't want to give one, which post number here solves the problem? I'm looking into two, from others, that look promising (from two of the...

Okay, because you asked. And nicely I might add--thank you for that. 1. Well, everything was done at one point by post. I survived on that for many years and 1/2" tape. 2. Ideally, with a good Internet connection synchronization can be close to immediate with the right primary key available for...

Again you don't understand, or didn't go watch the original linked tip. If sequential numbers are so bad, then why is practically everyone using then as a primary Key? And my original question was about sequential numbers in a reference field, not the primary key. You also missed where I showed...

Thanks for your comments. I don't think some of the quotes are from me. I don't think I ever said some of what you say I did. I can't read all of the post, as once again this site, or Edge has made a mess of what I see. As to the original question, it's a reference number or code for the...

Okay smart guy, what was my question and what do you think was the suggestion that will work?

I'll just say: #1) You didn't understand. #2) You haven't understood. It's all there, but you'll need reading comprehension skills instead of scrub the latrine with a toothbrush experience.

Of course, my strategy changes as I learn more about what Access can and can't do. My objective remains fixed. Yep, people in Colombia don't have the resources that "gringos" have. A good programmer here makes about US$4 /hr. Mid-size business (50-100 employees) can only dream to break a gross...

I don't need to prove anything. I retired early with my buyout in the bank from the dot-com foolishness. However, I see you want to ride on the coat tails of others and claim they are "best practices", when I've clearly shown the faulty logic therein. I'm just trying to help a friend find a...

What can I say? One of the posters here brought the article to my attention, and he's been dealing with the same thing recently. I haven't seen anyone offer a better solution for Access. And actually, the concept is older than forty years, too bad M$ didn't take it to heart when designing...

Perhaps an erroneous premise, but then the question then is, why did he write the article and all that code? Granted, it's a bit dated, but so is Access I suppose. Not much change for several years, just the typical M$ moving shit around. So, I'll suspect the bugs are still there. My original...