Access 2000 Open File Dialog Box

[zenonk]

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]

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.

 

[zenonk]

Perfect, thanks very much