Dear Access experts,
excuse me for asking questions about primitive things, but this is really confusing when you only start using VBA.
I'm trying to do something totally simple:
Dim strString As String
strString = "TEXT"
"TABLE.Field1" = strString
I keep getting a syntax error. I guess there is somewhere I didn't put a quote or an ampersand but I cannot figure out where.
Could anyone kindly help me with this case and advise me a good concise guide to VBA syntax?
Thank you.
excuse me for asking questions about primitive things, but this is really confusing when you only start using VBA.
I'm trying to do something totally simple:
Dim strString As String
strString = "TEXT"
"TABLE.Field1" = strString
I keep getting a syntax error. I guess there is somewhere I didn't put a quote or an ampersand but I cannot figure out where.
Could anyone kindly help me with this case and advise me a good concise guide to VBA syntax?
Thank you.