Search results

SELECT Tmain.RiskID, Tmain.isActive, Tmain.RiskCode, Min(Tactions.DueDate) AS MinOfDueDate, Tmain.location FROM Tmain INNER JOIN Tactions ON Tmain.RiskID = Tactions.RiskID GROUP BY Tmain.RiskID, Tmain.isActive, Tmain.RiskCode, Tmain.location;

yeap. ="RiskID In(SELECT RiskID FROM QddallA WHERE Site='site1' and status='completed')" works just fine idk i guess im using your code btw lol

didn't any impact on my another textbox where i have this event with "where condition" u mean if i run this even i mean if i dbl click it ? it should open for me a list of records which fit to my condition

sure, its

hey guys ! i have a query where i have value 0 in RiskCode filed and i have a textbox in form and in dbl click even i have ="RiskID In(SELECT RiskID FROM Qddall WHERE riskcode=0)" and when i run dbl click event - it shows me empty list. i even tried to call to table directly [RiskCode]=0...

thank you very much ! it works now !

yeah, my bad. i have a textbox that shows me a number according to countrol source expression. and i need to find out how could i exclude criteria (text) in control source expression and in dbl click event as well

hey guys, im stuck at very simple step i have a bextbox that shows me a number accoring control sorce =IIf(DCount("site";"QddallA";"site='Site1' and status not in = 'Rejected' and duedate<completedDate")=0;"";DCount("site";"QddallA";"site='Site1' and status not in = 'Rejected' and...

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.