Deleting a specific record via a macro

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

Guest

Is there a way to delete a specific record (from a table) via a macro. I
want the user to be able to delete a specific record from a table based on
entry of a primary key value. I have figured out how to delete the record
with a delete query but I can't figure out how to run the delete query from
within the macro.

Will
 
Will,

Just to expand on Anonymous's advice to use the OpenQuery action, you
may want to preced this in your macro with a SetWarnings/No action, to
suppress the display of the action query confirmation message.
 
Steve,
Thanks! That's just what I needed.

Will

Steve Schapel said:
Will,

Just to expand on Anonymous's advice to use the OpenQuery action, you
may want to preced this in your macro with a SetWarnings/No action, to
suppress the display of the action query confirmation message.
Click to expand...
 
Back
Top