Report problem

[David M C]

I have a database app setup that works fine on one PC. I have copied it to
another PC and the reports don't work. The problem is associated with
controls that concatenate strings.

Here is one example:

=[CompanyName] & Chr(13) & Chr(10) & [Address]+Chr(13)+Chr(10) &
[Address2]+Chr(13)+Chr(10) & [City]+Chr(13)+Chr(10) &
[County]+Chr(13)+Chr(10) & [PostCode]

This works fine on one PC, but comes up with the error "The function you
entered cannot be used in this expression". One of my controls also uses the
Mid function. Again, this works fine on one PC, but comes up with "#Name" on
the preview, but no other errors.

The DB is set up with Frontend/Backend. The Backend is on my server, the
front end gets installed on each PC. I have the current version of DB on a
network share. The users run a batch file to copy the latest version to their
PC's. I have checked they are running the correct version. I have checked the
version on the network share from my PC (it works fine). Each PC uses XP Pro
and Office 2003 Pro.

Any ideas what to check? I've checked the references and they all match.

Dave

 

[Arvin Meyer [MVP]]

You most likely have a references problem. You can read about it and easily
fix it:

Allen Browne has this great information.

http://allenbrowne.com/ser-38.html

and Doug Steele has this:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Arvin Meyer [MVP]]

Ooops, sorry. Doug Steele's site is now at:

http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[David M C]

Thanks, fixed now. It was a mssing reference (MapPoint 2004). The PC's in
question don't have MapPoint installed, but the forms/reports they were using
don't require MapPoint. I just copied the missing tbl file into the Access
directory and it all worked.

Thanks,

Dave

Ooops, sorry. Doug Steele's site is now at:

http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

I have a database app setup that works fine on one PC. I have copied it to
another PC and the reports don't work. The problem is associated with
controls that concatenate strings.

Here is one example:

=[CompanyName] & Chr(13) & Chr(10) & [Address]+Chr(13)+Chr(10) &
[Address2]+Chr(13)+Chr(10) & [City]+Chr(13)+Chr(10) &
[County]+Chr(13)+Chr(10) & [PostCode]

This works fine on one PC, but comes up with the error "The function you
entered cannot be used in this expression". One of my controls also uses the
Mid function. Again, this works fine on one PC, but comes up with "#Name" on
the preview, but no other errors.

The DB is set up with Frontend/Backend. The Backend is on my server, the
front end gets installed on each PC. I have the current version of DB on a
network share. The users run a batch file to copy the latest version to their
PC's. I have checked they are running the correct version. I have checked the
version on the network share from my PC (it works fine). Each PC uses XP Pro
and Office 2003 Pro.

Any ideas what to check? I've checked the references and they all match.

Dave