Append/Update query help

[valeriej42]

I am trying to create a form to enter data into a table that I ultimately will create a report from. I have created a blank table with the columns I need. I created an append query to add the new records and an update query and a macro to run them on click of a button. It all runs but it doesn't append anything to the table. What am I doing wrong?:banghead:

 

[jdraw]

Show us the SQL for your append query.
Where does the Update query fit?

 

[valeriej42]

FYI: I am sort of a novice and definitely not a programmer so please baby me. Here is the SQL for the append. I don't understand the other question.

INSERT INTO [Employee Engagement Points] ( Go_By_Name, Last_Name, Engagement_Points, Activity, Employee_ID )
SELECT [Employee Engagement Points].Go_By_Name, [Employee Engagement Points].Last_Name, [Employee Engagement Points].Engagement_Points, [Employee Engagement Points].Activity, [Employee Engagement Points].Employee_ID
FROM [Employee Engagement Points];

 

[jdraw]

You said you had an Append and an Update query.

What is the purpose of the Update query? Where does it fit in relation to the Append query?

Is your Form bound to your [Employee Engagement Points] table?
I recommend you do NOT have spaces within field or object names.

If you create a table design, then use that table to Create a Form and use that form to Enter Data, The records are Inserted and saved when you move from one record to the next.

In Design View, select the Table involved, Then Create, then Form and Access will create a form based on your table.

 

[valeriej42]

This is for engagement points that employees receive for participating in particular activities. I want it to update already created records if necessary and append new records created using the form.

 

[jdraw]

If you have the form set up as mentioned in my last post, then you could add new records, or update existing records.

To add a new record:
Go to the new record control on the form (see attached jpg), this will give you a blank record and type in the data

To edit a record:
Select the appropriate record and edit the value as required.

You can make it more sophisticated, but this should get you going.

Good luck.

 

[valeriej42]

The new record control is not available. I can't create the form from that table because it is blank. I need the form to fill it in. The info comes from a different table. Maybe there is something I need to do that I don't realize. I didn't create the original db I'm just tasked with repairing and modifying it. It will be used by someone who needs it to almost work itself.