Access VBA update recordset error

From: cityofgp (cityofgp_at_discussions.microsoft.com)
Date: 10/28/04 

Date: Thu, 28 Oct 2004 09:25:05 -0700

Using ADODB.recordset and connection, I can successfully update records using:

rs![field1] = "blah"
rs.update

However, when I have a field name with a space as follows:

rs![field 1] = "blah"
rs.update

I get a syntax error message.
How can I update fields that have spaces in the field name? What syntax do I
use?

TIA.

Relevant Pages

  • Re: Access VBA update recordset error
    ... me to use a real e-mail address in public newsgroups. ... GlobalSign digital certificate is a forgery and should be deleted without ... I can successfully update records ... > I get a syntax error message. ...
    (microsoft.public.data.ado)
  • Re: Access VBA update recordset error
    ... "cityofgp" escribió en el mensaje ... > Using ADODB.recordset and connection, I can successfully update records ... > I get a syntax error message. ...
    (microsoft.public.data.ado)
  • Re: Access VBA update recordset error
    ... When I try rsI get a compile error. ... I can successfully update records ... >> I get a syntax error message. ... >> How can I update fields that have spaces in the field name? ...
    (microsoft.public.data.ado)