FileDialog with filters

[fritesmodern]

I would like to open the Windows Filedialog by Access VBA with the following filters:

-show only pdf and jpg files
-show only file names containing the ‘letter’ in the file name.


-show only files located in C:\MYDIRECTORY\MYSUBDIRECTORY
-show only files modified between 10/12/2014 and 10/17/2014

Can anybody post a sample to accomplish all of the above?

Thank in advace

[CJ_London]

see this link

https://msdn.microsoft.com/en-us/lib.../ff196794.aspx

e.g.

.Filters.Add "PDF", "*.pdf"
.Filters.Add "JPG", "*.jpg"

show only file names containing the ‘letter’ in the file name+
show only files located in C:\MYDIRECTORY\MYSUBDIRECTORY - perhaps use initial file name e.g..InitialFileName = "Z:\docs\*t*.*x*"

-show only files modified between 10/12/2014 and 10/17/2014 - don't know suggest google 'filedialog filters'

[fritesmodern]

Thanks for your response.

I have already tried to google filedialog filter date with no success. I am not really sure if this type of filter (date filter) can be added to the filedialog.

[CJ_London]

sounds like you'll need to write your own - found this link which contains a post about accessing file properties

http://stackoverflow.com/questions/1...r-like-abc-pdf

[CJ_London]

also this link

https://technet.microsoft.com/en-us/.../ee176615.aspx

[ItsMe]

As pointed out in post #2 you can filter results based on a single file type. Be sure to clear filters before applying filters.

You can also specify a default directory.

I am not aware of a way to filter based on filename, only extension.

[fritesmodern]

Thanks for your help