Need macro button to open a file directory with windows explorer

[inbox360]

Hello,

I need help creating the code for a macro
button on a form that will open a file
directory with windows explorer.


I have about 500 directories with very
long names and only want to input part
of the directory name into the table
that the form uses.


directory name examples:
c:\data\MK-0001_machine_tool_programs\
c:\data\MK-0002_machine_tool_fixtures\
c:\data\MK-0500_machine_tool_maintenance\


The first part of the dirctory name is always the same:
c:\data\


I just want to enter the next seven characters in my table
into a filed called "directory". Example:
Mk-0001
MK-0002
MK-0500


The rest of the directory name ideally can be represented by a
wildcard "*'. If this isn't possible, I can enter the whole
directory name into the table.


Therefore, when I open my form, select a record, then hit
the macro buttom, it will open windows explorer based on
the value stored in my "directory" field.


Thank you for your help.
Antonio

 

[Rob Parker]

The function GetOpenFile from The Access Web allows you to call it with a
default directory. See
http://www.mvps.org/access/api/api0001.htm

Rob

 

[Allen Browne]

Answered in m.p.a.formscoding