Right fomatting function

  • Thread starter Thread starter Louise K
  • Start date Start date
L

Louise K

I have a database that was working well until it was
converted from Access 97 to Access 2000. Now I get an
error message stating "Undefined function 'Right' in
expression". Does anyone have an idea what might cause
this?
 
Your references are probably messed up.

This can be caused by differences in either the location or file version of
certain files between the machine where the application was developed, and
where it's being run (or the file missing completely from the target
machine). Such differences are common when new software is installed.

On the machine(s) where it's not working, open any code module (or open the
Debug Window, using Ctrl-G, provided you haven't selected the "keep debug
window on top" option). Select Tools | References from the menu bar. Examine
all of the selected references.

If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)

For far more than you could ever want to know about this problem, check out
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html
 
Hi Louise,

SYMPTOMS
When you call a user-defined function from within an aggregate (totals)
function, such as the Sum() function, in a report, you may receive the
following error message:


Undefined function '<function name>' in expression.
CAUSE
The user-defined function is located in the report module.
RESOLUTION
Transfer the user-defined function from the report module to a global
module.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access versions
2.0, 7.0, and 97.
MORE INFORMATION
Steps to Reproduce Problem


Open the sample database Northwind.mdb (or NWIND.MDB in Microsoft Access
2.0).
Open the Alphabetical List Of Products report in Design view.
Add a text box with the following property to both the detail section and
the Product Name footer section of the report:
ControlSource: =Sum(Notwork())

On the View menu, click Code.
Enter the following user-defined function in the report module:
Function Notwork()
Notwork=8
End function

Close the report module.
Preview the report. Note that you receive the error message described
earlier in this article.
REFERENCES
For more information about creating modules, search for "module," and then
"Creating" using the Microsoft Access 97 Help index.


For Further Information : Microsoft Knowledge Base Article - 123344

http://office.microsoft.com/assistance/preview.aspx?AssetID=HP052805331033&C
TT=4&Origin=CH063654441033

Please let me know has this helped You...
Thank you...
Raghu...
 
Back
Top