Share via

ERROR: "The expression you entered has a function name that Microsoft Office Access can't find".

Anonymous
2010-09-22T16:56:16+00:00

I had a form that ran perfectly in Access 2003, and now that we've upgraded to Access 2007 SP1, I get the following error:

"The expression you entered has a function name that Microsoft Office Access can't find"

Here is the strange part.  I have 2 databases.  1 for business A and 1 for business B.  They are both essentially the same database, except for the products contained in each.  Why would the identical macro run fine in thd DB for business A and give this error for business B.

I don't think I can attach a screenshot here, but if I can, let me know and I'll send a picture of the code in error.

Thank you for your answer,

CJ

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-09-22T17:11:02+00:00

    It's a bit hard to fix a problem that we can't see, but... two questions:

    Are both databases in a Trusted Location?

    Try opening the failing database; type Ctrl-G to open the VBA editor; and try compiling the application. Does it compile correctly, or give you an error? If it does, what's the error?

    John W. Vinson/MVP

    Was this answer helpful?

    0 comments