UCase used in append query suddenly causing Undefined Function err

[KWeber]

Greetings -

I have a database application running in Access 2003. Recently - within the
last week or so - I am getting an "Undefined Function" when running queries
containing the UCase function. These queries have been running since
inception of this database in Access 2000. Conversion to 2003 was
accomplished in October 2005. Nothing has changed that I am aware of. Am
currently running Jet 4.0 Service Pack 8. Sandbox security is set to low due
to high usage of macros.

Usage of this query is to force Upper while appending data to table(2) from
table(1), whose source is an imported Excel worksheet.

Statement as { Last: UCase([Last Name]) }

Any ideas what might be causing this sudden departure from proper operation?

Many thanks

 

[fredg]

Greetings -

I have a database application running in Access 2003. Recently - within the
last week or so - I am getting an "Undefined Function" when running queries
containing the UCase function. These queries have been running since
inception of this database in Access 2000. Conversion to 2003 was
accomplished in October 2005. Nothing has changed that I am aware of. Am
currently running Jet 4.0 Service Pack 8. Sandbox security is set to low due
to high usage of macros.

Usage of this query is to force Upper while appending data to table(2) from
table(1), whose source is an imported Excel worksheet.

Statement as { Last: UCase([Last Name]) }

Any ideas what might be causing this sudden departure from proper operation?

Many thanks

Your PC has a missing reference.
Open any module in Design view (or click Ctrl + G).
On the Tools menu, click References.
Click to clear the check box for the type library or object library
marked as "Missing:."

An alternative to removing the reference is to restore the referenced
file to the path specified in the References dialog box. If the
referenced file is in a new location, clear the "Missing:" reference
and create a new reference to the file in its new folder.

See Microsoft KnowledgeBase articles:
283115 'ACC2002: References That You Must Set When You Work with
Microsoft Access'
Or for Access 97:
175484 'References to Set When Working With Microsoft Access' for
the correct ones needed,
and
160870 'VBA Functions Break in Database with Missing References' for
how to reset a missing one.

For even more information, see
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

 

[KWeber]

Greetings Fred -

Per article 283115, all references were set as necessary, and there were
none which carried the "Missing:" identification.

I then followed directions per
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html, selecting then
unselecting a random reference.

When subject query w/UCase function was again run, it operated properly.

Many thanks for pointing out this linked article. I had already found and
checked references as in Article 283115, but this seemed to be the missing
piece.

Best regards,
KWeber

Greetings -

I have a database application running in Access 2003. Recently - within the
last week or so - I am getting an "Undefined Function" when running queries
containing the UCase function. These queries have been running since
inception of this database in Access 2000. Conversion to 2003 was
accomplished in October 2005. Nothing has changed that I am aware of. Am
currently running Jet 4.0 Service Pack 8. Sandbox security is set to low due
to high usage of macros.

Usage of this query is to force Upper while appending data to table(2) from
table(1), whose source is an imported Excel worksheet.

Statement as { Last: UCase([Last Name]) }

Any ideas what might be causing this sudden departure from proper operation?

Many thanks

Your PC has a missing reference.
Open any module in Design view (or click Ctrl + G).
On the Tools menu, click References.
Click to clear the check box for the type library or object library
marked as "Missing:."

An alternative to removing the reference is to restore the referenced
file to the path specified in the References dialog box. If the
referenced file is in a new location, clear the "Missing:" reference
and create a new reference to the file in its new folder.

See Microsoft KnowledgeBase articles:
283115 'ACC2002: References That You Must Set When You Work with
Microsoft Access'
Or for Access 97:
175484 'References to Set When Working With Microsoft Access' for
the correct ones needed,
and
160870 'VBA Functions Break in Database with Missing References' for
how to reset a missing one.

For even more information, see
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html