Search results

Hi Bob and Rainlover I have used the code which was posted earlier... and it did work perfectly well. However i wanted to take to next stage where the database after giving a message of duplicate entry I want the access to give me notification as: "Do you want to edit the duplicate entry or...

Hi Bob , Paul and Rainlover Sorry have been studying which code can be used to solve this hence did not reply. Please see the code which i have used but it doesnt work.. :-( I know it may look a bit haywire but i read books and have tried getting this as i am coding nearly after a decade...

Hi Bob for the above query i figured it out n its working fine... but then it does not allow me to view/edit if duplicate entry exits. Example If the entry is duplicate then View / Edit / Add new button should show and it should do that operation... Can you help me with this??? Is that...

Hi Bob Now i am running into a silly error.. it does not involve coding, however I am sure I am making some mistake. Ok my question is when i enter data in form and save and then go to next form some fields such as age/occupation which i selected for the first customer is visible and if i...

Dear Bob thanks a ton.... You are a true genius.. Wow.. the code that you suggested it did work... yeppieee... it working fine.... Thank you thank you thank you.. cant thank you enough.... :-) Other team members thank you for your suggestions as well.. However Bob's coding worked...

Hi Paul Its getting complicated for me.. Not sure what I am suppose to do next.. sorry to bother u so much but unable to find solution... Grateful if you could help me in solving this..

Hi Paul I cannot thank you enough for guiding me in this...:-) very grateful to you... I used Dcount and coding as suggested, however I am still facing errors as given below It gives an error as "you cancelled the previous operation" Would you be able to let me know why this occurs... Many...

Hi Paul My code is as follows: Private Sub Ctl_Lname_BeforeUpdate(Cancel As Integer) Dim LName As Variant LName = DLookup("[txtLName]", "[txtLName]= '" & Me![LName] & "'" & " And " & "[txtFName] = " & Me![FName]) If Not IsNull(LName) Then Beep MsgBox "This name already exists in the...

Hi Bob I have added the files for your reference. Do let me know how to proceed.. Please help me with coding while entering first name and last name.. basically it should prompt the user that the name is already existing, hence the user has 3 choices - to check if the data is same or not...

Hi Team I am facing a problem - I want to stop duplicate entries from being entered on form. I have read through the thread , however I am totally confused as it seemed to be v high level complex queries. I am looking at: Preventing duplicate entries to be entered It should show an error...