Recent content by Bubba002

Just to follow up with y'all on my progress. Gasman, I was able to step-in and use the Debug feature. MajP, I noticed that it took ~4-5 seconds to load my form. The VBA has to apply two (2) rules to all the controls I had tagged (~115). When I had hard-coded all the CF Rules, my form would...

Gasman, Yes, I have used F8 to step through my code before. I'm not sure why, but I can't seem to get it to work on my form code now. Even when I go to an executable line and Run To Cursor, I just get the chime sound. This with the form closed, open, and in design mode. MajP, You are...

Thanks for the input. This is turning out to be a great learning experience for me. Embarrassing. Last night I copied my subformIS-1a to subformIS-1c to keep subformIS-1a as it was for use on other existing forms. I forgot to copy the new code to new subformIS-1c. Now that my code in on the...

It looked straightforward, so I gave it a try. Not working. I removed the old CF rules and added your code above, but it didn't work. I'm not familiar with the Split() function. From what I just read, it looks like it will give two strings. If my ControlName is qryIS-1.Loc, for the line...

Yes, my database application uses different prefixes to distinguish 'live' data from 'aged' data. This looks like a very good solution for making the CF Rule universal. No more Conditional Formatting one control at a time! I'll review it and give it a try tomorrow. Thanks again for all you help.

Thanks for the references. I'll dive into them and begin learning again.

I currently have my Conditional Formatting expressions hard-coded on a subform. An example is as follows: ControlName Rule 1 Rule 2 qryIS-1.Loc Value <> [tblqryIS-1c.Loc ] Expression is...

Great advice. Works like a champ! Thanks a bunch. Now to my other issue.

Gee, why didn't I think of that? Here is the zip file (~5MB).

Looks like the files are too large to attach. Is there another way I can get these over to you?

Yes, I have a test database I’m using. It's a split databse. 'Test-01 Instr Summary_be' is the back end (~15MB), and 'Test-01 Instr Summary_fe1' (~30MB) is the front end. I hope they can attach here. My main form is frmIS-1c. My subform (subformIS-1a) is in tab ‘All’. New ‘txtControl’ unbound...

Hey MajP, I'm using your 'ID Active Control' example to get the Control Names from just one subform to my main form. I copied your main form and subform code exactly onto my main form and subform code respectively, but it's not working. It compiles OK but, ... I get the following error when I...

I'm a retired engineer living in the New Orleans area, USA. I've been developing databases for engineering use since the days of DOS (Dad's Operating System-haha). I still have interest in improving some of the code I've been using these many years. My other big hobby is woodworking, making...