Search results

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...

@ Pat about post #71, a quick question before I dig into your solution. Will it copy fields from the record that aren't in the form, but are in the record, to the new copy record? Or will I end up with a bunch of null fields? I added a label on the right side of the TWG.accdb frm_Entity form...

I don't know what to say. Even if I don't stand on the F8 key, it takes me less than 60 seconds to get through the all the routines. Now, if you're reading each line of code in a loop over-and-over again after the first iteration... More importantly, I'm curious where the form copy is failing...

Thanks for your thoughtful comments. Yep, I'm working in Spanish, French, Portuguese, Italian and English, so far with the app. What part of moke123's response do you agree with? I think I addressed all his concerns in post #63. I'll read your articles on compare to see how it applies. I just...

I've seen it many times over the years. I'll keep an eye out and post back next time I see such a macro reference for VBA in M$ documentation. (I'll just have to remember which thread this is.) 😆

Amazon.com: AMBER X Smart Personal/Home Cloud Storage Device for Data and Media Files, Built-in 512GB High-Speed SSD with USB Storage Expansion, iOS/Android/Windows/Mac Compatible, Black : Electronics They just aren't real clear as to whether it runs Windows Apps or not.