Append Query Single Records

stevembe

New member
Local time
Today, 15:27
Joined
Dec 21, 2004
Messages
9
Thanks for taking the time to look at my problem first of all. I have a form that shows records but I want a button next to each record that will append that one single record to another table that is built exactly the same, which is for historic records. Not the brightest on Access and I can only manage to append all records.

As an example, I have an employee record that have a task, when the task is complete I want to append the record to a historic table that I can look up later on. However, just that one employee and not all that are in the current table.
 
You can put a checkbox by each record and then the use can check witch record they want append and then you can use the close event to run the query. Will this work?
 
KeithG said:
You can put a checkbox by each record and then the use can check witch record they want append and then you can use the close event to run the query. Will this work?

Sorry where do I include or find the close event part you mention. Thanks.
 
Open the form in Design view and double click the little black box in the left top hand corner and then select the event tab. I was refering to the On Close event.
 
KeithG said:
Open the form in Design view and double click the little black box in the left top hand corner and then select the event tab. I was refering to the On Close event.

Nope that still appends all my records but I appreciate your responses.
 
Well I meant to be more specific in my post. Create a a field in your table called Append and make it a yes/no data type. Then tie your checkbox on the form to this field. Then include the Append field in your query and put -1 or True in the criteria row. Now it will only append the records that have been checked.
 
KeithG said:
Well I meant to be more specific in my post. Create a a field in your table called Append and make it a yes/no data type. Then tie your checkbox on the form to this field. Then include the Append field in your query and put -1 or True in the criteria row. Now it will only append the records that have been checked.

You have the patience of a saint and it is appreciated. How do I tie this check box on the form to this field? Thanks
 

Users who are viewing this thread

Back
Top Bottom