Check if File exists

G

Guest

Hy,

is there a easy command, to check if a file exists?

Reason: The Field "File" is filled by external DB Update (for example
"C:\Test.pdf").Before a users uses the Field Value for further working,
Access must check, if the file realy exists. If not, a message box should
appear.

Any idea about the file command?

Greetings,

Manuel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
Folder Exists 2
TransferDatabase to an EXISTING table 3
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Checking to see if a file exists. 3
Check if an external file exists 3
check file exists 3
Importing and modifying exisiting primary key data 3

Top