Search results

huhu... how come in charity u will lose job ?!!

oh great. but am i need to open the query everytime ? how to make the query auto run ? TQ

i try and follow everything from sample that wayne gave. but it not working for mine, subform not update. i hope any expert will help me to find out what is my mistake. attached my test program. i want to update the subform list by selecting Date from form, table use - tblDailyDetails_Deliver...

oh great, this is what im looking for !! cheers

done.. but at If.. Else expression have error ive change it to this code Dim strRS As String Dim rst As DAO.Recordset strRS = " Select * from [t_CC] WHERE [CC] ='" & Me.CC & "' " Set rst = CurrentDb.OpenRecordset(strRS) If Forms!f_Main.Coverage =...

not working at all Private Sub Command51_Click() Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset("Select * from [t_CC] where [CC] = """ & Forms!f_Main.CC & """") If Forms!f_Main.Coverage = "Comprehensive" Then Forms!f_Main.BasicPremium =...

wonder why no value at BasicPremium after i change value at CC.. even i make command button, it not work either.. it work fine at NCD combobox.. help me plz...

thanks, it works.. :)

do u mean bound textboxt in report with this? thanks :)

sorry if it seems rude.. but dcan u explain it ?

stil not working... it not calculate at all help me plz

wonder y use rst!Comp and NoComp? i think u not lok at it carefully... that is not a fix value, it depand on cc value..

as a title, how? coz i want make report based on value that calculated at form where data value is unbound.. i use ms access 2K i make calculation on my form.. and ofcoz the result is in unbound textbox.. but when i try to make report of the result, it need table or query to make it.. so i...

yup u right 1st conditoin is either comprehensive or 3rd party and i make "cc" value thingy wit combobox

Case.. hmmm.. but is it need to make new module or i can type directly there?

Help plz If Forms!f_Main.Coverage = "Comprehensive" Then If Forms!f_Main.CC = "0 - 1400 cc" Then Forms!f_Main.BasiPremium = (Forms!f_Main.SumInsured - 1000) * 0.026 + 225.2 ElseIf Forms!f_Main.CC = "1401 - 1650 cc" Then Forms!f_Main.BasicPremium = (Forms!f_Main.SumInsured...

how to make calculation in form accept null value when using Iif in query? like this Extra1: Iif([company]=-1,50) i use company as check box.. when i check it, 50 appear at texbox at form..then i click at calculate button (to calculate quotation) have no prob... but when check box not...

how do i make 2nd combobox list based on 1st combobox list, mean if i choose A at 1st combobox, only A1-A5 option appear, and when i select B at 1st combobox, only B1-B8 appear to select at 2nd combobox.. TQ

i need to update some textbox value when insert some value at another textbox.. like when i add 3 at 1st textbox, 2nd text box will calculate it auto matically wit this formula, 2ndtextbox = 1sttextbox - 1 ... so where should i type ? query? how? default value? if need to wrte code, which 1 i...

really? TQ just curious.. not try it yet