Reports using built-in functions don't work when moved to a new machine

[Dougal Fair]

I have developed an application on my computer
that uses Access2000 to do reports. All works
fine.

But when I tried to deliver the application
(including the Access2000 MDB files) to the
client's brand-new laptop (with Office installed,
including Access2000 SR-1), the reports can't seem
to understand the built-in functions I use in the
formulas for the report fields.

Specifically, I use this control source for a
field:

="(" & Left([HomePhone],3) & ")" &
Mid([HomePhone], 4,3) & "-" & Mid(HomePhone], 7,8)


(well, without the line breaks...)

When I try to view the report, it shows a dialog
box labelled "Enter Parameter Value" and is asking
for the parameter "Mid". If I enter a value and
hit "ok", it just shows an empty report.

If I edit the control source and just use
[HomePhone], it works fine. It's the built-in
function Mid that it thinks is a parameter for
some reason.

Also, as I said, it works fine on MY computer,
running Acess2000 SR-1 also.


Any ideas?


TIA

 

[R. Hicks]

Usually a sure sign of a broken or "Missing" Library Reference on th
offending machine ....

RD

 

[Albert D. Kallal]

You no doubt have your references messed up.

Check out:

Allen Browne
http://users.bigpond.net.au/abrowne1/ser-38.html

Doug Steele:
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

Peter Walker:
http://www.papwalker.com/dllhell/index-page2.html


MsKb Articles: 310803, 208218, 209849, 286300

ACC2000: How Access 2000 Resolves Visual Basic for Applications References
http://support.microsoft.com/default.aspx?scid=kb;en-us;248941

ACC2000: How to Resolve Reference Issues in an Access Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;310803

 

[Dougal Fair]

You no doubt have your references messed up.

Exactly right - thanks.

The "app" (actually, there was no Access app, but
I used some VBA functions in a report) was
referencing MS DataGrid 6.0 for no apparent
reason. Maybe I tried it out one time long ago
and then forgot about it or something and the
reference was still there.