Hi I have this form but i want to ammend it so when the user enters the data and clicks run I want the program to check for duplicate records using a combination of WeekDD (input field) and SiteDD (input field) and return a dialog box advising the user and asking if they want to overwrite the data. If the user clicks OK then the data is overwritten if they click cancel the operaiton is stopped.
Can anyone help with this?
Code so far
Many thanks
Please Login or Register to view this content.
It is probably easiest to use the COUNTIF worksheet function, though you could use the Find Method as well.
Please Login or Register to view this content.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks