append delete query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

crhp917 - 25 Nov 2006 04:07 GMT

i wrote an append and a delete query for a table to move and delete records
by looking up the name field in a record by the statement like 'Enter Name".
i combined the two queries into a macro. i am looking for a way to only type
in the name one time to run both queries on the macro. as it is now, i have
to type the name in twice, once for each query. any help would be greatly
appreciated.

joe

Reply to this Message

Steve Schapel - 25 Nov 2006 07:36 GMT

Joe,

Put an unbound textbox on a form, and enter the criteria in here. In
both the Append Query and Delete Query, replace the existing parameter
prompt with a reference to the textbox, using syntax such as...
[Forms]![NameOfForm]![NameOfTextbox]

By the way, as an aside, 'name' is a Reserved Word (i.e. has a special
meaning) in Access, and as such should not be used as the name of a
field or control. I recommend you change this.

Signature

Steve Schapel, Microsoft Access MVP

> i wrote an append and a delete query for a table to move and delete records
> by looking up the name field in a record by the statement like 'Enter Name".
[quoted text clipped - 4 lines]
>
> joe

Reply to this Message