Hi
My userform adds,finds and updates entries to a database. But when it comes to updating it ends up duplicating the entry its meant to update.
Please find attached the workbook
Hi
My userform adds,finds and updates entries to a database. But when it comes to updating it ends up duplicating the entry its meant to update.
Please find attached the workbook
Hello rayexcel,
To avoid duplicate entries, you need to use a unique record identifier and check if it exists before you transfer the data from the UserForm to the worksheet.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
How would i go about doing that? And how would that work if I am meant to update the entry?
would the code provided by Jindon on this forum if adapted work?
http://www.ozgrid.com/forum/showthread.php?t=157244
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks