SQL Not Updating

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

My SQL Statement is not Updating and I can't figure out why...any help
is appreciated.
Thanks
DS



Private Sub Command25_Click()
DoCmd.SetWarnings False
Dim MySQL As String
mySQL = "UPDATE MenuInfo SET ItemID = " & Me.Text12 & ", PrepID = " &
Me.Text44 & ", PrintID = " & Me.Text45 & " " & _
"WHERE MenuID = " & Me.Text7 & " And MenuCatID = " & Me.Text6 & ";"
DoCmd.SetWarnings True
End Sub
 
DS said:
My SQL Statement is not Updating and I can't figure out why...any help
is appreciated.
Thanks
DS



Private Sub Command25_Click()
DoCmd.SetWarnings False
Dim MySQL As String
mySQL = "UPDATE MenuInfo SET ItemID = " & Me.Text12 & ", PrepID
= " & Me.Text44 & ", PrintID = " & Me.Text45 & " " & _
"WHERE MenuID = " & Me.Text7 & " And MenuCatID = " & Me.Text6 & ";"
DoCmd.SetWarnings True
End Sub
Click to expand...

Careless Me. I forgot to tell it to run !!!!!
It always happens that you get the answer RIGHT AFTER you look for help!
Thanks, Anyways.
DS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UPDATE SQL Problem 1
MM/DD/YYYY appears as time when using update query 1
Update Query Problem 2
SQL UPDATE Problem 5
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
A Better Way 4
SQL Not Updating 5
SQL Not Updating 2

Back
Top