Search results

Once again, Allen Browne had an excellent solution. Found the link on another forum. Don't have 10 posts yet, so you'll have to type this in your browser by hand. allenbrowne.com *slash* ser-59 *dot* html -Cevin

We are migrating from Access 2000 to Access 2010, primarily because of how easy it is to export pdf files of everything we print, but now the Application.FileSearch line returns a run-time error '2455'. From what I can tell, it is no longer supported with Access 2010, but I am having trouble...

New problem. We are migrating to Access 2010, primarily because of how easy it is to export pdf files of everything we print, but now the Application.FileSearch line returns a run-time error '2455'. From what I can tell, it is no longer supported with Access 2010, but I am having trouble...

Solved it. Each constant ("msoLastModified...") can be replaced by its numeric equivalent, and therefore changed based on the combo box like I described. By changing the hard coding and running a line that said: Debug.Print "LastModified = " & .LastModified I was able to figure out the...

Sorry, I tried to streamline it and missed the "With" before the "Application.FileSearch". The code stops running at the .LastModified line, before it ever gets to the .Execute line. What I don't know is why the .LastModified line won't accept a variable for its input (".LastModified =...

Using MS-Access 2000, I have a form which searches a specified directory for text files (hyphen delineated) which are then imported into a table so that order information can be extracted. Dim stFileName As String Dim stDateFilter As String Dim Folder As String...