I downloaded a sample "Address" database from the Microsoft Access pages in
August 2006 to use with my Office 2003 Professional program. I have been
unable to get this database to perform the "Find Person" function, or the
"DataBase View" function...Each attempt to use these results in a notice
"Microsoft Visual Basic, Compile error: Can't find project or library" In
Form_Findform(code) it stops at [If Mid (strIn, i, 1) " "'" Then] -- In
Form_SelectfieldsDialog(Code) it stops at [strSQL = Left (strSQL, Len
(strSQL) -2 & "FromHousehold".

Is this sample database flawed? Has anyone worked out a correction, or is
their a better address database sample available?

Hi John,

You may want to use the link below to post this to the MS Access newsgroups. If possible identify there both your Windows versions
there and the name of the database template you downloaded. It's possible that you need to redownload it or that an add-in from
another product could be interfering.

============
<<"John K" <John K@discussions.microsoft.com> wrote in message news:8641817B-4182-4F98-B7F6-0D203DF95D49@microsoft.com...
I downloaded a sample "Address" database from the Microsoft Access pages in
August 2006 to use with my Office 2003 Professional program. I have been
unable to get this database to perform the "Find Person" function, or the
"DataBase View" function...Each attempt to use these results in a notice
"Microsoft Visual Basic, Compile error: Can't find project or library" In
Form_Findform(code) it stops at [If Mid (strIn, i, 1) " "'" Then] -- In
Form_SelectfieldsDialog(Code) it stops at [strSQL = Left (strSQL, Len
(strSQL) -2 & "FromHousehold".

Is this sample database flawed? Has anyone worked out a correction, or is
their a better address database sample available? >>
--
Please let us know if this has helped,

Bob Buckland ?:-)
MS Office System Products MVP

>>*Courtesy is not expensive and can pay big dividends<<

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.access
or via browser:
http://microsoft.com/communities/new....public.access

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/communit...s/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com

you can test to see if your download was corrupted
or your access is by:

creating a database with one of the preinstalled templates
for your access. go to new, select templates on your
computer and use something like the one for "contacts"

if this builds and functions then you can likely eliminate
an issue with the program.....

you might also consider modifing the one on
your computer by adding address fields and or
whatever else you find to be useful.....


"John K" <John K@discussions.microsoft.com> wrote in message
news:8641817B-4182-4F98-B7F6-0D203DF95D49@microsoft.com...
>I downloaded a sample "Address" database from the Microsoft Access pages in
> August 2006 to use with my Office 2003 Professional program. I have been
> unable to get this database to perform the "Find Person" function, or the
> "DataBase View" function...Each attempt to use these results in a notice
> "Microsoft Visual Basic, Compile error: Can't find project or library"
> In
> Form_Findform(code) it stops at [If Mid (strIn, i, 1) " "'" Then] -- In
> Form_SelectfieldsDialog(Code) it stops at [strSQL = Left (strSQL, Len
> (strSQL) -2 & "FromHousehold".
>
> Is this sample database flawed? Has anyone worked out a correction, or is
> their a better address database sample available?

Thanks for the help, but it really did not solve my problem. I am using MS
Windows XP Home edition. I believe the name of the DataBase is just
"Address" it came out and I used it successfully with Access 97 for several
years, but the problem arose when I upgraded to Office Prof. 2003. I'm not a
programer so I had hoped someone had solved the problem without the necessity
of my trying to change to a different database and convert or retype a few
hundred records.

John

"Bob Buckland ?:-)" wrote:

> Hi John,
>
> You may want to use the link below to post this to the MS Access newsgroups. If possible identify there both your Windows versions
> there and the name of the database template you downloaded. It's possible that you need to redownload it or that an add-in from
> another product could be interfering.
>
> ============
> <<"John K" <John K@discussions.microsoft.com> wrote in message news:8641817B-4182-4F98-B7F6-0D203DF95D49@microsoft.com...
> I downloaded a sample "Address" database from the Microsoft Access pages in
> August 2006 to use with my Office 2003 Professional program. I have been
> unable to get this database to perform the "Find Person" function, or the
> "DataBase View" function...Each attempt to use these results in a notice
> "Microsoft Visual Basic, Compile error: Can't find project or library" In
> Form_Findform(code) it stops at [If Mid (strIn, i, 1) " "'" Then] -- In
> Form_SelectfieldsDialog(Code) it stops at [strSQL = Left (strSQL, Len
> (strSQL) -2 & "FromHousehold".
>
> Is this sample database flawed? Has anyone worked out a correction, or is
> their a better address database sample available? >>
> --
> Please let us know if this has helped,
>
> Bob Buckland ?:-)
> MS Office System Products MVP
>
> >>*Courtesy is not expensive and can pay big dividends<<
>
> LINKS
> A. Specific newsgroup/discussion group mentioned in this message:
> news://msnews.microsoft.com/microsoft.public.access
> or via browser:
> http://microsoft.com/communities/new....public.access
>
> B. MS Office Community discussion/newsgroups via Web Browser
> http://microsoft.com/office/communit...s/default.mspx
> or
> Microsoft hosted newsgroups via Outlook Express/newsreader
> news://msnews.microsoft.com
>
>
>
>

Thanks Database Ben.

I will probably have to use one of the preinstalled templates, but I was
trying to avoid having to change a few hundred records to a different format.
I had hoped someone had already reinvented the wheel and solved the code
problems that occured when I changed from Access 97 to Access 2003.

John

"DatabaseBen" wrote:

> you can test to see if your download was corrupted
> or your access is by:
>
> creating a database with one of the preinstalled templates
> for your access. go to new, select templates on your
> computer and use something like the one for "contacts"
>
> if this builds and functions then you can likely eliminate
> an issue with the program.....
>
> you might also consider modifing the one on
> your computer by adding address fields and or
> whatever else you find to be useful.....
>
>
> "John K" <John K@discussions.microsoft.com> wrote in message
> news:8641817B-4182-4F98-B7F6-0D203DF95D49@microsoft.com...
> >I downloaded a sample "Address" database from the Microsoft Access pages in
> > August 2006 to use with my Office 2003 Professional program. I have been
> > unable to get this database to perform the "Find Person" function, or the
> > "DataBase View" function...Each attempt to use these results in a notice
> > "Microsoft Visual Basic, Compile error: Can't find project or library"
> > In
> > Form_Findform(code) it stops at [If Mid (strIn, i, 1) " "'" Then] -- In
> > Form_SelectfieldsDialog(Code) it stops at [strSQL = Left (strSQL, Len
> > (strSQL) -2 & "FromHousehold".
> >
> > Is this sample database flawed? Has anyone worked out a correction, or is
> > their a better address database sample available?
>
>
>

well, it sounds like a difficult task
but access 97 was not abandoned by the 03.
The data itself is unformatted and is plain basic
text that is readable by both programs.

Also, in 03, you have the ability to import the older
db or link to it. You can also, copy and paste
columns of data from one table to the other.

You can also put all that data from the access 97
table into excel. And that excel table can be used
by access 03.



"John K" <JohnK@discussions.microsoft.com> wrote in message
news:7DCA218B-09DB-40E7-8B3D-51956A22210F@microsoft.com...
> Thanks Database Ben.
>
> I will probably have to use one of the preinstalled templates, but I was
> trying to avoid having to change a few hundred records to a different
> format.
> I had hoped someone had already reinvented the wheel and solved the code
> problems that occured when I changed from Access 97 to Access 2003.
>
> John
>
> "DatabaseBen" wrote:
>
>> you can test to see if your download was corrupted
>> or your access is by:
>>
>> creating a database with one of the preinstalled templates
>> for your access. go to new, select templates on your
>> computer and use something like the one for "contacts"
>>
>> if this builds and functions then you can likely eliminate
>> an issue with the program.....
>>
>> you might also consider modifing the one on
>> your computer by adding address fields and or
>> whatever else you find to be useful.....
>>
>>
>> "John K" <John K@discussions.microsoft.com> wrote in message
>> news:8641817B-4182-4F98-B7F6-0D203DF95D49@microsoft.com...
>> >I downloaded a sample "Address" database from the Microsoft Access pages
>> >in
>> > August 2006 to use with my Office 2003 Professional program. I have
>> > been
>> > unable to get this database to perform the "Find Person" function, or
>> > the
>> > "DataBase View" function...Each attempt to use these results in a
>> > notice
>> > "Microsoft Visual Basic, Compile error: Can't find project or library"
>> > In
>> > Form_Findform(code) it stops at [If Mid (strIn, i, 1) " "'" Then] --
>> > In
>> > Form_SelectfieldsDialog(Code) it stops at [strSQL = Left (strSQL, Len
>> > (strSQL) -2 & "FromHousehold".
>> >
>> > Is this sample database flawed? Has anyone worked out a correction, or
>> > is
>> > their a better address database sample available?
>>
>>
>>

Thanks, That is what I will do, but had been hoping to avoid. There is a
good deal of structure difference complicating the upgrade.

John

"DatabaseBen" wrote:

> well, it sounds like a difficult task
> but access 97 was not abandoned by the 03.
> The data itself is unformatted and is plain basic
> text that is readable by both programs.
>
> Also, in 03, you have the ability to import the older
> db or link to it. You can also, copy and paste
> columns of data from one table to the other.
>
> You can also put all that data from the access 97
> table into excel. And that excel table can be used
> by access 03.
>
>
>
> "John K" <JohnK@discussions.microsoft.com> wrote in message
> news:7DCA218B-09DB-40E7-8B3D-51956A22210F@microsoft.com...
> > Thanks Database Ben.
> >
> > I will probably have to use one of the preinstalled templates, but I was
> > trying to avoid having to change a few hundred records to a different
> > format.
> > I had hoped someone had already reinvented the wheel and solved the code
> > problems that occured when I changed from Access 97 to Access 2003.
> >
> > John
> >
> > "DatabaseBen" wrote:
> >
> >> you can test to see if your download was corrupted
> >> or your access is by:
> >>
> >> creating a database with one of the preinstalled templates
> >> for your access. go to new, select templates on your
> >> computer and use something like the one for "contacts"
> >>
> >> if this builds and functions then you can likely eliminate
> >> an issue with the program.....
> >>
> >> you might also consider modifing the one on
> >> your computer by adding address fields and or
> >> whatever else you find to be useful.....
> >>
> >>
> >> "John K" <John K@discussions.microsoft.com> wrote in message
> >> news:8641817B-4182-4F98-B7F6-0D203DF95D49@microsoft.com...
> >> >I downloaded a sample "Address" database from the Microsoft Access pages
> >> >in
> >> > August 2006 to use with my Office 2003 Professional program. I have
> >> > been
> >> > unable to get this database to perform the "Find Person" function, or
> >> > the
> >> > "DataBase View" function...Each attempt to use these results in a
> >> > notice
> >> > "Microsoft Visual Basic, Compile error: Can't find project or library"
> >> > In
> >> > Form_Findform(code) it stops at [If Mid (strIn, i, 1) " "'" Then] --
> >> > In
> >> > Form_SelectfieldsDialog(Code) it stops at [strSQL = Left (strSQL, Len
> >> > (strSQL) -2 & "FromHousehold".
> >> >
> >> > Is this sample database flawed? Has anyone worked out a correction, or
> >> > is
> >> > their a better address database sample available?
> >>
> >>
> >>
>
>
>