I have a Public Function that imports a file and then does several queries. It imports every file in a folder. I need a way for it to stop and notify the user if the append query fails, then ask the user to click ok to continue and it will then finish the rest of the files.
Here is what happens.
- I have code that imports all the files in a folder one at a time
- It imports each file and then runs several queries
- After the initial import I want to append the id key to a table to check for duplicates
- if a duplicate is found i want it to notify the user the file name that has failed
- Then allow the user to click ok and finish all the other files
I already have the import done and I have created a query that holds the import date and id of each record imported. I just need a way to check it for duplicates and if found stop the process for THAT ONE file and then when the user clicks ok start it up again and finish the rest of the files.
Thanks