Search results

Hi I have a table called tblPMDP PMDPID (PK autonumber) PMDID (FK) CostTypeID (Number) CostType ProcessPrice UNID (Number) What I want to do is to get: PMDID & CostTypeID into UNID as soon as the table receives both values By combining these 2 values I get a unique...

Anyone, any ideas?

The table tblPMDP is: PMDPID - PK PMID - FK CostTypeID (Number) ProcessPrice Currency some data: PMDID - 1, 2, 3, 4, 5, each refers to everytime the form is used to create a price quote. for every costypeID (There are 19 only) 1-19 selected by the user it refers to the PMDID so...

I am sorry I am a total noob at this. I saw this on the net and wanted to modify it for my own use. I have tried looking at if else statments but have not got very far. If I can explain what I want to do: I want to insert two values into a tble called tblPMDP I have an append query but...

Hi All I am new and learning. Please help me with this code: MsgBox "Please Click Once Only" If ("CostTypeID", "qryCompLensPrices", "PMDID='tblPMDP.PMDID'") = ("CostTypeID", "tblPMDP", "PMDID") Then MsgBox "The Total Price has been Calculated" Else DoCmd.OpenQuery "qryAddCompCosts" End If...