copy records an paste them in another table

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

Guest

How could I write 8 records in a table, and when someone press a button, the
8 records are cut and pasted at the bottom of another table
tks
 
Typically, you wouldn't. What are you trying to accomplish? If you want to
store them in an "unapproved" table and then move them to an "approved"
table, for example, DON'T. Just add an "approved" checkbox. If you are
moving them to an "archive table", DON'T. Just add an "inactive" checkbox.

Let us know what you are trying to accomplish, and we can probably suggest a
better solution than writing records to one table then turning around and
moving them to another.

Rick B
 
A sales employee sales something, so he put the order in a form with a
subform attached to the form, (the form contains a table), the order is at
most 8 records long, so when a employye press a button, the 8 recordes are
stores in a history table and the table in the subform should be errased.

PD, the employee can't write directly to the history table because I don't
want that the employee see or change the history records.
 
Can't you set the "data entry" property so that the sales employee can only
add records and see records added since they opened the form?

Or, give them permission to add records, but not modify them.



Rick B
 
The employee can't see or change anything, he just can add; but it will be
interesting if you tell me also how to lock the records so I just can see
them and I can't change them
 
Back
Top