sample access database in office 2003

[John K]

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?

 

[Bob Buckland ?:-\)]

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.

============
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

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.access
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.access

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

 

[DatabaseBen]

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]

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

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.

============
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

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.access
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.access

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

 

[John K]

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

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.....

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?

 

[DatabaseBen]

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.

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

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.....

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?

 

[John K]

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

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.

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

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.....


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?