confirming a file based on only part of the name then printing it

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

Guest

What I am trying to do is print a file. In the application I need to confirm
the existance of a file give only part of the file name. Then I need to print
the file. This is from within MS Access.

Thanks in advace.
 
tekkie said:
What I am trying to do is print a file. In the application I need to confirm
the existance of a file give only part of the file name. Then I need to print
the file. This is from within MS Access.
Click to expand...


Use the Dir function to get the full name of the file(s)
that match your partial name (no idea what you might want to
do if there's more than one).

If Dir("path\xxx*") = "" Then
'No matching file in path
Else
'at least one file found
End If
 
Back
Top