Not able to add records INSERT INTO multiple data into TABLE & Table does not advance.

[Alphix]

Views: 10 Size: 208.6 KB">Bendix-EVENT COLLECTOR_REV5.zip

Not able to add records to table using the INSERT INTO function and Auto Number does not go to 3, 4, etc.

I would like to add a page of data at once on one row in Table.


Please help.

I have attached a snippet of the file.

[ssanfu]

The SQL statement needs actual delimited values in the "VALUE" clause concatenated to the string..

"VALUES(#" & Date() & "#, " & .......)"

This example is incomplete because I never use tempvars. But you should get the idea.


However, the form is bound to the table. The entries will be automatically be saved if you move off of the current record. Why are you trying to use a SQL statement to save the data?

Your table is not normalized. You will have problems (and probably tear out your hair) with the current table structure...



BTW, I would use the SELECT CASE.... END SELECT construct instead of the multiple IF() statements.
There is a START button, but no STOP button. Again, I don't use tempvars, so I am not sure what you are trying to do.

[Missinglinq]

...Your table is not normalized. You will have problems (and probably tear out your hair) with the current table structure...

Absolutely! You're committing what many call 'Spreadsheet by Database!' You should have a Main Form, based on a Table with the a RecordID (as the Primary Key,) operator's name, date and machine number, then a Subform based on a second Table having a RecordID (as a Foreign Key,) UpTimesStart, UpTimesStop, DownTimesStart, DownTimesStop and EventCode.

The the Tables would be related via the RecordID, and there would be a separate Record, in the Subform, for each event.

Linq ;0)>

[Alphix]

Thanks for pointing me in a better direction. I am still inexperienced in building a database.

I have some questions:

By creating this Form to have 2 tables (One Main and Other Subform)
Multiple users will be entering data at the same time.

1. Will I be able to create a query grab selected users and view there total down time and up time?
2. Does the Foreign Key connect to the correct User without mixing up the elapsed time data?
3. How does the 2 tables keep everything organized from all the various user data?

Thanks.

1.

[orange]

To add to what Steve and Linq have said--- get your tables and relationships set up before dealing with forms.
See and work through this tutorial to gain experience. Then use what you learn to build/refine your database.

Good luck with your project.

[Alphix]

Thank you.