| | |
|
|
|
VBA code to run an append and a delete query |
| message from SusanR on 5 May 2004 |
I have a process that has a print button. What I want to
do is..when the print button is pressed run my query
called appendtohistory, sending it the needed criteria, to
copy that record to a history table and then run my
deletefromcurrent query(sending the same criteria) to
delete that record from my original table. I can't get the
event procedure to work. Any suggestions on the coding
Thanks
Sue.
|
| Dirk Goldgar replied to SusanR on 5 May 2004 |
"SusanR" <anonymous@discussions.microsoft.com> wrote in message
news:0d5301c432ca$f14dd910$3a01280a@phx.gbl
Please post the event procedure you've written. In what way do you
"send the needed criteria" to the appendtohistory query? Is this a
query with parameters?
|
|
Archived message: VBA code to run an append and a delete query (MS Access Forms)