Re: Access VBA update recordset error

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

  • Next message: Gianluca: "MDAC 2.8 vs MDAC 2.7" 
    Date: Thu, 28 Oct 2004 10:53:02 -0700

    When I try rs("[field 1]") I get a compile error.

    "Victor Koch" wrote:

    >
    > 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.
    > >
    >
    >
    >

  • Next message: Gianluca: "MDAC 2.8 vs MDAC 2.7"

    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: Sending email to multiple recepients from Groupwise
      ... I used your code and got a Compile Error: Syntax Error message. ... may have been the double quotes before the semi colon and Deputy Chief but ...
      (microsoft.public.access.forms)
    • 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)
    • 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: Sorting an Address list - 1 attachment
      ... I created the custom function you suggested. ... "Compile Error: Syntax error message." ... I am getting an education!! ...
      (microsoft.public.excel.programming)