Re: Access VBA update recordset error

From: Victor Koch ("Victor)
Date: 10/28/04 

Date: Thu, 28 Oct 2004 13:54:20 -0300

rs("[field 1]") = "blah"
rs.update 

--
 Víctor Koch.
"cityofgp" <cityofgp@discussions.microsoft.com> escribió en el mensaje
news:FB8B3D87-5187-44A8-A150-4609ED660939@microsoft.com...
> 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)
  • Access VBA update recordset error
    ... Using ADODB.recordset and connection, I can successfully update records using: ... I get a syntax error message. ... TIA. ...
    (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)