In Access I'm writing some code that will export a report to PDF & also copy some other PDFs into a set folder prior to all these being merged. With this in mind I need to be able to check at that the various PDFs exist before moving onto the next VBA task.
I have no idea where to start on this, so does anybody have a piece of coding that will check the file exists, with the following outcomes:
If it does exist then move onto the next task
If it doesn't wait for it to exist & then move on.
If the file still doesn't exist after 10 Seconds then an error message needs to be displayed.