How do I stop a condition in a macro in an Access database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a macro in an Access database that appends records to another table in
the database and then deletes the original table. Unfortunately due to a
clerical error in the office files were deleted - including the original
table "Newest Contacts" in the database. Now when I go to run the macro I get
a message that says: "The Microsoft Jet database engine cannot find the input
table of query "Newest Contacts". Make sure it exists and that its name is
spelled correctly. When I close that message I get an "Action Failed" window
that says: Macro Name: LeadPrep, Condition: True, Action Name: Open Query,
Arguments: Append newest contacts to Last Months Leads, Datasheet, Edit.
If I don't want the OpenQuery: Append newest contacts to Last Months Leads
and the DeleteObject: Newest Contacts to run as part of the macro what do I
put as conditions? Or do I only edit the area that is named in the Action
Failed window?
Thanks for your help!
Callie
 
well, you could add a condition that always evaluates to False, such as

1+1 = 5

or you could simply delete the macro actions completely. if you're hesitant
to do that, you could make a copy of the macro object, as a backup and just
leave it in the database - that way if you need to restore the deleted
actions at some point, you still have the "original" macro.

hth
 
Back
Top