@Alan, Thanks a lot! 
@mcalpi18
I think you are going to be drinking through a fire hose, but hang in there with me...
Basic stuff:
Tables store data. Period.
Forms are how you interact with data in tables. You add, edit or delete data or records.
ALWAYS use form. NEVER allow users to edit data directly in tables.
Reports are for, well reports. Usually paper printouts.
Queries
There are four main types of queries:
"Select queries" - these select the records you want to display in a form or report
"Update queries" - these modify (update) data in records
"Append queries" - these append (insert) new records into tables
And "Delete queries" - these delete records from tables.
You want to add new records to tables. So you:
- can use the query designer, create the append query and save it.
Copy the following, create a new query, switch to SQL view, paste in the SQL and save the query.
Code:
INSERT INTO Master (Entry_Date, Plant_Area, Station, robot, weld, Score) VALUES (Date, "URS", 9, 1, 1, 2);
Any time you open the query (double click on it) a new line will be added to the table "Master".
Or you could create a button with one line of code to execute the query.
Other methods:
- you could use VBA to execute an append query (in code). It would look like this:
Code:
Private Sub Command11_Click()
CurrentDb.Execute "INSERT INTO Master (Entry_Date, Plant_Area, Station, robot, weld, Score) VALUES (Date, 'URS', 9, 1, 1, 2);"
End Sub
- you could use VBA to open a recordset and add a record:
Code:
Private Sub Command11_Click()
Dim r As DAO.Recordset
Set r = CurrentDb.OpenRecordset("Master")
r.AddNew
r!Entry_Date = Date
r!Plant_Area = "URS"
r!Station = 9
r!robot = 1
r!weld = 1
r!Score = 2
r.Update
r.Close
Set r = Nothing
End Sub
I don't think these last two methods are very useful because the data, with the exception of the date, will never change unless you edit the code or the saved query.
If you have text boxes on the form you could enter different data for Entry_Date, Plant_Area, Station, robot, weld & Score, then you would only need one button to add any data for any part of the plant.
The easiest method would be to use a bound form.
Are you drowning yet?? 
If you have more questions, post back.
If you could post a picture of the form, your relationships or post your dB, it would help us understand what you are trying to do......
Windows XP 
Access 2010 32bit
Reply With Quote
