Northwind Picture

[SGTPEP]

Hi

I am trying to create an employee form, on each form there will be a picture
of each employee.

I have attempted following the links provided in other reponses; with no luck.

I am now attempting to copy over the employee table and form from Northwind,
however, when i open the form the pictures of the sample are not there, also
the addpicture command button does not work. It returns an error and VB opens
with the warning

"variable not defined"

In the Sub getFilename()
On the line
With Application.FileDialog(msoFileDialogFilePicker)


Any ideas?

 

[Douglas J. Steele]

Use the code in http://www.mvps.org/access/api/api0001.htm at "The Access
Web" rather than using the FileDialog method. It's far less tempermental.

If you're determined to use that code, go into Tools | References while in
the VB Editor and ensure that the appropriate Office entry is selected
(Microsoft Office n.0 Object Library, where n is 8 for Office 97, 9 for
Office 2000, 10 for Office 2002, 11 for Office 2003 and 12 for Office 2007)