Windows Explorer

  • Thread starter Thread starter Cindy
  • Start date Start date
C

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
 
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
Click to expand...

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


Wayne Gillespie
Gosford NSW Australia
 
Back
Top