File Exist

[sahersite]

What code to write to know if a file exist or not, in another words, search or find file in your local drive at certain folder and return you null or value.
please help
Thanks in advance,

 

[WayneRyan]

S,

Welcome.

The easiest way to check for the presence of a file is to use the Dir()
command.

See the Access Help Files, it should be pretty straightforward.

hth,
Wayne

 

[IR_Moon]

Try the post at http://www.access-programmers.co.uk/forums/showthread.php?t=118532&highlight=file+exists also. Thats where I found the info I was looking for