msoFileDialogFilePicker

[TOMK]

I am trying to set up a database for an inventory with pictures in it. I have experienced significat difficulty getting the pictures to appear on the form. I have gone to the extreme of importing the "Employees" table and form from the Northwind sample. However, everytime I try to load the form I get the compile error indicating that "msoFileDialogFilePicker" variable has not been defined. I have tried using the search to find out where in Northwind it was defined, but cannot locate it.
Can someone help me figure out what the "msoFileDialogFilePicker" which is part of the "FileDialog(xxxxx)" is and where it can be defined?

Any assistance would be appreciated.
PS as you probably figured out I am pretty much of a novice.

 

[Dirk Goldgar]

I am trying to set up a database for an inventory with pictures in
it. I have experienced significat difficulty getting the pictures to
appear on the form. I have gone to the extreme of importing the
"Employees" table and form from the Northwind sample. However,
everytime I try to load the form I get the compile error indicating
that "msoFileDialogFilePicker" variable has not been defined. I have
tried using the search to find out where in Northwind it was defined,
but cannot locate it. Can someone help me figure out what the
"msoFileDialogFilePicker" which is part of the "FileDialog(xxxxx)" is
and where it can be defined?

Any assistance would be appreciated.
PS as you probably figured out I am pretty much of a novice.

Press Alt+F11 to open the VB Editor. In that window, choose menu items
Tools -> References..., then look down the list for Microsoft Office
11.0 Object Library (it's 11.0 for Access 2003, 10.0 for Access 2002;
9.0 for Access 2000, 8.0 for Access 97 -- pick the right one). Put a
check mark in the box next to that reference, then close the dialog.

Now the "mso..." constants should be defined, and your code can use
them.

 

[TOMK]

Dirk-

I can't thank you enough. You have no idea the frustration that was building not being able to get this to work. Your solution worked very well and hopefully I can get to work developing my app.

Many, many thanks

 

[BrooksC]

Thanks very much. YOu help was so straight forward and helpful.

 

[CR Nigeria]

Dirk, thank you for the short and simple solution. I was strugling with this
for weeks now. I am in the part of the world where not myny people close by
to get assistance from.

 

[Dirk Goldgar]

Dirk, thank you for the short and simple solution. I was strugling
with this for weeks now. I am in the part of the world where not myny
people close by to get assistance from.

You're welcome, CR. You'll find these newsgroups a great resource.