Share via

MS Access 365 error: Microsoft Access cannot find the name '' you entered in the expression

Anonymous
2019-01-28T05:20:05+00:00

I just started getting this error when trying to run a Macro.  I get the message with an old database or making a new one and on three different computers now. My references in VBA don't show anything "MISSING" so I'm lost.

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 No comments

6 answers

Sort by: Most helpful
  1. Anonymous
    2019-01-29T06:04:32+00:00

    Okay, then post the If statement.  Remember, I can't see your database.  I can't tell you what's wrong without knowing some specifics.  Doing so would only be guessing and the guess would most likely be wrong.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2019-01-29T05:24:39+00:00

    I just made a simple database to try and figure out what was happening in my large one. It's made up of two tables, table 1 and table two. I made a query between the two tables just to make sure it was good and it was. But when I run an If Then function in a macro using either tables I get that same message. I've used the macro in the past without a problem but now I got no joy.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2019-01-29T03:21:35+00:00

    What are you trying to do with the second Table and what is it's name.  Hmm, also, what is the name of the first table.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2019-01-29T02:34:25+00:00

    No, I just started fresh by making two small Tables and a query. Then I tried to use the second table in a macro but all I get is that message.

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2019-01-28T06:31:59+00:00

    Well, it seems the Macro is trying to find Table2.  Did you copy a Macro which was using a Table with that name?

    Was this answer helpful?

    0 comments No comments