Duplicate Comment into all records

[JoeM]

In between the quotes of your CurrentDB.Execute statement:

CurrentDb.Execute " paste code here ",dbFailOnError

or another way is to set it equal to a variable and run it like this:

Dim mySQL as String
mySQL " paste code here "
DoCmd.RunSQL mySQL

(You could also use a variable in the "CurrentDb.Execute" method).

[Marianna_Air]

where in the VBA do I put that second option you gave me above? is it an event procedure? like on click?

[JoeM]

where in the VBA do I put that second option you gave me above? is it an event procedure? like on click?

You need to determine how and when you want this code to run. That will drive where you put it.

For example, if you want to be able to control it manually, you could place a Command Button on a Form, and place the code in the Click button of the Form. Then it will run whenver you click that Button. Alternatively, you could automatically call the code when some event happens (like the opening of a certain form, or from another section of code, etc).

[Marianna_Air]

Hmmm, button sounds good, I have a new record button, can I put it in to that somehow?

Private Sub Command84_Click()
    MsgBox Me.NewRecord
End Sub

[JoeM]

Just paste it under your "MsgBox" line.

[Marianna_Air]

That what I figured, but nothing happend. Not even an error and compile ran fine

Private Sub Command84_Click()
    MsgBox Me.NewRecord
 CurrentDb.Execute "UPDATE [Request for Quotes] SET [Request for Quotes].RequestforQuotesDescription = 'FULL CERTIFICATION OF MATERIALS, PROCESSES, FINISHES, TESTS AND DIMENSIONAL INSPECTION DATA (AS APPLICABLE) AND CERTIFICATE OF CONFORMANCE MUST BE PROVIDED FOR INSPECTION.  ALL SHELF-LIFE LIMITED MATERIALS MUST HAVE AT LEAST 75% OF SHELF-LIFE REMAINING AT TIME OF DELIVERY.  MSDS IS REQUIRED WITH ALL CHEMICALS, SEALS, GASKETS, O'RINGS, PACKING, ETC.  MUST BE INDIVIDUALLY PACKAGED AND LABELED WITH CURE DATES PER APPLICABLE MIL STANDARDS.  ALSO, PLEASE NOTE ALL ADDITIONAL CHARGES THAT MAY APPLY FOR EXAMPLE FREIGHT, DRY ICE/TEMP RECORDERS, WEDGE CRACK TEST ALSO PLEASE QUOTE FOB CANTONMENT, FLORIDA.  THANK YOU.'", dbFailOnError
End Sub

[JoeM]

Is the command button on a Bound or Unbound Form? It might be best to put it in a new Command Button (by itself) on an Unbound Form.

[Marianna_Air]

I went with a button on the form, not as seamless as I wanted, but it works

Hey thanks for allll the HELP!!!
Kevin