Office 2003 installations causes errors in Access 97

[leeamc]

The company I work with chooses the version of office to be installed,
whether it is on a computer of an employee or one owned by an independent
contractor like myself. The company provided Office program does not include
Access. I have my own Access 97 installed in a separate folder under
programs. I use it as my contact management database. It has withstood
several company wide Microsoft Office upgrades. However, when the company
installed Microsoft Office 2003 this weekend, I now receive error msgs,
primarlily in report features.

"The function you entered can't be used in this expression"
You may have used a DoEvents, LBound, UBound or tab function in an expression
You may have used an SQL aggregate function, such as Count, in a design grid
or in a calculated control or field

For instance, I create an entry for each inquiry I receive on a client's
product. I then produce a report that shows the inquiries specific to each
client during a specified time period. I had a pop up dialogue box in which
I entered the client and date range, this no longer works. Each inquiry was
labled Inquiry #1 etc on the report , which no longer works. (=" #" &
Str([txtCounter]) & ".")

Should I simply reinstall Access 97? What is my best source of information
on this. I have tried the knowledge base and forums, but am not coming up
with the

 

[Arvin Meyer [MVP]]

Access 97 silently self registers itself. You should need it to do that. Go
the directory where Access is installed and look for the file: msaccess.srg
rename it to msaccess.srg.old and open a blank notepad (text) file and save
it as msaccess.srg

Now open Access 2003 and let it register itself.

Now open Access 97 and open any code window, then go to Tools >>> References
and find (or uncheck) and that are marked Missing. Compile and Save the
project. Fix any errors if it won't compile.

Everything should then work OK.

 

[leeamc]

I will try that, however Access 2003 is not installed, just the rest of the
office suite.

Thank you

Access 97 silently self registers itself. You should need it to do that. Go
the directory where Access is installed and look for the file: msaccess.srg
rename it to msaccess.srg.old and open a blank notepad (text) file and save
it as msaccess.srg

Now open Access 2003 and let it register itself.

Now open Access 97 and open any code window, then go to Tools >>> References
and find (or uncheck) and that are marked Missing. Compile and Save the
project. Fix any errors if it won't compile.

Everything should then work OK.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

The company I work with chooses the version of office to be installed,
whether it is on a computer of an employee or one owned by an independent
contractor like myself. The company provided Office program does not
include
Access. I have my own Access 97 installed in a separate folder under
programs. I use it as my contact management database. It has withstood
several company wide Microsoft Office upgrades. However, when the
company
installed Microsoft Office 2003 this weekend, I now receive error msgs,
primarlily in report features.

"The function you entered can't be used in this expression"
You may have used a DoEvents, LBound, UBound or tab function in an
expression
You may have used an SQL aggregate function, such as Count, in a design
grid
or in a calculated control or field

For instance, I create an entry for each inquiry I receive on a client's
product. I then produce a report that shows the inquiries specific to
each
client during a specified time period. I had a pop up dialogue box in
which
I entered the client and date range, this no longer works. Each inquiry
was
labled Inquiry #1 etc on the report , which no longer works. (=" #" &
Str([txtCounter]) & ".")

Should I simply reinstall Access 97? What is my best source of information
on this. I have tried the knowledge base and forums, but am not coming up
with the

 

[Arvin Meyer [MVP]]

Reinstall Access 97 and see if that helps.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I will try that, however Access 2003 is not installed, just the rest of the
office suite.

Thank you

Access 97 silently self registers itself. You should need it to do that.
Go
the directory where Access is installed and look for the file:
msaccess.srg
rename it to msaccess.srg.old and open a blank notepad (text) file and
save
it as msaccess.srg

Now open Access 2003 and let it register itself.

Now open Access 97 and open any code window, then go to Tools >>>
References
and find (or uncheck) and that are marked Missing. Compile and Save the
project. Fix any errors if it won't compile.

Everything should then work OK.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

The company I work with chooses the version of office to be installed,
whether it is on a computer of an employee or one owned by an
independent
contractor like myself. The company provided Office program does not
include
Access. I have my own Access 97 installed in a separate folder under
programs. I use it as my contact management database. It has withstood
several company wide Microsoft Office upgrades. However, when the
company
installed Microsoft Office 2003 this weekend, I now receive error msgs,
primarlily in report features.

"The function you entered can't be used in this expression"
You may have used a DoEvents, LBound, UBound or tab function in an
expression
You may have used an SQL aggregate function, such as Count, in a design
grid
or in a calculated control or field

For instance, I create an entry for each inquiry I receive on a
client's
product. I then produce a report that shows the inquiries specific to
each
client during a specified time period. I had a pop up dialogue box in
which
I entered the client and date range, this no longer works. Each
inquiry
was
labled Inquiry #1 etc on the report , which no longer works. (=" #" &
Str([txtCounter]) & ".")

Should I simply reinstall Access 97? What is my best source of
information
on this. I have tried the knowledge base and forums, but am not coming
up
with the

 

[a a r o n . k e m p f]

dude convert it to a newer version!!!
dude convert it to a newer version!!!
dude convert it to a newer version!!!
dude convert it to a newer version!!!
dude convert it to a newer version!!!

 

[James A. Fortune]

I will try that, however Access 2003 is not installed, just the rest of the
office suite.

From:

http://groups.google.com/group/comp.databases.ms-access/browse_frm/thread/e2deb34d06e97cfc

If none of the references are missing, try unclicking the DAO 3.5
reference and clicking the DAO 3.6 reference.

James A. Fortune
(e-mail address removed)