open explorer with filter from access

[Steven]

Is there a way to open windows explorer to a directory and set a filter from
access, like *ste*

Thank you,

Steven

 

[Pete D.]

This will do it and is fairly easy so you should be able to tweak it.
http://www.tech-archive.net/Archive/Word/microsoft.public.word.vba.beginners/2005-12/msg00049.html

 

[Steven]

I am thinkin more like:

Shell "explorer.exe " + "C:\", vbMaximizedFocus

But I want to be able to add criteria as if I was in the Search of explorer
and returned specific files like: Files with _______ in the name...

ie I want to open explorer and select the files and the files showing are
ones matching a filter.

Thanks,

Steven

 

[Pete D.]

What are you going to do with them once selected? Open, Edit, create a
hyperlink. When you shell out usually your passing control to the
application you have shelled to. What is your end result hope?

 

[Steven]

Pete,

What I am hoping for is if the directory has for example 300 pdf files, that
in access I input, for example ste in a field and then click a command
button that has the code on the OnClick event that opens the explorer window
showing only files that have ste in the name.

Thanks,

Steven

 

[Pete D.]

Please don't get iritated with this question. Once you have theses files
displayed what are you going to do with them. Open, add to datafile,
execute, import, create hyperlink. Makes a difference on what you use for
explorer window commands.

 

[Steven]

Sorry, I did not answer what you were asking me. I would be either Opening,
Moving, Cuttting to copy, Copying, Deleting