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...

The text box is a calculated field, dependent upon the values of other objects on the form (listboxes and comboboxes, etc.) Until all of the necessary boxes are filled with values, the calculation doesn't execute, therefore leaving me with #Error appearing in that box. End users don't like such...

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

Nevermind... it's working now. One of those great mysteries in computing..."I didn't change anything, but it's working now"

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...

Oh my everliving. Color me stupid. Thanks!

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've got it... The syntax problem was in my Select Case statement AND I inadvertantly named my module AND my function CostFactor. Access didn't quite know what to do with that. Rebecca

The problem is with the array...not the function. I need help with declaring, populating and using multidimensional arrays.

The problem appears to be in my array, not in the function handling. I also altered my Select Case structure...I found some different syntax and fixed that. So I guess don't beat your head against a wall...it's in the array. If you know anything about that please let me know. Thanks R

The first text box is entered by the user. The second is filled in with an After Update line of code where the third column of a combo box is displayed in this box. I then take these two text boxes and use them as the arguments to pass to my CostFactor function. I'll email it to you. If you...

How do I step through the code of just that module...the only thing I see is a Compile Cooling Cost (the name of my db) in the DeBug list. I watered down my code...you'll get the idea... T1 is actually named txtheatgain and is entered by the user Format: general number T2 is txtcoolingcap and...

I just reviewed my book...Access 2000 Programming... You can reference a declared function directly from a control source within a text box. Something else must be wrong. Could it be that one of the text boxes is manually filled in and the other is filled in as part of an After-Update line of...

The names aren't T1 and T2...they are txtcoolingcap and txtheatgain respectively. But I'm spelling them correctly, if that's what you mean. ugh.

I just tried that...I get an error message that says: Cannot find the macro 'T3'... agh!

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...

P.S. What does the Me stand for/do in that line of code?

Bravo! It works...thank you so much! I had been beating my head against a wall for days! (I'm not real good with VB...so this really made my day!) Thank you, thank you, thank you.