Search results

I found a great piece of code to eliminate the #Error from displaying in calculated text boxes...(I have a text box that waits for the input of two others and then runs a calculation) The problem is I don't know where to put it! I tried entering the function call into the Default...

I found a wonderful little piece of code to remove that nasty #Error in calculated text boxes...but I don't know where to put it to make it work. I tried putting it in the default property...it's a function call Function removeerror(testvalue As Variant) as Variant If...

Hello oh wise and knowledgeable forum... I want to update a field on a table based on the entry in a subform...the subform is linked to one table, but I also want it to update a field in another table. Is there some sort of afterupdate code to do this?? Thanks, Rebecca

Trying to calculate # of hours work if time in is in one text box and time out is in another...daily total is T3. I'm using the timevalue function to no avail. What in the world is going on here??? Please advise. Thanks, Rebecca **Life moves pretty fast. If you don't stop and look around once...

Okay...here's a stupid question... I have no switchboard manager in my tools menu. I go to Add-In Manager and there's nothing there either! I tried to find the darn thing on the Office 2000 disk and I have NO idea where it is. Anyone know??? Please help?!?

I posted this in the Modules section...thought I'd put it in here, too... I have two text boxes...T1 and T2...I am trying to send the contents of these text boxes to a function CostFactor and return a value into a third text box, T3. The function is declared and coded in a module in the same...

I have two text boxes...T1 and T2...I am trying to send the contents of these text boxes to a function CostFactor and return a value into T3. The function is declared and coded in a module in the same database. The code compiles and appears to be correct. I set the control source of T3...

Me again... I have a combo box that comes from a condensing_unit table. This table has a numeric primary key (numbered 100-1xx)...each record has a unit_number and a coil_number. There are two of each unit_number using different coil numbers. When I create the combo box it shows both the unit...

I want to automatically fill in a text box on my form based on the selection in the previous list box. I know how to do this in Oracle...love those post-text triggers...but can't seem to get it right in Access. i.e. I have a Sales_Reps table with Rep_ID, Rep_name and Rep_phone (among others)...