Solved adding numbers in code

[murray83]

have this code at moment

CurrentDb.Execute "Update tbl_GoodGuy set [YourHealth] = " & Me.Text133 & " WHERE [GoodGuy] = 'Player'"

but i want to flip it so when user presses command it takes the health count and adds an arbitrary number of my choosing to it ( the number will be the same each time

but when i try and put a + it dont like it, what should i be doing

 

[theDBguy]

What does the error message say?

 

[murray83]

starts saying in the code

Execute Query as string

dont get as far as trying to run as not sure doing it right

 

[theDBguy]

starts saying in the code

Execute Query as string

dont get as far as trying to run as not sure doing it right

Okay, you did say the code you posted was working, right? What is in Text133 when you run that code? What does it look like when you changed it that Access didn't like?

 

[CJ_London]

would also help if you showed what didn't work rather than what did

 

[The_Doc_Man]

CurrentDb.Execute "Update tbl_GoodGuy set [YourHealth] = " & Me.Text133 & " WHERE [GoodGuy] = 'Player'"

To flip it to add some predefined number to the existing health count (rather than adding it to the text box contents), that would be

CurrentDb.Execute "Update tbl_GoodGuy set [YourHealth] = [YourHealth] + " & CStr(Some-arbitrarily-defined-number  ) & " WHERE [GoodGuy] = 'Player'"

 

[arnelgp]

you may also try:

CurrentDb.Execute "Update tbl_GoodGuy set [YourHealth] = [YourHealth] + " & Val(Me.Text133 & "") & " WHERE [GoodGuy] = 'Player'"

 

[murray83]

To flip it to add some predefined number to the existing health count (rather than adding it to the text box contents), that would be

CurrentDb.Execute "Update tbl_GoodGuy set [YourHealth] = [YourHealth] + " & CStr(Some-arbitrarily-defined-number  ) & " WHERE [GoodGuy] = 'Player'"

Bloody Awesome, works a charm, now just got to fix it so cant keep spamming it cheers @The_Doc_Man

 

[murray83]

attached is the WIP with the now working potion button ( well it works as in it gives health back but need to just fix the time you can use ) thanks all

 

[Pat Hartman]

CurrentDb.Execute "Update tbl_GoodGuy set [YourHealth] = [YourHealth] + " & CStr(Some-arbitrarily-defined-number ) & " WHERE [GoodGuy] = 'Player'"

This is working because the whole expression is a string. Normally, you wouldn't get away with adding a string to a number.