Recent content by twgonder

Here I am in April of 2024. With a big thanks to MajP for taking the time to answer this question years ago. This is exactly what I didn't know that I needed for a variety of different tasks in my forms that zig or zag based on the entry controls. And it's great to get a good example of how to...

@all It needs to remain a currency with the 4 decimal places. The large numbers as the integer part are important. I can't understand why Access is having such problems with a format that I want to use. I've tried a few different tricks, but nothing seems to work to either maintain the format...

Upon searching, I see a lot of people have problems with currency and formatting. But I didn't see this one. Maybe my friends across the pond have dealt with different currency formats? I have a currency field that is always positive, always has four decimal places to show. No commas or currency...

I'm going to take a moment to discuss something not related to Access, but brought up in this thread: cognitive dissonance. It's, in simple terms, the discomfort related to two conflicting ideas in the consciousness that creates a desire for resolution. Journalists, PhD candidates, law...

The correct way is: Vaya con Dios. If it was a question, then you use ¿ and ?. Proper syntax: "How about, ¿vaya con Dios?" From educated people, you're more likely to hear, if it's not a question: Que te vaya con Dios.

Well, it seems you just offered more reasons why your form solution is defective. Thanks. And you still haven't seemed to catch on to the fact that I had a solution for the copy before I asked my original question, which wasn't about how to copy. What can I say? Why would I pay you for something...

If you were to follow the link, and see the code, without paying, then you know your argument doesn't hold water. But Richard, being a cool guy, has maybe given me free access to some of his pages, I don't know. His solution worked, yours doesn't. It's that simple. Your form solution doesn't...

As you requested (or as they say in Colombia: A la orden): Copy Records (599cd.com)

Well, if you do look carefully, you'll see that I did use split() in one routine (line 80 in the fSarrayPosition function). I've got more routines to write (for delete and insert) that would make working with an array a bit more cumbersome. So, I practiced with the simple one (extract) before...

Glad to hear it, and again, thanks for your observations. I just don't have time to reinvent other solutions when I have one that works fine. I do want to learn new things though, that's where I would rather put my time.

Which post(s) do you think did that (a solution), based on my clarification of the method I was using shown in posts #5 & #8?

I think I stuck to my original question for purpose of this thread and don't recall moving the "goal posts", with maybe one exception, which was more of a comment about Amber. Now, I did answer people's "why" questions, or commented/questioned on their proposed solutions. But I don't think you...

I've got lots of "personal" information fields, like mother's maiden name, that I put in a different form, and then control who has permission to that form.

When you say elves, do you mean the coders at M$ that are maintaining Access?

@ Pat, continuation, I also added in my logic a way to update another table. The reason for this is there might not be a copy command button to press on a form, but backstage logic might want to spawn a new record based on some entry in the current form based on business logic. For example, a...