Results 1 to 5 of 5
  1. #1
    fluppe is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2014
    Posts
    48

    VBA Recordset.Update doesn' run with args ...

    Hello again,

    ... i think i'm getting mad about it ...
    Code:
    ...
    tmp_tbl.Update    'works
    
    tmp_tbl.Update arg1, arg2  ' does not work
    arg1 = 4 (is a Long)


    arg2 = True (is bool)

    Is there something i totally missunderstood in the Documentation ?
    ... anyone: please tell me what
    What is the problem about it ?

    Well, what i need to use is the FORCE flag to omit the "... edited by another ..." - warnings. So if someone can tell me how to achieve that, it would be great.

    Thanks for reading this and best regards,

    ...

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,549
    Update does not have arguments.
    The query can but not the update command.

  3. #3
    fluppe is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2014
    Posts
    48
    Well, i was mistaken about that maybe because of this http://msdn.microsoft.com/en-us/libr...ice.15%29.aspx chapter of the Documentation ...
    I thought this would apply to my settings as well. But maybe it is a version- issue, or whatever ....
    In the examples the method does not get arguments passed either, so .... well, i find it confusing however, but THANKS A LOT.
    Is it a proper way to solve that problem by using
    Code:
     Me.dirty = False
    ?

    Kind regards,

    ...

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    If you want to save a form's current record use

    If me.dirty then me.dirty = false

  5. #5
    fluppe is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2014
    Posts
    48
    Hello,

    that's an answer. I'll make it that way.
    Thanks ...

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Navigation pane doesn't update until I press F5
    By Glenn_Suggs in forum Access
    Replies: 0
    Last Post: 02-18-2014, 12:43 PM
  2. Replies: 3
    Last Post: 01-31-2014, 09:13 AM
  3. Subform table doesn't update
    By hilian in forum Forms
    Replies: 4
    Last Post: 07-27-2012, 04:24 PM
  4. Why doesn't the table & Query update?
    By U810190 in forum Forms
    Replies: 1
    Last Post: 03-29-2010, 04:07 AM
  5. Form doesn´t update with Query.
    By disturbedgod in forum Forms
    Replies: 10
    Last Post: 02-09-2010, 02:00 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums