When you are in the datasheet view, you just need to go to the end of the table and click in any of the fields to begin the record.
Top of the Page There will be times that you need to find records based on specific values in a field.
You can add records to a table by using the datasheet view of the table or by inputting them from a form view.
Before you can add records to the table, you need to open it.
I'm trying to use the "Update; Insert if New" option against an ODBC connected Microsoft Access database table.
I've made sure to create a primary key for the table, however the Output Data tool reports this error: "Primary Key required for Update option".
, then upon the form's close, a separate table should have a record added with the team's number and score.
PKey] as a bound textbox in the pop-up form and it works. Update Add the employee_tbl table and enter the criteria as below.Field and Table are one you want to update, Update To is the new value you want to put.I should mention that this is a maintenance problem, as this database was complete and used in previous competitions, but the user needed it to be slimmed down.I'm an Access 2007 newbie, but everything has been going fine until this.