Need help on the format of this INSERT INTO code

[dvlarsen619]

I just can't quite get the quotes right on this. Can somebody please help me? I am sure it is the "Double then Single Quotations" where the problem is. Thank you.

strSQL1 = "INSERT INTO tblRateZoneCharges(RateZoneID, ChargeID)" _
& " VALUES (" & Me!RateZoneID & "," _
& "'AT'" & " ')"
strSQL2 = "INSERT INTO tbl_RateZoneCharges(RateZoneID, ChargeID)" _
& " VALUES (" & Me!RateZoneID & "," _
& "'BA'" & "')"
strSQL3 = "INSERT INTO tbl_RateZoneCharges(RateZoneID, ChargeID)" _
& " VALUES (" & Me!RateZoneID & "," _
& "'DX'" & "')"

 

[ck1999]

Try this

strSQL1 = "INSERT INTO tblRateZoneCharges(RateZoneID, ChargeID)" _
    & " VALUES ('" & Me!RateZoneID & "'," _
    & "'AT'" & " ')"
strSQL2 = "INSERT INTO tbl_RateZoneCharges(RateZoneID, ChargeID)" _
    & " VALUES ('" & Me!RateZoneID & "'," _
    & "'BA'" & "')"
strSQL3 = "INSERT INTO tbl_RateZoneCharges(RateZoneID, ChargeID)" _
    & " VALUES ('" & Me!RateZoneID & "'," _
    & "'DX'" & "')"

ck1999

 

[ClulessChris]

Not tested but try:

strSQL1 = "INSERT INTO tblRateZoneCharges(RateZoneID, ChargeID)" _
    & " VALUES (" & Me!RateZoneID & ",'AT')"
    
strSQL2 = "INSERT INTO tbl_RateZoneCharges(RateZoneID, ChargeID)" _
    & " VALUES (" & Me!RateZoneID & ",'BA')"
    
strSQL3 = "INSERT INTO tbl_RateZoneCharges(RateZoneID, ChargeID)" _
    & " VALUES (" & Me!RateZoneID & ",'DX')"

Never knock on Death's door: ring the bell and run away! Death really hates that!

 

[ClulessChris]

I should have asked what format Me!RateZoneID is.

if this is a string then single quotes around the field as posted by ck1999 e.g. VALUES ('" & Me!RateZoneID & "','DX')"

else as per my last. I think the final single quote in your original may have been causing issues.

Never knock on Death's door: ring the bell and run away! Death really hates that!

 

[TheAceMan1]

how are ya dvlarsen619 . . .

. . . and this:

[blue]   Dim basSQL As String, SQL1 As String, SQL2 As String, SQL3 As String

   basSQL = "INSERT INTO tblRateZoneCharges(RateZoneID, ChargeID) " & _
                  " VALUES (" & Me!RateZoneID & ", "
   SQL1 = basSQL & "'AT');"
   SQL2 = basSQL & "'BA');"
   SQL3 = basSQL & "'DX');"[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886