Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
  1. #16
    ksor's Avatar
    ksor is offline Competent Performer
    Windows 10 Access 2010 32bit
    Join Date
    Feb 2017
    Posts
    126
    Quote Originally Posted by ksor View Post
    Yeah, I think so too ...



    On the other hand I think I just "designed and coded by the book" so I think it's a Little wired that it fails ;-((

    But thx for your time anyway !
    Yeah, it's declared in a general declaring module of mine and I need it to test if the user has selected more than 1 record for deleting.

    The user should ONLY select 1 record because of the handling of the related file on the disk.

  2. #17
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    The more I look at the code the less I understand the use of that global variable. SelHeight tells how many records are selected. Why do you need a variable? I don't see how that variable really accomplishes anything, especially since you only want to allow deletion of 1 record. I have code that allows user to select and delete multiple records and do have a public variable that keeps count of records as code cycles to delete each.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #18
    ksor's Avatar
    ksor is offline Competent Performer
    Windows 10 Access 2010 32bit
    Join Date
    Feb 2017
    Posts
    126
    Quote Originally Posted by ksor View Post
    Yeah, it's declared in a general declaring module of mine and I need it to test if the user has selected more than 1 record for deleting.

    The user should ONLY select 1 record because of the handling of the related file on the disk.
    Maybe I can do some changes there ... but I'm sure it has NO effects at all on the original problem ;-))

    but I'll look into that too now that I have to do some analyzing of that code.

  4. #19
    ksor's Avatar
    ksor is offline Competent Performer
    Windows 10 Access 2010 32bit
    Join Date
    Feb 2017
    Posts
    126
    I tryed inserting this:



    DoCmd.RunSQL "DELETE FROM PERS_SOCHÆN WHERE PERS_SOCHÆN.SocHID =" & SocHID


    in the form-delete event and it does what I want it to do BUT ...



    1) all my handling of related Word-files is NOT done

    2) the proces is NOT completed because of multiuserproblems (Error 3197)



    HELPPPPPPPPPPPPP !

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Resetting form to original status on record change
    By Thompyt in forum Programming
    Replies: 8
    Last Post: 11-18-2014, 08:09 PM
  2. Check if record exist and update the status
    By JustinC in forum Access
    Replies: 4
    Last Post: 08-17-2014, 01:39 PM
  3. Replies: 4
    Last Post: 06-20-2013, 10:26 PM
  4. Auto status a record
    By yes sir in forum Database Design
    Replies: 6
    Last Post: 06-11-2012, 08:46 PM
  5. Trying to Delete record using delete query
    By MooseOTL in forum Access
    Replies: 13
    Last Post: 10-04-2011, 02:30 AM

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