Deleting a specific record via a macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

traveler - 28 Feb 2005 16:51 GMT

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

Reply to this Message

anonymous@discussions.microsoft.com - 28 Feb 2005 17:53 GMT

hi,
use the open query action.

>-----Original Message-----
>Is there a way to delete a specific record (from a table) via a macro. I
[quoted text clipped - 5 lines]
>Will
>.

Reply to this Message

Steve Schapel - 28 Feb 2005 18:16 GMT

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.

Signature

Steve Schapel, Microsoft Access MVP

> hi,
> use the open query action.
[quoted text clipped - 20 lines]
>>Will
>>.

Reply to this Message

traveler - 28 Feb 2005 23:53 GMT

Steve,
Thanks! That's just what I needed.

Will

> Will,
>
[quoted text clipped - 26 lines]
> >>Will
> >>.

Reply to this Message