Search results

You are beginning to see that Access is Not Excel. You are heading in the right direction, but have to make that leap of faith that stops you thinking in Excel methods and starts thinking in Data methods. - Thank you, I really want to understand Access as this is the direction I need to go in...

The problem of making the calculations in real time without having to refresh or save was solved. So now in my input form as the variables are all inputted the result calculates in real time as it should do which is great. The problem now is that once all this data has been inputted (say several...

Thank you for explaining this but I do need to store the results of the calculations. The user inputs the LxWxH, material type and price per m3 of material. These five variables determine the price. The reason I need the calculations to be made in real time is so the user can adjust the m3...

Thank you for that. I hadn't noticed your final post there.

Thank you for your input. So are you saying that by using this method the query will auto calculate the result within the form as soon as the data is entered i.e. as an Excel spreadsheet would, and then still transfer it to the table? If so, where would I place the query? Sorry, I'm a bit of...

Hi I have been trying to convert to my Excel quotes, orders and invoicing system to Access so that multiple users can all input data simultaneously. However, I am running into problems that I am now not sure if Access can handle. In my current Excel version, as quotes are being written...

Does this look correct? Private Sub WEIGHT_AfterUpdate() Me.WEIGHT = IIf([WEIGHT CALC] <> "0", ([H] * [W] * [L] * [WEIGHT CALC] / 1000000000), "-") End Sub WEIGHT is the name of the textbox Thank you

When I do this the expression doesn't populate the cells with anything.

Hi How do I get the data in a form control to populate the corresponding table field when the control source box already contains an expression for making calculations within the form? Thank you

I'm not sure I understand? I have both now set to number and I'm getting the same result. Is this what you meant? Thank you for your help.

O.K. so I have reduced this expression to the following: =IIf([WEIGHT CALC]>"0",Sum(140*150*1200),"-") Even as simplified as this it only returns "-". [WEIGHT CALC] definitely contains value "2200" which is in number format. Surely the syntax must be wrong somewhere?

Thank you for the suggestion but it didn't make a difference.

Thank you for your input. Unfortunately this made the cell return nothing.

Thank you for your input. So instead of the "Select Material" prompt, replace with -1?

O.K. thank you for this tip. Any advice as to how to get around it?

Hi Thank you for your input. [WEIGHT CALC] contains a value (in this case 2200) which is the result of another expression. When I use the Nz version you suggested it doesn't return anything, the cell is blank.

Hi I have the following expression: =IIf([WEIGHT CALC]<>"Select Material",Sum([H]*[W]*[L]*[WEIGHT CALC]/1000000000),"-") The [WEIGHT CALC] cell does not contain "Select Material" so I am expecting the first part of the code to execute but instead it jumps to the final part and returns "-"...

That solved it. :) I changed the field names to H, W & L and it all works fine now. Thanks Minty

It is a form control source. I have substituted hard coded values and it works as expected.

Thank you for your input. Both are actually width. I just made a typo in the original post. I'm still not getting the right result though.