Another newbie question

[LarryJ]

I created a form where I enter data, click a button and it fills other fields with the results of various calculations.


I have another button to add the calculated results to an existing table.
The insert statement is in this format:

insert into tablename (list of table columns) values (field1.value, field2.value...)

My question is, why does the form prompt me for the values in the fields? I thought using fieldnames.value would put the data on the table automatically.
While I was typing that last line, I found myself wondering if I need to put single quotes around each of the fieldname.value members in the values list.

[pbaldy]

You probably need to concatenate the control references into the string, but you haven't shown your code. The real question is why you aren't using a bound form?

[LarryJ]

Because I am new to Access programming and don't know what a bound form is. On a side note, I tried the single quotes around each field.value combo and I didn't have to enter the data, but it treated them all as a string. Clearly not what I was going for.
Here is the code:

Private Sub RosterAdd_Click()
Dim SQL As String


If IsNumeric(Me.IE.Value) Then
SQL = "insert into All_Teams (Team, Pos, DEF, Name, BB, K, Clutch, Offense, HR, Triple, Spd, Gopher, Rate, IE, Rate2, Walk, Strikeout) values (me.TeamSelect.value,me.PositionSelect.value,me.DE F.value,me.PlayerName.value,me.BB.value, me.K.value,me.Clutch.value,me.Offense.value,me.HR. value,me.Triple.value,me.Spd.value,me.Gopher.value ,me.Rate.value.me.IE.value,me.Rate2.value,me.Walk. value,me.Strikeout.value)"
Else
SQL = "insert into All_Teams (Team, Pos, DEF, Name, BB, K, Clutch, Offense, HR, Triple, Spd) values (me.TeamSelect.value,me.PositionSelect.value,me.DE F.value,me.PlayerName.value,me.BB.value,me.K.value ',me.Clutch.value,me.Offense.value,me.HR.value,me. Triple.value,me.Spd.value)"
End If
'Debug.Print SQL
DoCmd.RunSQL SQL
End Sub

[pbaldy]

See if this helps:

http://www.baldyweb.com/BuildSQL.htm

but I'd almost certainly use a bound form. That is a form with a record source that is either the target table or a query of that table. You are doing this the hard way.

[Welshgasman]

Look on youtube. Plenty of videos on access there.
https://www.youtube.com/watch?v=l75G...dW5kIGZvcm0%3D

[LarryJ]

See if this helps:

http://www.baldyweb.com/BuildSQL.htm

but I'd almost certainly use a bound form. That is a form with a record source that is either the target table or a query of that table. You are doing this the hard way.

I got it to work, thanks to your link.

[pbaldy]

Glad it worked for you. When you need to edit records, you may reconsider the bound form approach.