msoFileDialogFilePicker

#1 (**permalink**) 28-Jul-2006, 08:13 AM

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?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10551-msofiledialogfilepicker.html

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;
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10551
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

#2 (**permalink**) 28-Jul-2006, 08:13 AM

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 project name>)

Another way to use the file dialog without the MSO object library is to call
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10551
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

"Moses" wrote in message
news:44701218-9AB0-48B8-8858-F2C66783B6ED@microsoft.com...
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10551
> 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
>
>
>
>

#3 (**permalink**) 28-Jul-2006, 08:14 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10551
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10551

What else could possibly be missing?

"Graham Mandeno" wrote:

> 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 > 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
>
> "Moses" wrote in message
> news:44701218-9AB0-48B8-8858-F2C66783B6ED@microsoft.com...
> > 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
> >
> >
> >
> >
>
>
>

#4 (**permalink**) 28-Jul-2006, 08:14 AM

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

"Graham Mandeno" wrote:

> 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 > project name>)
>
> Another way to use the file dialog without the MSO object library is to call
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10551
> the Windows dialog directly.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10551
> See here for an example: http://www.mvps.org/access/api/api0001.htm
> --
> Good Luck!
>
> Graham Mandeno [Access MVP]
> Auckland, New Zealand
>
> "Moses" wrote in message
> news:44701218-9AB0-48B8-8858-F2C66783B6ED@microsoft.com...
> > 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
> >
> >
> >
> >
>
>
>

#5 (**permalink**) 28-Jul-2006, 08:14 AM

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

"Moses" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10551
news:3C0703FE-D0DA-4367-B315-799EDF11CA0D@microsoft.com...
>I will look at the information on the hyperlink. Hoewever all of the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10551
> 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?
>
>
> "Graham Mandeno" wrote:
>
>> 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
>> >> 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
>>
>> "Moses" wrote in message
>> news:44701218-9AB0-48B8-8858-F2C66783B6ED@microsoft.com...
>> > 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
>> >
>> >
>> >
>> >
>>
>>
>>