FileDialog Error in Access 2007

[PercyN]

Hi,
I have tried to search for solutions to this problem but I keep getting solutions for Acess 2003 and below which does not work for me as I am using 2007.
I am trying to open the file dialog box using the FileDialog method. I get an error on the first line where I declare my variable (fd) as FileDialog. The error says "User-defined not defined." I'm not sure what reference to look for as Access 2007 seems to be missing the Microsoft Office 11 reference that used to take care of this in Access 2003.

Any help?

 

[traingamer]

What about a Microsoft Office 12 reference?

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard

 

[MajP]

You can avoid the reference issue by using the windows API instead

http://www.mvps.org/access/api/api0001.htm

 

[traingamer]

After all these years, I still use those Ken Getz routines, too!

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard