--- In [email protected], "John Viescas" <[EMAIL PROTECTED]> wrote:
>
> Eileen-
>
> Well, Office 2003 has a FileDialog object, but that's not
available in 2000,
> so you'll have to call the Windows API to open the standard dialog
to find a
> different file. See the code at:
>
> http://www.mvps.org/access/api/api0001.htm
>
> John Viescas, author
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> Running Microsoft Access 2000
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
> For the inside scoop on Access 2007, see:
> http://blogs.msdn.com/access/
>
>
> -----Original Message-----
> From: [email protected] [mailto:[EMAIL PROTECTED]
On Behalf
> Of eileen1309
> Sent: Friday, May 19, 2006 3:14 PM
> To: [email protected]
> Subject: [ms_access] How to return the full path of a file?
>
> First I develop in MSAccess 2003 and distribute to MSAccess 2000.
>
> I have created a form with a field call txtFullPath I would like
to
> create a find button that will allow the user to search their hard
> drive including mapped drives and return the full path of the file
> selected, so that this can be used to link an Excel spreadsheet.
>
> Currently I have the full path & file name defaulted.
>
> I know this has been done before but I'm not sure how any help
would
> be great.
>
> Thanks
> Eileen
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
