I need to create an Open File Dialog box in Access 2000. I am
attempting to use the code from
http://www.mvps.org/access/api/api0001.htm but am not clear how to do
so. Do I just paste it into the VB code which relates to the form
where I need to use it, or do I make it a class module? If so, does it
need to be called something specific? I am getting the following
error:
Compile Error
Constants, fixed-length strings, arrays, user-defined types and Declare
statements not allowed as Public members of object modules. It is
referring to the Global Const statements I believe.
thanks
Douglas J. Steele - 30 Jan 2006 22:39 GMT
Everything between Code Start and Code End should be copied into a standard
module (not a module associated with a form, nor a class module).
Make sure you don't name the module the same as any of the routines within
it.

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
>I need to create an Open File Dialog box in Access 2000. I am
> attempting to use the code from
[quoted text clipped - 10 lines]
>
> thanks
zenonk@comcast.net - 31 Jan 2006 18:03 GMT
Perfect, thanks very much