Search results for query: *

Thanks Duvy! Your code brought me to the root of my problem. By failing to specify the control type, as soon as my code hit a control that does not support the Enabled property ( Label ) it errored out. Best to all! Mike

Thanks Sorrells, I got a couple ideas from your suggestion but didn't work. Duvy... the problem is the the lin "Me.ctl.enabled = false" won't work. It does not seem to replace "ctl" with the value. I am beginning to think I may need to read all the control names into an...

I need to disable all controls except one checkbox on my form (and subforms) depending on the condition of another checkbox. I have tried looping through the controls collection as follows: dim ctl as control For Each ctl in Me.Controls Me.Ctl.Enabled = False Next ctl Then I planned to...

Hey Jim... "Dim fld as DAO.Field" got me working! I really learned a lot from this piece of code and you saved me a great deal of time. THANKS! And thanks to Carol for posting the question! Mike

Thanks Jim, I appreciate your help. will check back here later this eve. Mike

That got me past that line but now getting a Type Mismatch in the next line..."For Each fld in rs.Fields"

Hi Y'all, Very Co-incidentally I am working on the same kind of problem and am following your thread. I am also getting an error in that same line. No matter what I have tried I am getting a "Type Mismatch". My primary key an integer but near as I can tell this should not make a...

raskew, Thanks very much for taking the time to reply. That did indeed solve my problem. Sure is nice to have help out there! Best Luck, Mike

This is wild! I have a field in my query based on the following expression: Expr1:(([Units]*[Current$PerUnit])-(([Weight]*[$/LB])+[Packgng]))/([Setup]+[Spec]+[Saving]+[Down]). This expression gives the expected (correct) results. When criteria such as <100 are entered directly in the criteria...