Sorry if this has been covered many times, I just cant get to grips with it using others data and syntax... I never know what is a table, field name or the name of a control.
I want to update a particular record in a particular table with the results from a VBA variable.
In the table tblMySys I have...
Then I have...
What comes next in the code to replace the word 'Apple' with 'Orange'.
Sorry its so very basic and does not have a practical application but this way I can understand what each aspect of the code is; which is a table/field name and which is an actual command/function.
I want to update a particular record in a particular table with the results from a VBA variable.
In the table tblMySys I have...
MySysVariable (primary key) | MySysValue |
FaveColour | Red |
FaveFruit | Apple |
FaveSoftware | MSAccess |
Then I have...
Code:
Dim MyFaveFruit as String
MyFaveFruit = "Orange"
What comes next in the code to replace the word 'Apple' with 'Orange'.
Sorry its so very basic and does not have a practical application but this way I can understand what each aspect of the code is; which is a table/field name and which is an actual command/function.