|
 |
access thread: File Browse
Message #1 by "Christopher Mohr" <cmohr@b...> on Thu, 24 Oct 2002 23:28:15
|
|
I am trying to set up a buttom that will bring up file browser, like
windows explorer, and when a specific file is selected, it will create a
hyperlink to that file in a text box.
Is this possible.
Thanks,
Chris
Message #2 by "Bob Bedell" <bobbedell15@m...> on Fri, 25 Oct 2002 02:19:36 +0000
|
|
Hi Chris,
Very possible. But...
1. What version of Access are you using? If you're using Access 2002,
we can use the new FileDialog property of the Application object to
return a FileDialog object. Otherwise we'll need to go with an API call,
unless you have the Office Developer edition, in which case we can use
the Common Dialog Control.
2. Do you want the full path AND filename returned? I you just want
the path to the folder (but not the file name), the Windows Shell
Browse for Folder dialog will work. If you want the file name too, we'll
need to go with one of the above options.
But, everything depends on your version of Access.
Best,
Bob
>From: "Christopher Mohr" <cmohr@b...>
>Reply-To: "Access" <access@p...>
>To: "Access" <access@p...>
>Subject: [access] File Browse
>Date: Thu, 24 Oct 2002 23:28:15
>
>I am trying to set up a buttom that will bring up file browser, like
>windows explorer, and when a specific file is selected, it will create a
>hyperlink to that file in a text box.
>
>Is this possible.
>
>Thanks,
>
>Chris
_________________________________________________________________
Broadband? Dial-up? Get reliable MSN Internet Access.
http://resourcecenter.msn.com/access/plans/default.asp
Message #3 by "Gerald, Rand" <RGerald@u...> on Fri, 25 Oct 2002 09:53:53 -0500
|
|
Hi Christopher,
Which version of Access are you using? This particular problem is most
easily handled by Access 2002 (Office XP).
Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx
-----Original Message-----
From: Christopher Mohr [mailto:cmohr@b...]
Sent: Thursday, October 24, 2002 18:28
To: Access
Subject: [access] File Browse
I am trying to set up a buttom that will bring up file browser, like
windows explorer, and when a specific file is selected, it will create
a
hyperlink to that file in a text box.
Is this possible.
Thanks,
Chris
|
|
 |