RE: Open explorer and filter file selection

"Steven" wrote:

Very interesting. I am looking for something different here.

I want to see the Windows Explorer exactly like:
Shell "explorer.exe " + "C:\", vbMaximizedFocus

except I want to be able to filter on a specific string in the name which I
will use a variable to define the string.


Hmmm... Can't help you there. Sorry!

Regards, Chris

"Chris O''''Neill" wrote:

"Steven" wrote:

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

I would like to be able to filter down on a string like:
-----------------------------
Dim strExplorer as String
strExplorer = *Steven*
-----------------------------
Then using the Shell above it would open explorer and just show me files
with the name Steven in them. Then either opening a file or close explorer
is all I would do from there.

Is that possible?

Check this out:

http://www.mvps.org/access/api/api0001.htm

You'll notice that it's filtering on file extensions (e.g. ".XLS") but I
don't see why you couldn't filter on anything (e.g. "Steven.*") and it would
work too. Just a matter of editing the strFilter lines in the code. Heck,
without too much effort you could even modify it so you can pass it the
filter that you want.

Hope that helps...

Regards, Chris

.

Relevant Pages

  • Re: Filtering records on a form using multiple combo boxes
    ... So, then, you will need to build the Where string from that information, ... these 3 combo boxes have command buttons to activate the filtering ... filter the field in the record list box.. ... For the Agent Combo Box, ...
    (microsoft.public.access.forms)
  • RE: Set Filter from Startup form to another form
    ... Private Sub Form_Load ... Dim strPrg As String ... Private Function StartProgramAs String ... Now all that is necessary is to set the filter for each form where you want ...
    (microsoft.public.access.formscoding)
  • Re: Filter for Report not working?????
    ... cno2, cField string ... contFilter DynArrayString ... I surround the value with quotes to make it a string otherwise the filter ... I decided to go with a table in PRIV for the report. ...
    (comp.databases.paradox)
  • data access page search code
    ... Dim SerVal As String 'Value to search against ... Dim strWhere As String 'The filter to use ... Dim strPrompt As String 'MsgBox prompt to use ...
    (microsoft.public.access.modulesdaovba)
  • RE: Query form coding
    ... What is the record source of the report? ... Dim strSource As String ... ' Remove Filter ... For Each varItem In Me.namelst.ItemsSelected ...
    (microsoft.public.access.formscoding)