Search results

Attaching the error snapshot

HI! i am trying to open another form from main form on double click but getting below error Syntax error in string in query expression 'MICR_ndt = 'xxxxx' Private Sub lstResults_DblClick(Cancel As Integer) On Error GoTo Err_1stResults_DblClick Dim IDnr As String Dim stDocName As String...

Thank you both for your time and advice. I will try and implement that. i have already marked this thread as solved. Thank you once again

Hi! i am bit confused, Do i need to add anything more to the code. Also, can these be applied with the same logic to delete the data from the respective tables based on date criteria. (business start date & business end date)

Thanks theDBGuy & Gasman for your time. Dear Gasman, i dont really have the answer to your query. I have decided to put date prompt to all my queries inorder to avoid the error. Just one last thing. can i apply the same logic for deleting the data from the respective tables based on date...

Thank you both theDBguy & Gasman for so much insight. just wanted to know that theDBguy last updated db was allowing me to export the excel without any error. However, it exports as-is the entire records from the queries/tables to excel except the query which has the date parameter set. thanks

Apologies to all, couldn't respond earlier. HI! theDBguy, i have visited you site. amazing work, honesty, i have not taken the effort to understand how i could apply the code in my project. long way to go for me to understand. Thanks again for sharing the link, it will help me in my future...

Thanks everyone. I have attached lower version db. Hope this helps

Hi! all I have form linked to a table which has tables/queries listed in it. Its on-click event exports the data in excel format. No problem here. The issue is when the query has parameter with date prompt the on-click event fails. Below is the error msg. "Run-time error 3061" Too few...

thanks Arnelgp for your kind support. I have tweaked the code to fit my project. Thanks I will close the thread now as solved

thank you Arnelgp. Will try the code. Thank you once again for all the help and guidance.

Thank you Arnelgp, yes this is what i wanted to avoid user selecting the reject reason and if this could be automated. Thank you very much. just one final if i can add the date to the validation. I am requesting this so i can use the code for my other db. I have my previous projects however...

Thank you Arnelgp, its perfect what i wanted. Can i request one more time. Is is possible to update the Remark field based on the popup msg. If there is mis-match in more than one then field then update as Multiple Mis-Match, else the respective Mis-Match (MICR or CreditAC or Amount) and...

Thanks Arnelgp, it prompts popup incase of incorrect. But it does not go to the next row for scanning next chq. The form freezes and when I hit x to close form it ask me " You cant save the record at this time' When I say yes it saves and then able to open the firm again to scan next one...

Hi Arnlegp, after Micr Scan it displays Match if its matching. Can this be stopped. Also if it's not matching popup msg incorrect Micr, but it does not allow me to move forward to CreditAC. It should popup but allow me to move forward to CreditAC and Amount. Can the status be updated just...

Thanks Arnlegp. I tested it and it's fine. However is it possible to prompt popup 1st if Micr scan is mismatch. If not then it moves to Credit AC. Again if it is incorrect to prompt user, if not then move to Amount and then update Status as Match or Unmatch and set focus to next row MicrScan...

Thanks theDBguy i have changed the Dlookup code and it now pops for duplicate MICR_Scan. How do i validate CreditAC & Amount field next.? I am not sure where to insert these in the existing code.

HI! Arnegp, i have posted a thread for help in Dlookup to validate 3 fields. Can you help me.

HI! This has been raised numerous time with solutions, but i am still confused on how to apply to my db. I am looking to validate my input based on 3 criteria's. I one of them don't match the status flag should be "UnMatch" To give brief background of my db: my db has "tbl_Master" which will...

HI! Arnelgp, again apologies for the confusion. I think i have got what i wanted. Thank you for prompt support whenever required. God bless you