Programatically create a file folder

[The Woo]

Can one programatically create a file folder which has the same name
as a key field, using a command button?

Or,

Can there be a a command button which opens up a directory tree to a
specified location. I'm thinking this is a visual basic-related
question?

Why? I have a client tracking database. When the client's record is
opened before me on my form, wouldn't it be great to click a button
and then be able to drag items such as custom-made letters or mp3
dictation recordings to a folder unique to that specific client? It's
true, doing it manually takes but a few seconds, but if your software
is full of time-savers like this, it can turn out to be a real
productivity-booster.

Now, I feel cheap asking someone else to figure this out for me, but
it's such a great idea that maybe whoever answers this question will
be able to use this idea too. I lack coding experience, but I have
terrific ideas for Access and productivity (listening Microsoft?).

Thank you all for putting up with me!

[John Mishefske]

The Woo wrote:

Can one programatically create a file folder which has the same name
as a key field, using a command button?

Or,

Can there be a a command button which opens up a directory tree to a
specified location. I'm thinking this is a visual basic-related
question?

Why? I have a client tracking database. When the client's record is
opened before me on my form, wouldn't it be great to click a button
and then be able to drag items such as custom-made letters or mp3
dictation recordings to a folder unique to that specific client? It's
true, doing it manually takes but a few seconds, but if your software
is full of time-savers like this, it can turn out to be a real
productivity-booster.

Now, I feel cheap asking someone else to figure this out for me, but
it's such a great idea that maybe whoever answers this question will
be able to use this idea too. I lack coding experience, but I have
terrific ideas for Access and productivity (listening Microsoft?).

Yes. Use the "MkDir" command perhaps as so:

Function CreateDirIfRequired(strMyPath As String)
If Len(Dir(strMyPath, vbDirectory)) = 0 Then
MkDir strMyPath
End If
End Function

--
'---------------
'John Mishefske
'---------------

[Allen Browne]

If you create a Hyperlink field in your table, you can link to any document
you wish. For more info, see:
Introduction to Hyperlink fields
at:
http://allenbrowne.com/casu-09.html

You can use FollowHyperlink in VBA to open the folder. For example, if you
have a folder named:
C:\Data\Clients\1001
where 1001 is the client number, you can use:
Dim strFolder As String
strFolder = "C:\Data\Clients\" & [ClientNumber]
FollowHyperlink strFolder

In Access 2007, you will be able to create an Attachments field, and attach
as many files as you wish to a client record.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"The Woo" <***.www.co.> wrote in message
news:ii********************************@4ax.com...

Can one programatically create a file folder which has the same name
as a key field, using a command button?

Or,

Can there be a a command button which opens up a directory tree to a
specified location. I'm thinking this is a visual basic-related
question?

Why? I have a client tracking database. When the client's record is
opened before me on my form, wouldn't it be great to click a button
and then be able to drag items such as custom-made letters or mp3
dictation recordings to a folder unique to that specific client? It's
true, doing it manually takes but a few seconds, but if your software
is full of time-savers like this, it can turn out to be a real
productivity-booster.

Now, I feel cheap asking someone else to figure this out for me, but
it's such a great idea that maybe whoever answers this question will
be able to use this idea too. I lack coding experience, but I have
terrific ideas for Access and productivity (listening Microsoft?).

Thank you all for putting up with me!

[The Woo]

On Sat, 03 Jun 2006 03:49:15 -0400, The Woo <***.www.co.> wrote:

Sheer genius. People such as you move technology forward as much and
perhaps moreso than the creators of the original software. I thank
you.