Search results

Okay, I understand, a lot of times I don't understand other's code either. That's the way it is. Are you saying you're getting caught in a real endless loop? In that case the form will stop working, I haven't seen that. Yes, string array manipulations are all about loops, you can easily set a...

Odd, I've tested it about 50 times, and it hasn't failed me yet. It's supposed to jump to the new record that was copied. Did it go to some other record than the new one for you? A good way to tell is look at the minutes and seconds in the EntityCd text box (you may want to make that one...

I agree, I think macros are obscure and not very flexible. But then, you have to ask, why did the "experts" that created Access create so many different macro actions? Why does M$ keep calling VBA code "macros" in the documentation? Very confusing for a RAD or any other db tool. If you were...

Well, it's not a database for anyone to use in production (as is customary in a Forum like this one). It's a demo database that shows how one can copy a record, and then most importantly based on my original post, how to move to that record. Did it do that for you? Now if you pick up any...

Okay, for those that stuck it out this far, this should help you see what I was looking for... AND THE SOLUTION! (Yes, I know, I know, it's not the only or ultimate solution, it's just mine for now.) I tried to keep it simple. I used the original .accdb from post #17 and modified it to my...

As to the field space name, (I know, I know) that may have been an inadvertent error (I copied stuff quickly--it was an example and not a production db, so I didn't give a lot of attention to proofing stuff--the point was the error in copying). Check the next post for a cleaned up version that...

@ KitaYama Here you go. This is what I showed in post #33 Several developers in various articles, and some here, have said not to use autonumbers as a reference. I get it as I watched this short video some months ago: Microsoft Access AutoNumbers Are NOT For You (599cd.com) So, I modified...

Um Doc, I don't think you've looked at my code or tried the example .accdbs that people have provided. Most of what you say isn't what happens in reality or the examples provided. My code works, the examples of how I should do it, provided by others don't work (three lines of code or a macro RAD...

Of course I noticed that warning (correct record) and knew about it. What fool would think if they are on record 2 and want to copy record 1 that the system would magically divine that? The selection takes place when the user moves to the record they want to copy. Or does everyone here have some...

I just stopped by based on a comment by Doc and briefly viewed the comments. But I have no problem with a pure reading of the origianl title. As I understand it, what you would have is two biological women battling it out in a boxing ring. It's not relevant that one suffers gender dysphoria and...

Sorry, I guess I misunderstood the insinuation in your post #25. Why would "copy" in a form copy table data? Um, because there is supposed to be a dynaset (connected to the table) under the form (if not run from a query) that has the entire record set available for copying? That was covered in...

No, that's not what I asked for. And I gave examples in post #33 why the proposed solution doesn't work. No explanation needed, thanks. But, thanks for the helpful links you do provide, they often give me a different perspective on a possible solution found elsewhere. Heck, I even tried your RAD...

Gee, I did write the code, AND POSTED IT (#8), before following your suggestion to use the RAD tools provided by M$ in Access instead. On my version (2021), Access it won't convert this type of macro to VBA that it attached to the form with the wizard. Okay, I'll start blaming Santa Claus for...

I understood the code. I didn't think the three lines world work based on my understanding, and I was correct. And no, they didn't copy the record if you look at my posts carefully. I said very clearly what I wanted in post #1. I wasn't looking for a three line solution that doesn't work for...

Sorry about the junk images in my response, the web page is putting them there not me (if they post) Please read what Pat said in my response post #27. My comment about the smart guy was talking about Richard Rost and his site dedicated to making Access better for the user, and not for Pat...

Here is the "solution" failing, as I thought it would, but not for the first reason I suggested (although it fails for that reason too). Apparently, the solution doesn't copy record fields that aren't on the form. I think I had read that somewhere before, and the idea just sat there in my...

Oh gosh, here's a guy that truly thinks he's smarter than Access, and one of his customers too. In fact, he has a whole website dedicated to the idea. I'm really hanging out with a bad crowd here in the Access universe. Imagine, him and his 50,000+ Access followers pounding square pegs all day...

The macro fails, but it's not clear why. I suspect the second index that doesn't allow duplicates. Or some form code to control navigation. I'll need to check deeper when I have time. P.S. I turned off the index and all the navigation controls and the macro still fails without any kind of...

Maybe it wasn't you that said the designers of Access at Microsoft created one way to best do things. What could be more RAD than this macro? Dang, these pages are driving me crazy the past two days with weird stuff, anyways I said, I suspect "The three lines of code recommended by arnelgp" will...

Actually, I'm pretty happy with the result of this effort. And you're right, I don't want to use macros to do the task of copying, I want VBA code to do it (because I have error checking wrapped around it). I think my overall form solution will make life easier for those with less than perfect...