Search results

each field on the form is a control. You have, excuse the pun, control over each and everyone of them. i.e. Table Users FName LName Age When you drop these into the form you create a textbox control for FName, LName and Age so you can set the color as such fname.forecolor = 2...

Are you doing this in a datasheet, a continuous form, or a form? If you use the continuous form or form then you can just change the color for each distinct control i.e. mycontrol1.forecolor = 1 mycontrol2.forecolor = 2 or something like this: for x = 1 to 10 me.controls("mycontrol" &...

If I'm understanding your requirements correctly, you're almost there... Public Function ColorValueOfDateComparison(datCheck1 as Date, datCheck2 as Date) as Long Dim datToday as date Dim lngDiffer as long, _ lngRed as Long, _ lngYellow as long, _ lngGreen as long, _ lngBlack as long...

Correct me if I'm wrong, but doesn't DoCmd.RunSQL prompt the user?? you might want to turn off warning prompts around the command if I recall correctly the syntax is docmd.setwarnings false docmd.runsql <your sql here> docmd.setwarnings true you will also want to put a docmd.setwarnings true...

try replacing your currentdb.execute with debug.print and then look at was text is being created. Wondering if perhaps you don't have a null value in there somewhere i.e. your sending: "Insert into CPA (Q1) values ();" to the database you also might want to code it as follows...

Shouldn't me.parent!mycontrolname and me.parent.controls("mycontrolname") equal the same thing?? In my version of access they don't. I've also had other weird referencing issues like: form_myform.mycontrol <> me.mycontrol Also why would my form_current execute twice?? (I have a...