VBA equivalent of Excel's "Application.GetOpenFilename" in Access?

[Andy Ellis]

I'm trying to display a dialog that will let the user browse to a file and
return the path or a null from an Access VBA module. In Excel you can use
"Application.GetOpenFilename". Is there an equivalent dynamic dialog in the
Access VBA library?
Do I need to buy the developer's toolkit?

[Dev Ashish]

Hi Andy,

It's not present in Access. You need to call the APIs directly. Try this
link.

< http://home.att.net/~dashish/api/api0001.htm >

HTH
--
Dev Ashish (Just my $.001)
---------------
The Access Web ( http://home.att.net/~dashish )
---------------

Andy Ellis <Ell...@NOSPAMmailbag.com> wrote in message
news:7jjvo6$dr$1...@grandprime.binc.net...
: I'm trying to display a dialog that will let the user browse to a file and

:
:
:

[Matthew Stark]

use the common dialog activex control

[Pieter Wijnen]

No,
Don't use the ActiveX (it gives trouble when distributing the App)
Use the API from Dev's Site
Or Get my Class version of it from http://www.pcltd.co.uk/access/
(should be there tomorrow, Right Calum?)

--
Regards
Pieter Wijnen

mailto:wij...@online.no
http://www.thuleeng.com

Tough guys don't take backup - tough guys cry a lot..

Good site to look for Access answers is Dev's site:
http://home.att.net/~dashish

[Calum Reay]

"(should be there tomorrow, Right Calum?)"

Yup, was there the same day you sent it :)
--
Calum Reay
Paradox Contracting Ltd
http://www.pcltd.co.uk/
http://www.pcltd.co.uk/access

Pieter Wijnen <wij...@online.no> wrote in message
news:376020B5...@online.no...