How to open a file dialogue box in Access97

[Sam]

I would like to allow the user to choose a file in Access97. I believe
it should be a "common dialogue" control, but it's difficult to find
information on it. If someone could give me some direction, I'd really
appreciate it.

thanks in advance,
Sam90

[Allen Browne]

See:
Call Windows File Open/Save Dialog box
at:
http://www.mvps.org/access/api/api0001.htm

That approach is *much* more stable than the common dialog control, even if
you can find it somewhere.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Sam" <sa*******@hotmail.com> wrote in message
news:e2**************************@posting.google.c om...

I would like to allow the user to choose a file in Access97. I believe
it should be a "common dialogue" control, but it's difficult to find
information on it. If someone could give me some direction, I'd really
appreciate it.

thanks in advance,
Sam90

[Sam]

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message news:<40***********************@freenews.iinet.net .au>...

See:
Call Windows File Open/Save Dialog box
at:
http://www.mvps.org/access/api/api0001.htm

That approach is *much* more stable than the common dialog control, even if
you can find it somewhere.

Thanks very much! I prefer using an API anyway, since I distribute the
application and didn't want to include a huge OCX. Actually, I used an
API do do it in Access 2.0, but somehow or other that original API
disappeared...

thanks again,
Sam90