Search results

I found the solution to me problem: Changing the True part of the formula (=IIf([Cat1Ea]="","",([Cat1Ea]*[txtcount1])) from "" to null, made the error disappear. The working formula is: =IIf([Cat1Ea]="",null,([Cat1Ea]*[txtcount1])) Thank you

The Type error shows until I have all 4 preceeding text boxes filled. (The formulas work). The issue is the formula containing the "NZ" (not the multiplication calculations)

The following formula is giving me a "#Type!" message in a text box. =Nz([Cat1T],0)+Nz([Cat2T],0)+Nz([Cat3T],0)+Nz([Cat4T],0) I have two other textboxes doing a similar formula and they work fine. I cannot figure out the cause. The two working formulas are below...

Once again you came up with the answer! I was looking at other posts and they referred to removing the separate fields (that were ultimately concatenated). When I did this it caused the pull-down to be blank. Thank you again!

I have made the query and concatenated the two fields I want to display. when I "run" the query, the fields display as I want, but when I close the query, re-open the form and click on the combo box, there is no data. ?????

what is the concatenate code? My fields are: Category/Class and CategoryDesc

I have a combo box on my form that allows to user to select the piece of equipment being selected. Once selected, the displayed information is that of the first column shown in the pull down. Is there a way to have it show both columns (Category and description) after the selection is made? I...

Thank you!

What.does false equal (for curiosity sake)

I have a textbox (HrRate) that defaults to $100. I want this field to change to $75 if a check box (salesdel) is "T". I am trying to use an Iif statement like "=Iif([salesdel]="T", 75,100), but the showing default value does not change. What am I missing?

no training in Access.... I have build databases, but work in the Wizard world. I know it doesn't scratch the surface of the power of Access, but I have a better comfort level of that. So, yes, I have a stronger comfort level working with excel formulas

that did not work.....

i figured out the cause of the problem. It is "*[txtTruckHrRate])*[txtProfit%])". I removed these two and the textbox displayed correctly. I added the first multiplier in and Access crashed. I removed the Hr Rate and left the Profit% in and it crashed. I have an idea.....

I uploaded the sample DB that I exported my stuff to. I is a sample DB from MS, but if you expand the forms section and select "frmTranCalcTruck". Enter a number into the first QTY field and select 1 from the Zone (Miles). This should be enough to cause the program to fail.

Access 2013

OK, I tried the suggestion of putting the formula into an Event (I chose - gotFocus so I would have to click in the box to make it run) and after entering the QTY and Zone, all my calculations worked like they should. I then clicked into the new text box and all of a sudden the error "MS Access...

I re-entered the formula: =iif(([txtQty]=0,"",Round((([txtMiles1]/[txtAvgMPH1])+[txtCount1],2))*[txtTruckHrRate])*[txtProfit%]) Saved it. Opened the form (no errors) Entered 1 in [txtCount1] and entered 1 is Zone1 and as soon as I clicked away from the field, the error "MS Access has stopped...

I am not sure how this would be of benefit. In the end, I will need 4 of these calculations performed in separate text boxes to handle all the possibilities of equipment being delivered to 4 different zones off the same load. This text box is just the first that I need. I need to figure out the...

I needed to add a new calculation to my form that would break down a per equipment amount (after I got the total Load amount). The need comes from the fact that if a piece of equipment is shipped to a different Zone (to a different customer), that charge would not be simply a 1/4, 13 or 1/2 of...

I just saw it... thanks again!