MS Access – How to Create a Form Solely for Inputting Data

If you import data and it seemingly disappears, you need to check the indexes on that table. You should do the following:

• Switch the table into Design View
• In the Table Tools Section, under the Design Tab, click on Indexes
• You will see a list of Indexes pop up

If any of the Indexes have one or more columns that are unique, those rows may have vanished upon import. You may need to either remove all indexes (do not touch the PrimaryKey) or Change the Unique Property on all Indexes from Yes to No.

Then, just reimport the data.

If all 235 rows are in the table already, go to your form's Property sheet. Click the Data Tab. Look at the Record Source and see if it is a table name or query.

You need to also go back to the Property Sheet, Click the Format Tab. Look over the Default View and set it to Single Form. This will view the table rows one row at a time. Click the Last Record Navigation Button. It had better say 235 of 235.

Use stored procedures, which can validate input before issuing the SQL commands. The user can be given rights to the stored procedure without any other access.