Sorting by LastModified in FileSearch Execute

S

Sandy

When I use the application.filesearch in Module and
include the
..Execute msoSortByLastModified, msoSortOrderDescending,
True

It does not return the files in Descending order of date
modified field. However, if I use the
msoSortOrderFileName instead, it returns the file in the
descending order of file names.

Is there a bug in Access 97 which is doing this? Does
anyone know any solution to this problem?
Help. Thanks
 
B

Bryan Reich [MSFT]

Sandy,
Yes, apparently this was a known issue in Access 97 VBA and it appears it
has been fixed in later versions. According to some of the details I'm
seeing, it apparently works if you sort by a different field first, and then
sort by this constant. It's an unusual bug for sure, but like I said, I
believe it was fixed in 2000 and beyond. Try the sort on a different one,
and then on this one, and see if that isn't a feasible work around for you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import only most recent file using FileSearch & LastModified 1
Two Questions: FileSearch & Excel Instance 5
Need help modifying code 0
How to make a filesearch sorted on last modified files 1
Return most recent file in subdirectory with out using FileSearch 20
Using the file search object 2
open last modified worksheet 4
Search Files and Report Results in Date Range 0

Top