Cut and pasting macro from one table to another within the samedatabase

L

loucappozzoli

I have a database to keep track of our clients with 2 tables.

1st table is current clients
2nd table is expired clients

Both share the same fields names ect to make cut and pasting easier.

I want to run a macro that I can press a button, it'll open up the 1st
table in datasheet view, edit mode, then check the expiration date
fields against the current date and show only those client records
that are expired. Then I wish the macro to cut the record from the
current table to the expired table thereby deleting it from current
and moving it to expired.

I have the first part set up as

Action Argument

OpenTable 1stTable, Datasheet, Table
ApplyFilter 1stTable!EXP DATE <Date()

and that's where I get stuck. It'll open the 1st table and show the
records I want to cut and paste and I cannot for the life of me figure
out how to start the cut and paste process. Can anyone help me with
this? Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to delete cut & repost a table 0
Code to cut a paragraph that's followed by a table 2
Pasting from the clipboard 3
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Table cut and paste style macro 2
Macro for Cut and Paste 1
Search column for date format; cut and paste multiple cells to row above 1

Top