File Search?

[option]

Hey Guys,

I'm trying to put a button on my form that will search a location for a .csv file. The file name is going to be "YYYYMMDD_NAME_DEPT".csv. Based on values from the main form, I need to search for said file based on the department. The department is tied to a supervisor in one of my tables. For example, if I were looking for all of the employees in my department, I would want to search for the files containing "yyymmdd_name_01". Any ideas?

 

[twoplustwo]

Are the file names stored in your db (in a table) or are you referencing actual physical files in a location?

 

[option]

we're referring to an actual file location, like "\\cnbase\home\---------" where the dashes would be the csv file.