Recent content by ASK

  1. A

    Prevent duplicate code is not working as well

    Hi VbaInet, I test it on frmGAssign form, it is ok. but when I test on navigation form, It's not working, VGAssign = Subform (child2) frmGAssgin = Navigation Subform (child1) Navigation form = Welcome Form (parent) query name = qrygui query is following. SQL view for above query SELECT...
  2. A

    Prevent duplicate code is not working as well

    Well noted and Thanks for your advise. I will test it in the query first. Thanks & Best regards,
  3. A

    Prevent duplicate code is not working as well

    Thanks for reply on my post, spikepl & vbaInet. Thanks for your kind understanding on me & attention on my posts, VbaInet. I am apologize, If my English grammar usage was wrong. Actually, I really don't know exactly where I change and update in my code with WHERE caluse.:D But, Let me try &...
  4. A

    Prevent duplicate code is not working as well

    Dear All Seniors & Masters, I'm a beginner at VBA. This current code was prevented/checked when updated on any data even data entry has no duplicates. If data entry is put continuous/new entry, it's ok, code is working. If I was updated on any old data, Msgbox shown duplicate found. So I can...
  5. A

    Prevent for duplicate data (VBA MS Access)

    Thanks Gina!! I thought that you have forgotten me :D. You are the best. Have a great Thursday ! Thank you & Best regards, ASK
  6. A

    Prevent for duplicate data (VBA MS Access)

    Thanks for checking my DB, Gina. I have a another inserting criteria, named as dupResults. It's added in frmGui form. If my answer does not meet with your question, please let me know. Thank you & best regards, ASK
  7. A

    Prevent for duplicate data (VBA MS Access)

    :p Well noted! vbaInet :D
  8. A

    Prevent for duplicate data (VBA MS Access)

    Dear Mr, Could you please kindly check the attached & advice me how can I fix for it ? And also in frmGui form, Duplicate Msgbox was shown as wrongly. user name: opt (or) admin pass: opt123 (or) admin123 Thank you & Best regards, ASK
  9. A

    Prevent for duplicate data (VBA MS Access)

    Yes, Mr. Can I send the db file to your private email and could you please check me for that ? or Should I attach here ? I am sorry for disturbing you. Thank you & Best regards, ASK
  10. A

    Prevent for duplicate data (VBA MS Access)

    It ask enter parameter value. Could you please kindly see the attached files? Thank you & Best regards, ASK
  11. A

    Prevent for duplicate data (VBA MS Access)

    Thanks for your help. But It's not working, then It's created auto bracket in Forms , After I replaced that in query. <[Forms]![Navigation Form]![frmGui].[Form]![txtEndResult2] >[Forms]![Navigation Form]![frmGui].[Form]![txtStartResult2] Thank you & Best regards, ASK
  12. A

    Prevent for duplicate data (VBA MS Access)

    Yes, I did Thank you & Best regards, ASK
  13. A

    Prevent for duplicate data (VBA MS Access)

    Navigation form name = [Navigation Form] MainFormname,frmGui = [frmGui] / navigationbutton name = [subnav.frmGui] text on frmGui = [txtStartResult2] & [txtEndResult2] checking query/[dupResults] query is on [frmGui] form main query is checking from outside query namd as [qryTest] when i check...
  14. A

    Prevent for duplicate data (VBA MS Access)

    No, Sir. I didn't change controls the code ref. Could you please check me for wrong criteria ? And let me know how to change after placed on the Navigation Form. 1 <[Forms]![frmGui]![txtEndResult2] 2 >[Forms]![frmGui]![txtStartResult2] Thank you & Best regards, ASK
  15. A

    Prevent for duplicate data (VBA MS Access)

    Testing is ok that from your shared link, Finally, I got it. Thanks again for your help, Mr. But I have a another problem. Could you teach & share me how can i do it ? It is working on form(named as frmGui). But when I add in Navigation form for frmGui, It main query and another query in the...
See more
Back
Top Bottom