Search results

Hi I tried to put the code in but " If Me!CheckBox1 = True Then Me!TextBox1 = "00"" this part shows up in red.. (I changed the name to the corresponding filed in my database).. :confused::(

Hi thanks so much! I think it should work but it says exceeded maximum connect time, you are being logged off. this also happened when I put criteria in the "or"... :( I guess this query just takes too much time

I don't know how this will work cuz my database has a ODBC connection in the query to make a new table. You don't have that connection so you won't be able to test whether it works or not.:( I just left the only query in there. :D

Thanks for your answer!! However it says compile error: Syntax error. :(

currently its SELECT "ICLOR" AS Source, O858IA_VWRDCAM.NVP_BID_NR, O858IA_VWRDCAM.SRC_CNY_CD, O858IA_VWRDCAM.PRC_JOB_LST_RUN_DT, O858IA_VWRDCAM.COS_CCL_MTH_TYP_CD, O858IA_VWRDCAM.PKG_CHA_TYP_CD, O858IA_VWRDCAM.SVC_TYP_CD, O858IA_VWRDCAM.MVM_DRC_CD, O858IA_VWRDCAM.ORG_CNY_IAT_CD...

Thanks for your reply! Do I put the below as the criteria in the query? I tried and it says undefined where. :confused::DTHANKS SO MUCH AGAIN!

Thanks for your reply! Sounds like a solution! Just need to figure out how to do the after update since I don't understand code at all :(

I see but I want to make it possible to choose both :confused::confused:

Hi Thanks for your reply. I don't understand what does this code do? Will I be able to query both values if they check both? Thanks:D

I think in access I can only use IFF? Also the problem with if statement is the return value cannot be 2 value "00" and "01". :confused:

Yes they are independent I tried " and" and " or" both don't work either. 😥how can I make it work :( thanks for replying

Hello everyone. I posted in the form section but the problem is not solved. So I have 2 checkboxs in a form. Future cost and LRM cost. When future cost is checked, I want the criteria in my make table query to be 00, when LRM cost checked, I want the criteria to be 01. But the problem is when...

Hello again, Now my checkbox works. IIf([Forms]![James Form]![Future cost]=True And [forms]![James Form]![LRM cost]=False,"00",IIf([Forms]![James Form]![Future cost]=False And [forms]![James Form]![LRM cost]=True,"01",IIf([Forms]![James Form]![Future cost]=True And [forms]![James Form]![LRM...

Hello Dan, What I have problem with is the criteria part in the query, what should I put for the iif statement? Future cost checkbox and marginal cost checkbox. If future cost is checked, then I want 00 as criteria for the field cost type in the query, if marginal is checked then 01. If both...

Thanks!! I tried using combo box now and it works. But I still need to be able to choose 2 options at the same time! So I am trying checkbox again.. :)

Oh I do. It's a query that has a lot of other fields. SELECT O858IA_VWRDCAM.NVP_BID_NR, O858IA_VWRDCAM.SRC_CNY_CD, O858IA_VWRDCAM.PRC_JOB_LST_RUN_DT, O858IA_VWRDCAM.COS_CCL_MTH_TYP_CD, O858IA_VWRDCAM.PKG_CHA_TYP_CD, O858IA_VWRDCAM.SVC_TYP_CD, O858IA_VWRDCAM.MVM_DRC_CD...

Hi I just have the checkbox right now. I do not understand VBA at all :(

Hello All! I am new to access forms. I am trying to use the 2 checkboxs for my make table query. Future cost checkbox and marginal cost checkbox. If future cost is checked, then I want 00 as criteria for the field cost type in the query, if marginal is checked then 01. If both checked, then I...