Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    Hertfordshire, England
    Posts
    78

    Question Unanswered: Set a Field to Null

    Does anyone know if it's possible to set a field to Null using VBA? I know you can set it to blank using [field] = "" but I need it to be null.

    Back end is SQL Server 2000.

    Thanks

    Neil.

  2. #2
    Join Date
    Sep 2003
    Location
    T.O.
    Posts
    326
    I'm assuming you mean a field to Null on one record, and that record has a recordID, otherwise you will need what M$ calls interoperability.

    currentproject.connection.execute "UPDATE TableName SET FieldYouCareAbout = Null WHERE recordID = " & YourRecordID
    All code ADO/ADOX unless otherwise specified.
    Mike.

  3. #3
    Join Date
    Sep 2003
    Location
    Hertfordshire, England
    Posts
    78
    Thanks that sounds good.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •