Search results

That was a typo, now edited but the problem remains. Thank you

Hi The code is cut and pasted and the other specified values are definitely correct. I assumed I had got the syntax wrong somewhere.

Thank you for your input but I tried this and got the same result.

Thank you. That worked perfectly.

The expression below is not returning the result I expect. =IIf(IsNull([MATERIAL]),"Select Material",([Height]*[Width]*[Length]/1000000000)*[QUANTITY]) Height = 140 Width = 150 Length = 1200 Quantity = 5 The result should be 0.126 but it's returning 10.2858 Any help appreciated. Thank you

Thank you for your input. I'm a bit of an Access novice. Could you tell me how to do this?

Hi How can I get my expressions to fire in real time as data is inputted into fields? Currently the results do not display unless I refresh or save. Thank you

Hi I am in the process of converting my quotes and invoicing system from Excel to Access. As I input data into my table fields in Excel the formulas make the calculations in real time and tell me the price for my products dependent on the length, width, height and material fields. I need to...

Re: (Solved)Field in my table won't take decimals Fixed it. I hadn't set the scale to 3. Thank you for your input. edited to show Solved in Title jdraw

How would I do that?

It is set to 'Decimal'

Hi I am trying to enter a value 103.234 into a table field. In design view I have: - Field Size @ Decimal - Format @ Standard - Decimal Places @ 3 When I input 103.234 into the field it defaults to 103.000 How can I get it to display 103.234? Thank you

Perfect, thank you very much.

Hi When I hit tab to cycle through my form controls instead of it jumping from one control to the adjacent one it jumps from far left to top to bottom right and all over the place. How can I set the order of the tab cycle to my preference? Thank you

Thank you for the original post and the amendment. It is now working perfectly. Much appreciated.

Hi I have a textbox that I wish to auto populate with data based on the value entered into an adjacent box. QUOTE_REF_1 is a four digit integer say "1287". When 1287 is entered into the QUOTE_REF_1 control I want Access to search my table tblCLIENT_DETAILS and find the 1287 row and return the...

Hi Plog Thank you very much, that worked perfectly. Do you happen to know why the order of the options in the combo box list is different to the order they are stored in the table? I would like them to be ordered the same if possible.

Hi I'm new to Access, intermediate with Excel. I am trying to get an Access form control combo box to display the values from a table field. In design view of the form I select the combo box and in the property sheet under the Data tab I hit the three dots button against Control Source and...

Ah, I see. I would like it to work in real time if possible, not after a button click. From the sound of it 'after update' might be the right one. How to I hook the code to this event? Thank you

Thanks Jdraw The only reason I'm switching to Access is because I need multiple users to be able to input data simultaneously which Excel won't allow without overwriting someone else's input. I realise they are different tools, I have watched a few tutorials to see if Access will meet my needs...