Re: File Browse code

From: Nick Coe \(UK\) (classicnickNOSPAMAT_at_MASPON.yahooDOTcom)
Date: 07/11/04 

Date: Sun, 11 Jul 2004 23:49:31 +0100

Michael,

The code from the link I posted will permit you to store a
path and filename into a field. With some modification it
would allow you to store a path and filename into seperate
fields.

If you want to store a path and folder (directory) name then
use the link Doug Steele has posted.

As to how to use the code contained in those examples, if
you don't have a glimmering of where to start then I suggest
you peruse the Access Developers Handbook (Getz, Litwin and
Gilbert) pub'd by Sybex appropriate for your version of
Access.

The reason I say that is because it's getting late and I
can't get my head round explaining where to start. Maybe
tomorrow...... 

-- 
Nick Coe (UK)
www.alphacos.co.uk
---
"Michael" <michaelj@dsl.pipex.com> wrote in message
news:40f17284$0$13089$cc9e4d1f@news.dial.pipex.com...
> Hmm, Nick,
>
> I think that it might be but there is so much code that
I'm not sure what it
> all does and how to use it.
>
> Perhaps if I define the need a bit more clearly:
>     I have a database that accesses hundreds of images
that are stored in
> normal windows folders (i.e. not in an Access Database).
The main folder
> structure is always identical but, on different computers
it might be
> located in a different 'root' directory - e.g. in one an
image might be in:
> "C:\Pictures\Images\Image1.jpg" and on another it's in:
> "F:\Material\Images\Image1.jpg". I have created a
parameter that is used by
> the database: - in example (1) it would be "C:\Pictures\"
and in (2) it
> would be "F:\Material\". Whenever the code needs to access
an image, it
> prefixes the 'standard' folder structure with the
parameter value. It works
> very well and makes the database easily portable between
machines. At
> present, when it is added to a new machine, I have to add
this 'root' folder
> location manually - on some it can be very long
(especially when in
> C:\Documents and settings\XXX\My Documents....etc.!) and
easy to miss-type.
> What I wanted to be able to do was to have a File|Browse
function in the
> form where the database field is displayed so that I can
navigate to the
> appropriate folder and sort-of <press enter> and it will
populate the field
> in the parameter table with the 'root' value.
>
> Sorry it's been such a long description but hopefully it
will be a pointer
> that will help you to give me an idea of how I could use
the proposed code.
>
> Thanks for your quick reply!
>
> Michael.
>
>
>
>
> "Nick Coe (UK)" <classicnickNOSPAMAT@MASPON.yahooDOTcom>
wrote in message
> news:%23Vk0$n1ZEHA.2516@TK2MSFTNGP10.phx.gbl...
> > Michael,
> >
> > Is this what you're after?
> >
> > http://www.mvps.org/access/api/api0001.htm
> >
> >
> > -- 
> > Nick Coe (UK)
> > www.alphacos.co.uk
> >
> > ---
> >
> > "Michael" <michaelj@dsl.pipex.com> wrote in message
> > news:40f15852$0$26953$cc9e4d1f@news.dial.pipex.com...
> > > Is there code to implement a File|Browse and select
> > fucntion on a form. I
> > > want to set an external file reference for storing in
the
> > database for later
> > > use and I'd like to use a Windows-like File|Browse
rather
> > than type it in
> > > manually.
> > >
> > > I have looked on various Access sites but can't find
> > anything.
> > >
> > > Help would be appreciated.
> > >
> > >
> >
> >
>
>