[Solved] Simple VBA Select Query

Here is one way to do it: sSQL = “SELECT Variable FROM GroupTable ” Set rs = CurrentDb.OpenRecordset(sSQL) On Error GoTo resultsetError dbValue = rs!Variable MsgBox dbValue, vbOKOnly, “RS VALUE” resultsetError: MsgBox “Error Retrieving value from database”,VbOkOnly,”Database Error” solved Simple VBA Select Query

[Solved] nested if-statement [closed]

SELECT DISTINCT IIf(RIGHT(TBL_PO_SERVICE_ORDER_INPUT.PO_NUMBER,1)=’H’ And SYSADM_OPERATION.SERVICE_ID=’HEAT TREAT’,SYSADM_OPERATION.SERVICE_ID,IIf(RIGHT(TBL_PO_SERVICE_ORDER_INPUT.PO_NUMBER,1)=’C’ And SYSADM_OPERATION.SERVICE_ID=’CLOTHING’ Or SYSADM_OPERATION.SERVICE_ID=’ZINC PLATING’,SYSADM_OPERATION.SERVICE_ID,IIf(RIGHT(TBL_PO_SERVICE_ORDER_INPUT.PO_NUMBER,1)=’G’ And SYSADM_OPERATION.SERVICE_ID=’GRINDING’,SYSADM_OPERATION.SERVICE_ID,IIf(RIGHT(TBL_PO_SERVICE_ORDER_INPUT.PO_NUMBER,1)<>’G’ Or RIGHT(TBL_PO_SERVICE_ORDER_INPUT.PO_NUMBER,1)<>’H’ Or RIGHT(TBL_PO_SERVICE_ORDER_INPUT.PO_NUMBER,1)<>’C’ And SYSADM_OPERATION.SERVICE_ID Is Not Null,SYSADM_OPERATION.SERVICE_ID, IIf(SYSADM_OPERATION.SERVICE_ID<>’HEAT TREAT’ And SYSADM_OPERATION.SERVICE_ID<>’COATING’ And SYSADM_OPERATION.SERVICE_ID<>’ZINC PLATING’ And SYSADM_OPERATION.SERVICE_ID<>’GRINDING’,SYSADM_OPERATION.SERVICE_ID))))) FROM SYSADM_OPERATION INNER JOIN TBL_PO_SERVICE_ORDER_INPUT ON ([TBL_PO_SERVICE_ORDER_INPUT].WO_LOT_ID=[SYSADM_OPERATION].WORKORDER_LOT_ID) AND ([TBL_PO_SERVICE_ORDER_INPUT].WO_BASE_ID=[SYSADM_OPERATION].WORKORDER_BASE_ID); 0 solved nested if-statement [closed]

[Solved] DBgrid not showing changes and show error when to try update – Insufficient key column information for updating or refreshing [closed]

My guess is that: does not have the recent changes is because the data has not been posted. And cannot be from what I can see. You’re trying to insert and update tuples from two tables, but you fetched only a foreign key of a detail table. Imagine, that you’d like to update this resultset … Read more