Comments by Venu Gopal Mulavana Kayamkulam

Venu Gopal Mulavana Kayamkulam 5-Jan-22 1:28am View

done with as per u mentioned string.Replace... thank you very much (Y)

Venu Gopal Mulavana Kayamkulam 4-Jan-22 7:53am View

Its remains as the same text. I need in the result, instead of Trim(Me.txtClientName.Text) ther should b the input value of Me.txtClientName.Text. Its a textbox in the form and that has a value also.

Venu Gopal Mulavana Kayamkulam 9-Oct-20 12:55pm View

+5

Venu Gopal Mulavana Kayamkulam 21-Aug-20 13:21pm View

Deleted

:D

Venu Gopal Mulavana Kayamkulam 21-Aug-20 13:21pm View

Deleted

:D

Venu Gopal Mulavana Kayamkulam 21-Aug-20 13:00pm View

Done as below!!!! thanks a lot from Kerala... (Y) :)

DataFilterQuery = DataFilterQuery1 + " Union " + DataFilterQuery2 + " Union " + DataFilterQuery3 + " Union " + DataFilterQuery4 _
+ " Union " + DataFilterQuery5 + " Union " + DataFilterQuery6 + " Union " + DataFilterQuery7 + " Union " + DataFilterQuery8 _
+ " Union " + DataFilterQuery9 + " Union " + DataFilterQuery10

Venu Gopal Mulavana Kayamkulam 21-Aug-20 12:58pm View

yes. access does't support multiple result set. Now I used Union in the query as per the Solution 2. anyway..... thanks a lot 2 help me.. seeks ur support in future also.

Venu Gopal Mulavana Kayamkulam 27-Jul-20 15:28pm View

Both 2 answers working great.. Thanks...

Venu Gopal Mulavana Kayamkulam 27-Jul-20 15:27pm View

Deleted

"Select A.pledgeno, A.pledgedate, A.pawnername, A.loanamount, " & _
"A.totalweight From (partpayment A Inner Join pledger B On A.pledgeno=B.pledgeno) " & "Where A.ppdate >= @Me.dtpAccountFrom.Value.Date " & _
"And A.ppdate <= @Me.dtpAccountTo.Value.Date And B.redeemed=0 Order By A.pledgedate, A.pledgeno"

Its working..

Venu Gopal Mulavana Kayamkulam 27-Jul-20 15:21pm View

I put this "And pledger.redeemed = 0" in the Where clause...
Thank you... (Y)

Venu Gopal Mulavana Kayamkulam 27-Jul-20 13:13pm View

"And pledger.redeemed = 0"
is showing "Syntax error in JOIN operation." when I remove that, there is no error.
Full query is below, I have tried.

DataFilterQuery = "Select pp.pledgedate As PDATE, pp.pledgeno As REFNO, " & _
"pp.pawnername As PAWNER, pp.loanamount as AMOUNT, pp.totalweight As WEIGHT " & _
"From partpayment pp Inner Join pledger p On " & _
"pp.pledgeno = p.pledgeno And pledger.redeemed=0 " & _
"Where pp.ppdate >= @Me.dtpAccountFrom.Value.Date And " & _
"pp.ppdate <= @Me.dtpAccountTo.Value.Date Order By pp.pledgedate, pp.pledgeno"

Venu Gopal Mulavana Kayamkulam 7-May-20 13:10pm View

Namasthe Richard.. as per ur answer, I have done it by UNION.
Thank you so much. :)

Venu Gopal Mulavana Kayamkulam 30-May-16 14:57pm View

U r right.... Focus is not restoring to the previously focused control on first form, when I activate that form (first form) again.

Comments by Venu Gopal Mulavana Kayamkulam (Top 13 by date)