Windows Explorer

[Cindy]

Hi

I need help on my form.

It consists of a datasheet view where user can enter more
than one file location to "attach" file to the form (for
eg C:\My Documents\sample.doc). The file location is set
to be a hyperlink, so when the file location is clicked,
it'll go directly to the document.

But the problem is that user might not know where their
documents are, and they need a "Browse" button to search
for the files that they want to "attach" in Windows
Explorer.

I know that by putting a command button with a Shell
explorer.exe kind of code would load Windows Explorer, but
how do I link the doc to the form?

Please help.

Thanks very much,
Cindy

 

[Wayne Gillespie]

Hi

I need help on my form.

It consists of a datasheet view where user can enter more
than one file location to "attach" file to the form (for
eg C:\My Documents\sample.doc). The file location is set
to be a hyperlink, so when the file location is clicked,
it'll go directly to the document.

But the problem is that user might not know where their
documents are, and they need a "Browse" button to search
for the files that they want to "attach" in Windows
Explorer.

I know that by putting a command button with a Shell
explorer.exe kind of code would load Windows Explorer, but
how do I link the doc to the form?

Please help.

Thanks very much,
Cindy

See http://www.mvps.org/access/api/api0001.htm for code to this.


Wayne Gillespie
Gosford NSW Australia