Unanswered: How do I determine if file is available?
I’ve posted a similar question but…
What I’m looking for is a way to see if a file is available and if so, run a macro; otherwise, if not available, display a message stating such.
I want to click a button on a form that will run some routine to see if “z:\database\sidewalks.mdb” is available. If yes, then run a macro called “macTransfer”; if not available, display a message “Network file is not available”.