Share via

Error code 2482 on Access macro

Anonymous
2025-05-16T17:34:50+00:00

I am experiencing error 2482 when trying to run an Access macro that contains a step with an expression. Macro runs fine until that step. Database is in a trusted location, but CurrentProject.IsTrusted=False. Running Windows 11 on PC.

Microsoft 365 and Office | Access | For home | Other

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
Accepted answer
  1. DBG 11,381 Reputation points Volunteer Moderator
    2025-05-16T19:27:17+00:00

    I think, with your help, I'm learning something new. I have not tried a data macro before, but it looks like exactly what I need. I will do some experimenting and get back to you later, if that is OK.

    They're all tools in your arsenal. You just need to choose the correct one to use based on your goals.

    1 person found this answer helpful.
    0 comments

12 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. DBG 11,381 Reputation points Volunteer Moderator
    2025-05-16T17:42:16+00:00

    What is the actual error message? Also, can you post the macro code? Thanks.

    0 comments
  2. Anonymous
    2025-05-16T17:53:46+00:00

    "Microsoft Access cannot find the name "Table 1" you entered in the expression"

    Action Name: SetLocVar

    Arguments: Test, Sum([Table1]![Value1]

    Code: SetLocVar, Name: Test, Expression Sum([Table1]![Value1]

    I can send screen shots if that would be helpful.

    0 comments
  3. DBG 11,381 Reputation points Volunteer Moderator
    2025-05-16T18:04:19+00:00

    Thanks. Is this on a saved macro or a data macro?

    0 comments
  4. DBG 11,381 Reputation points Volunteer Moderator
    2025-05-16T18:08:38+00:00

    Could you use DSum() instead?

    0 comments