importing access 2003 reference into access 2000

[ceebaby via AccessMonster.com]

Hi Folks

I have developed a database allowing users to store property pictures using
access 2003 (2000 format) but the end user is using 2000. To make things
simple (or so I thought) i used the code on nothwind employees form to allow
the user to click a button to open a directory and find a photo to select. I
am using external links to the photos and not a bound ole object field.

When I try to open the form in access 2000 I receive a message saying vaiable
not defined. I am using the Application.FileDialog(msoFileDialogFilePicker).
I know this is only available in 2003 but is there anyway to just import
msoffice 11 library or define the mso bit I saw this in a previous post but
am not quite sure how to do that.

The database is finished, should have been submitted yesterday - but I am
stuck on this bit.
Any help anywhere would be much appreciated.
Cheers
Ceebaby

 

[Douglas J. Steele]

No, there's no way to use a library from a different version of Access.

The API approach is preferred for getting the standard Windows File Open
dialog anyhow. See http://www.mvps.org/access/api/api0001.htm at "The Access
Web" for a complete example.

 

[ceebaby via AccessMonster.com]

No, there's no way to use a library from a different version of Access.

The API approach is preferred for getting the standard Windows File Open
dialog anyhow. See http://www.mvps.org/access/api/api0001.htm at "The Access
Web" for a complete example.

Hi Folks

[quoted text clipped - 21 lines]

Cheers
Ceebaby

Thanks Douglas sorry about the duplicate posting
Cheers