Search results

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

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

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 &...

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

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

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

:p Well noted! vbaInet :D

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

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

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

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

Yes, I did Thank you & Best regards, ASK

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

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

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

Dear Mr. GinaWhipp, Thank you so much. let me try it. Thank you & Best regards, ASK

Dears, Thanks for quick help & attention. I'm sorry for complex my logic and words. The primary key is Guide ID, did hide on the form(capture), a table named as tbl_gui. Guide code is lookup from another table, named as tbl_m_gui. And File number is added from another table and locked on form...

Dear All, I'd like to say Thank you for you kind attentions. Print screen is not ok. So, I attached for Capture1 & 2 instead of print screen. Could you please kindly see the attached ? Capture1. Capture2. Thank you & Best regards, ASK

Dear All Seniors and Masters, I've a Sub form as datasheet view/grid. Could you please kindly see my Capture1 & Capture2. I'd like to prevent for duplicate time/date for same GuideCode. How can i prevent for those during the entry time or save time ? Is it possible ? :confused: Thank you so...

Thanks, Paul