#error when running report in Access 2007

[Guest]

When running a report from my Access 2000 database some of the fields are
replaced by #error. No visible error message is seen. Converting to Access
2007 format does not help. They are all fields where two elements are
concatenated.

This includes new ones were I used the wizard to put 2 fields on one line.

 

[Guest]

Hi Mark,

This sounds like it might be a circular reference error to me. Try renaming
the textbox so that it is *not* the same name as one of the fields in your
concatentated expression.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Guest]

Hi.

The field names are the ones created by the wizard like "field1" etc. The
content is like =Trim([FIRSTNAME] & " " & [SURNAME])

The only way I found to use the wizard to set up the labels was to put each
field on a separate line. Putting more than one field on a line causes this
error.

The error itself is not helpful. There is no message with it.

regards,

Mark

 

[Guest]

Hi Mark,

The field names are the ones created by the wizard like "field1" etc.

The field names, or the names of the controls? If the text box was named
field1, with a calculated expression of:

=Trim([FIRSTNAME] & " " & [SURNAME])

then I would think this should have worked, as long as the FIRSTNAME and
SURNAME fields are included in the report's recordsource. Would you be able
to send me a small test database that demonstrates this error? If this is
something you are willing to do, my e-mail address is available at the bottom
of the contributor's page indicated below. Please do not post your e-mail
address (or mine) to a newsgroup reply. Doing so will only attract the
unwanted attention of spammers.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

Hi.

The field names are the ones created by the wizard like "field1" etc. The
content is like =Trim([FIRSTNAME] & " " & [SURNAME])

The only way I found to use the wizard to set up the labels was to put each
field on a separate line. Putting more than one field on a line causes this
error.

The error itself is not helpful. There is no message with it.

regards,

Mark

 

[Guest]

I have sent you an email with a test db attached.

Hi Mark,

The field names are the ones created by the wizard like "field1" etc.

The field names, or the names of the controls? If the text box was named
field1, with a calculated expression of:

=Trim([FIRSTNAME] & " " & [SURNAME])

then I would think this should have worked, as long as the FIRSTNAME and
SURNAME fields are included in the report's recordsource. Would you be able
to send me a small test database that demonstrates this error? If this is
something you are willing to do, my e-mail address is available at the bottom
of the contributor's page indicated below. Please do not post your e-mail
address (or mine) to a newsgroup reply. Doing so will only attract the
unwanted attention of spammers.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

Hi.

The field names are the ones created by the wizard like "field1" etc. The
content is like =Trim([FIRSTNAME] & " " & [SURNAME])

The only way I found to use the wizard to set up the labels was to put each
field on a separate line. Putting more than one field on a line causes this
error.

The error itself is not helpful. There is no message with it.

regards,

Mark

 

[Guest]

Hi Mark,

Your database has a missing reference to the library file Utility.mda, even
though the .accdb file that you sent to me did not include any VBA code
modules. I'm guessing that this database was created in an earlier version of
Access (likely pre-Access 2000), and has been converted. Here is a KB article
that discusses this:

How to resolve reference issues in an Access database
http://support.microsoft.com/kb/310803

This article includes the following:
_______________
"If you converted the database from an earlier version of Access, and the
database contains a reference to the Utility.mda file, in most cases you can
remove this reference because the functions that this reference calls are
included in the default references in Access 2000. If there are references to
earlier versions of DAO, you can also remove these references because DAO 3.6
can address these functions."
_______________

Also, here are two excellent articles on the subject of missing references:

Solving Problems with Library References (Allen Browne)
http://allenbrowne.com/ser-38.html

Access Reference Problems (Doug Steele)
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

In a "clean" installation of Office 2007, ie. no previous version of Office
or Access has been installed, you will not find the Utility.mda file.
However, your database was still carrying a reference to this file, so that's
what caused the MISSING reference error.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________