Recent content by Jake2

I did read that explanation of the buffers and it kind of makes sense, but after a bit more experience, I think it will all come together. Even building an expression has me a bit dubious when it comes to text vs value. Part of my difficulty is that I am pretty much self-taught - except when I...

Yup! This worked fine!! Thank You so very much. And thanks to all who invested their time to help a VBA dummy! ; -)

OK, folks, I will explain this the best I can. To begin, the code for this operation was copied from a couple of the many Access support websites (not a forum), online. The code works, except for the error message. This is proven by the fact that after I close the error message, the filter from...

There is no "BeforeUpdate" code on any of my controls. One of the reasons I am confused (realize that I'm just a hair past novice and that line is blurred) is that when I hit debug, it highlights the form OnCurrent. Am I right in guessing that is why you suspect some BeforeUpdate code? The...

Apologies, as you are correct, I also have it correct in the actual event. The mistake occurred when I copied/pasted. The past put all the code in one paragraph and I had to put it on the proper lines. I apparently missed that line. But the code in my app is as you detail. Thanks, however, for...

I have a continuous form that I can filter using a combo box and a textbox that reveals the current record. Individually, the code for the individual controls work fine. But because the two cause a conflict that I am trying to eliminate. Any help will be appreciated. Cheers, Jake Note: I know...

The only other option I found is to change to a text box, then change back to a label. You will have to replace the caption, however.

I am trying to change the color of text for a command button, then return to the original color after it is passed. I can get the text to change, but the funny thing is that it does not change until the mouse leaves the button, which defeats the purpose of "Mouseover". And I still need to change...

Perfect! The answer was far simpler than I made it out to be. Much Thanks! Have a great day!

Hello, Several years ago, I was comfortable using Access; I didn't consider myself a guru, but was able to get done what I needed to get done. Now, that is no longer the case since I retired some time ago and am trying to use Access for some personal record keeping. I seem to recall that I was...