Solved: Employee Forms Northwind

[bkudulis]

I am trying to duplicate the function in the Northwind DB in the Employees form. Specifically the GetFilename function. The form works fine in the Northwind DB but when I bring it over to my DB it errors out on msoFileDialogFilePicker. It says variable not defined. I do not see that the variable is ever set. I may be too frustrated at this point to see it.

[Minty]

You may be missing a reference. Check what references are used in the Northwind DB and make sure they are also in yours. You do this while viewing a module, select the Tools menu and click on References.

[Jacob Hilderbrand]

msoFileDialogFilePicker is part of 2002 and up. What version do you have?

[bkudulis]

That might be it. I am running 2002 but the database defaults to 2000 when it is created. The problem now is that I need it to run on 2000 and not 2002.

[SJ McAbney]

Why do you need it to run on A2000 and not A2002? If you have A2002 installed then it would make sense to convert any A2000 to A2002 as you can then compile the A2002 database into an .MDE which you can't with A2000 databases (in A2002).