Search results

it worked ! awesome ! thank u , Sir ! :) much appriciated for your help !

hello everyone ! i have a double click event where it opens up for me a master list. i tried this one ="RiskID In(SELECT RiskID FROM QddallA WHERE Site='site1' and duedate<date() and isactive=false and status='In progress' or 'New' and duedate<date() and isactive=false)" and this one ="RiskID...

@plog , @cheekybuddha , @Gasman , @The_Doc_Man , @tvanstiphout , @Pat Hartman , @GPGeorge , @arnelgp , @CJ_London , @nector thank u very much guys ! appriciate your help and patience towards noob here like me ! glad to be here. best commuity !

i just made this textbox countro sorce that field in table i created where 25 autonumbers ID (with PK) = sov \ likehood indicator then i just added in my countiniusl form in SQL i saw a new code FROM TriskSL INNER JOIN Tmain ON TriskSL.riskSLid = Tmain.RiskCode; and now it works !!!!! look

YEAH ! i made it ! u guys helped me a lot. it was so easy actually

i have already data in sql, as it needs to display data in continius form. how can i combine them ? i mean how can i make them work together ? i renamed FriskSLcode to TriskSLcode as its a table not a form. sorry,

i added a new table with 25 IDs with primary keys and link this table with my MainTable. so now how do u make riskSLcode to be shown in my countiniusly form. i think it should be somehting with =riskID = " & risk

now it works, but active record's data populated to others.

its

i used Private Sub Form_Current() Select Case [RiskCode] Case 1: Me.txtb = "1A" Case 2: Me.txtb = "1B" Case 3: Me.txtb = "1C" Case 4: Me.txtb = "2A" Case 5: Me.txtb = "2B" Case 6: Me.txtb = "2C" Case 7: Me.txtb = "3A" Case 8: Me.txtb = "1D" Case 9: Me.txtb =...

by cells i meant textbox with dcount in it :) sorry

i dont know even what that it .. so :) my db will be located in local storage and up to 50 ppl will be using it via local network. 1-2 might be simonteniulsly.

i have an error i guess. not sure what i did wrong Private Sub Form_Current() Select Case [RiskCode] Case 1: txtb = "1A" Case 2: txtb = "1B" Case 3: txtb = "1C" Case 4: txtb = "2A" Case 5: txtb = "2B" Case 6: txtb = "2C" Case 7: txtb = "3A" Case 8: txtb = "1D"...

damn, and i just love my work. and yours as well as u guys helped me a lot with my project

and i have almost finished db (just polishing before it goes live) and there are tons of dcount and dbl click events. every cells has them

i have 25 bottons and user should just click on one of these while registring new risk. and I made info from buttons goes to Tmain!RiskCode , but not with Sivernity Likehood ID (like 1A or 2D) but numbers from 1 to 25. why ? cause i knew i will need tons of calculations later like IIF( bla...

i have 4 records and everyone of them has riskcode value. i already faced with this problem a month ago , when i put long code to control source. access doesn't like it.

hmm.. yeah, might be the case. thank you.

hey guys, i face with another problem. in my countinius form i have riskcode textbox bound to Tmain!Riskcode. Its numeric only from 1 to 25. every code has sovernity \ likehood code (identifier) for example riskcode 1 = 1A .... riskcode 7 = 3A .... i put unbound textbox that should display this...

thank you for suggestion. i'll try to find something for me next week. i appriciated your help !