Macro button to search directory

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want a command button within a form that will search a specific directory
on my hard drive for a .jpg file. The macro should use the field "Type" from
the form and find the .jpg file that has the same name as the current value
"Type"

Thanks,
 
Cam,

Search for the file,... and then what? You can use the Dir() function
in the Condition of a macro to see if the file exists - is that your
objective?
 
Back
Top