Share via

macro Not Isloaded error

Anonymous
2011-12-12T16:54:27+00:00
  1. In the If action, in the box next to If, type Not IsLoaded, followed by the name that you gave your report parameter form, enclosed in quote marks and parentheses. For example, if your form is named Date Range, you type Not IsLoaded ( "Date Range").
  2. In the If action, click the drop-down arrow next to Add New Action, and then click CancelEvent.

These are microsoft instructions in making a macro for a form for an ask query.  "Not" is not and option in the actions  and returns an error saying "access cannot parse the expression"

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

Answer accepted by question author

HansV 462.6K Reputation points
2011-12-13T15:09:07+00:00

Perhaps it'd be better to use VBA code than a macro; even though macros have been greatly improved in Access 2010, I still find VBA code easier to manage and to debug.

Was this answer helpful?

0 comments

8 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Anonymous
    2011-12-12T18:05:49+00:00

    tried both 

    Not IsLoaded("partsCostPerTruck")

    and

    IsLoaded("PartsCostPerTruck")=False

    also

    IsLoaded("strPartsCostPerTruck")=False

    When I type in the function  IsLoaded is show up  but  Not  or False is not one of the options when

    using making a macro.

    Was this answer helpful?

    0 comments
  3. HansV 462.6K Reputation points
    2011-12-12T17:43:32+00:00

    Try

    IsLoaded("Date Range")=False

    Was this answer helpful?

    0 comments
  4. ScottGem 68,830 Reputation points Volunteer Moderator
    2011-12-12T17:42:31+00:00

    Are you typing Not IsLoaded()  ?

    Was this answer helpful?

    0 comments