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...
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
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
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 =...
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"...
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.