XP explorer operations from within Access?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cheese_whiz - 28 Sep 2006 20:17 GMT

Is it possible to set up a command button (or anything else) that would do
something like open a windows explorer window for the purpose of creating a
new directory in which to keep Word documents (and/or scanned documents)
related to the files in the Access system I'm working up?

If so, is there a way to automatically fill in the folder name with some
case file information, liike the case file number or file name?

Thanks, in advance.
CW

Reply to this Message

Ed Robichaud - 28 Sep 2006 21:27 GMT

VBA/Access has a "SHELL" command that allows you to run pretty much any
Windows app. With OLE and/or DDE you can link any external doc to an Access
record.
-Ed

> Is it possible to set up a command button (or anything else) that would do
> something like open a windows explorer window for the purpose of creating
[quoted text clipped - 7 lines]
> Thanks, in advance.
> CW

Reply to this Message

Cheese_whiz - 29 Sep 2006 12:58 GMT

Thanks for the reply. Just what I needed to hear.

CW

> VBA/Access has a "SHELL" command that allows you to run pretty much any
> Windows app. With OLE and/or DDE you can link any external doc to an Access
[quoted text clipped - 12 lines]
> > Thanks, in advance.
> > CW

Reply to this Message