[AccessD] Open a File Dialog Box

Hi Greg

This calls for a class module.
Karsten Pries, a German fellow, has one for download at:

  http://www.karstenpries.de/access

It contains a ShowFolder too.
Comments are mostly in German but you can easily find out.

We recently brushed it up a bit. It works very nicely and is very easy
to implement.
  
/gustav


> I know I've seen it discussed here before but I couldn't find it in the
> archives (probably due to operator error...mine...).

> I need to have a 'browse' button on a form that will allow the users to
> open the File Dialog Box (the normal Windows one) so they can browse to
> the file the program needs if necessary.  Normally they will not have to
> do this, but, things will not always be 'normal' in real life.  This gives
> them the option to go find the file using a familiar interface.

> Is this done using an API call or can it be done strictly thru VB?  I'm
> using Access 97 currently.