Search results

Thank you. I tried to use DSum and DLookup. This is what I did, Dim dblPower As Double varPower = DLookup("RatedPower", "DeviceRatedPowerQ") Dim dblWeight As Double varWeight = DLookup("ComponentWeight", "DeviceWeightQ") Dim dblCost As Double dblCost = DSum("[EuroCost]"...

Yes. When I click the button three new rows of data are added to the table when I want the information from all three of these commands added into one new row.

I want to run multiple SQL commands on click of a button. I have these three command, CurrentDb.Execute "INSERT INTO UserMadeDeviceT(Product, ORESector) " & _ " VALUES ('" & Me.D_NewDeviceTxt & "', '" & Me.D_ORECmb & "')" CurrentDb.Execute "INSERT INTO...

Thank you. That did the trick. I had a select statement too but my one had the same error. This fixed it though.

I have one more question. Within the same subroutine I am trying to implement an if statement but I get the error "function call on left-hand side of assignment must return variant or object if statement". This is my code, If Me.C_ComponentCmb.Text = "Shell" Then If...

That worked perfectly, thank you.

I'm pretty new to Access so any help would be great

As it stands this is what I am trying to do. I'm trying to read a value from a combo box in a form and then choose the price corresponding to this value from a table so I can then do a calculation based on this price. This is my code, Dim materialCost As Double Dim strSQL As String Dim rst As...