Search results

Thanks Gasman, but now i have given up. i put below code but in IW i am getting result as False strDate = Me.Parent!PDCDueDate strCriteria = "MICR_ndt = '" & strMIRC & "'" & PDC_dueDate = strDate If DCount("1", "tbl_Master", strCriteria) < 1 Then Debug.Print strCriteria The data entered...

Well i too dont want to ask for help, but if you think that you can recall the function you mentioned then do post it back. It will be great help. Well i am trying to learn but at the movement i have darkness in front of me, not sure if there is finish line in front or back of me.

NO, it should be with code only without the date

hI! pls check the below code and the result in IW If DCount("1", "tbl_Master", "MICR_ndt = '" & strCriteria & "'" = "' strdate = DateValue('" & Me.PDC_dueDate) < 1 Then ? strcriteria MICR_ndt = '0001298020207250293177718'21/10/2019 but still getting popup message. the above MICR_ndt is...

Thanks Gasman, but still i m not clear how to check this in immediate window.

Thanks i have tried to learn few vba codes earlier, but it will take me longer than expected. i have 3 criteria MICR_ndt is one of them. initially i did not put date as criteria

HI! Gasman, my DB is already posted in post #12 by arnelgp. Hope this helps. I just tried to add the 4th validation (date) code but failed in process

? strcriteria False ? dcount("*","tbl_Master", strcriteria) 10

it shows just "False"

HI! Gasman, i am not getting any error, but a popup msg Invalid Date with status "UnMatch". But the data is correct, so it should give me status as "Match" in the immediate window i am getting as False i have inserted the code you provided and below is my full code on MICR_Scan before update...

HI! Arnelgp, i had to repost this message as i have another challenge. It works fine except in one scenario where if the user scans a cheque for any other then the date mentioned in the main form, it still accepts. I wanted the 4th criteria to check the date (PDC_dueDate) before accepting as...

same way the 1stResult has ChqNos; RoutNos & DebitNos displays the possible match

Thanks isladogs for the updated db. I just realized, i will not be able to amend the details which don't match as only match items get populated on double click. Is there a way to bring the unmatch item on double click

Thanks isladogs, i tried your last code. it gave me blank records. vba_php, The code provided by you gets me the result. Yes, the first details is not in the table so gives a blank record. Did not realize this. Thank you both for the quick help. God bless

haha, time difference GMT +4 hours. i did change to MICR same result in my post #11. i changed to MICRId but gets error "Data Type mismatch in criteria expression"

i have changed the string to MICR Now it opens the blank form without any error message.

If you can have a look at it. I am not sure if the string is Me.MICR_m

i tried the other code but still same result. i have attached my db

yes, i updated your below code and after that it gave me message stLinkCriteria = "[MICR_ndt] = '" & IDnr & "'"

message edited Thanks, it opens the form but it gives me popup msg "Enter Parameter Value" MICR_ndt and then opens the form, with no details.