File dialog in Access 2003 doesn't show.

[H. Martins]

I need to have file dialog in Access 2003.

I have done that once in the pass but I can't get it running now.

http://support.microsoft.com/kb/824272 says how to do it.

At the moment I am using .mdb file, but latter I will convert
to .mde ... the above link says "This method does not work in a
Microsoft Access run-time application." Is this about the Access 2007
run-time only?

Under VBA I have as references:

Visual Basic For Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6 Object Library
Microsoft Activex Data Objects 2.1 Library
Microsoft Calendar Control 11.0 (I suppose this is not standard but
don't know why I have it selected).

Even just under .mdb, file dialog doesn't show.

I will soon try porting the application to 2007 to be able to use
Access Run Time Only install.

Thanks
Henry

 

[H. Martins]

I have a folder path, I need to open a file dialog pointing to that
folder and let the user select and run the file (.pdf, .xls), etc,
open the respective application.

Henry

 

[Douglas J. Steele]

Use the code in http://www.mvps.org/access/api/api0001.htm

It's more reliable in all cases.