msoFileDialogFilePicker

[Guest]

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?

I have already tried looking at the following solution.
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.

Can someone please help me.

Moses

 

[Graham Mandeno]

Hi Moses

And did you find "Microsoft Office xx.0 Object Library" in the list and
select it? Because that should have solved the problem.

Does your code compile OK? (from the VB editor window, Debug->Compile <your
project name>)

Another way to use the file dialog without the MSO object library is to call
the Windows dialog directly.
See here for an example: http://www.mvps.org/access/api/api0001.htm

 

[Guest]

I will look at the information on the hyperlink. Hoewever all of the
checkboxes that need to be checked off are checked.
Microsoft Access 10.0 Object library
Microsoft ActiveX data Objects 2.1 Library

What else could possibly be missing?

Hi Moses

And did you find "Microsoft Office xx.0 Object Library" in the list and
select it? Because that should have solved the problem.

Does your code compile OK? (from the VB editor window, Debug->Compile <your
project name>)

Another way to use the file dialog without the MSO object library is to call
the Windows dialog directly.
See here for an example: http://www.mvps.org/access/api/api0001.htm
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

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?

I have already tried looking at the following solution.
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.

Can someone please help me.

Moses

 

[Guest]

Also, when I run the Northwind Sample everything runs right. Just thought I
would add that bit of information.

Hi Moses

And did you find "Microsoft Office xx.0 Object Library" in the list and
select it? Because that should have solved the problem.

Does your code compile OK? (from the VB editor window, Debug->Compile <your
project name>)

Another way to use the file dialog without the MSO object library is to call
the Windows dialog directly.
See here for an example: http://www.mvps.org/access/api/api0001.htm
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

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?

I have already tried looking at the following solution.
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.

Can someone please help me.

Moses

 

[Graham Mandeno]

Hi Moses

The reference you need is Microsoft *Office* 10.0 Object Library.

Is that one checked?
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

I will look at the information on the hyperlink. Hoewever all of the
checkboxes that need to be checked off are checked.
Microsoft Access 10.0 Object library
Microsoft ActiveX data Objects 2.1 Library

What else could possibly be missing?

Hi Moses

And did you find "Microsoft Office xx.0 Object Library" in the list and
select it? Because that should have solved the problem.

Does your code compile OK? (from the VB editor window, Debug->Compile
<your
project name>)

Another way to use the file dialog without the MSO object library is to
call
the Windows dialog directly.
See here for an example: http://www.mvps.org/access/api/api0001.htm
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

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?

I have already tried looking at the following solution.
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.

Can someone please help me.

Moses