CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. May 17th, 1999, 09:09 AM #1
    Vlad Chapranov
    Vlad Chapranov is offline Member
    Join Date
    Apr 1999
    Location
    Brooklyn, NY USA
    Posts
    171

    Update with Null

    How to update the Date or other type field in Access db with Null value? After that I'd like to see empty cell, the same as it was before something was entered in that field.
    Thank you
    Vlad

    Reply With Quote Reply With Quote
  2. May 17th, 1999, 09:19 AM #2
    Lothar Haensler
    Lothar Haensler is offline Elite Member
    Join Date
    May 1999
    Posts
    3,332

    Re: Update with Null

    did you try

    yourRecordSetVariable.Edit
    yourRecordSetVariable.fields("yourfield").value = null
    yourRecordSetVariable.Update



    ?

    Reply With Quote Reply With Quote
  3. May 17th, 1999, 10:02 AM #3
    Vlad Chapranov
    Vlad Chapranov is offline Member
    Join Date
    Apr 1999
    Location
    Brooklyn, NY USA
    Posts
    171

    Re: Update with Null

    I'm stupid. I tryed everything (VBNullDate, VBNullString, "" and so on) except this.
    Thank you very much
    Vlad

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules




Click Here to Expand Forum to Full Width

Featured