Codejock Developer Community : Deleting Incorrect Row http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 28 Apr 2026 19:16:52 +0000 Sun, 09 May 2010 05:31:01 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=16664 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Deleting Incorrect Row : Hi, Is your issue related to...]]> http://forum.codejock.com/forum_posts.asp?TID=16664&PID=58381&title=deleting-incorrect-row#58381 Author: Aaron
Subject: 16664
Posted: 09 May 2010 at 5:31am

Hi,
 
Is your issue related to https://forum.codejock.com/forum_posts.asp?TID=11560 Are you removing records within the SelectedRows collection? If I remove a record with .RemoveRecordEx(row.record)  or  .RemoveAt(row.record.index) method shouldn't make a difference. Can you show code you used when it didn't work?
 
Thanks
 
]]> Sun, 09 May 2010 05:31:01 +0000 http://forum.codejock.com/forum_posts.asp?TID=16664&PID=58381&title=deleting-incorrect-row#58381 <![CDATA[Deleting Incorrect Row : using the rptMainMessages.Remo...]]> http://forum.codejock.com/forum_posts.asp?TID=16664&PID=58350&title=deleting-incorrect-row#58350 Author: XiMaker
Subject: 16664
Posted: 06 May 2010 at 2:11pm

using the rptMainMessages.RemoveRecordEx(row.Record.Index); seems to have done the trick - I was consistently having the problem before using the RemoveAt and have not been able to reproduce the problem at all when using RemoveRecordEx - thanks...]]> Thu, 06 May 2010 14:11:48 +0000 http://forum.codejock.com/forum_posts.asp?TID=16664&PID=58350&title=deleting-incorrect-row#58350 <![CDATA[Deleting Incorrect Row : Possibly you want rptMainMessa...]]> http://forum.codejock.com/forum_posts.asp?TID=16664&PID=58349&title=deleting-incorrect-row#58349 Author: SuperMario
Subject: 16664
Posted: 06 May 2010 at 1:42pm


Possibly you want

rptMainMessages.Records.RemoveAt(row.Record.Index);
rptMainMessages.Populate();

OR

rptMainMessages.RemoveRecordEx(row.Record.Index);
rptMainMessages.RowEx(row);

OR

Sub Delete()
Dim i As Long, Row As ReportRow
 If lst.SelectedRows.Count = 0 Then
    If lst.Records.Count = 0 Then
       Debug.Print "No Row(s) Exist to Remove"
    Else
       Debug.Print "Select The Row(s) you want to remove"
    End If
 ElseIf lst.SelectedRows.Count >= 1 Then
         Debug.Print "Ready TO Remove : " & lst.SelectedRows.Count & " Row(s)"
         If MsgBox("Are You Sure", vbInformation + vbYesNo) = vbNo Then
           lblStatus.Caption = "Remove cancelled"
           Exit Sub
         End If

         For Each Row In lst.SelectedRows
             Delete Row
             lst.Records.RemoveAt (Row.Record.Index)
         Next
        
         Debug.Print "Selected Rows removed successfully"
         lst.Populate
 End If
End Sub

]]> Thu, 06 May 2010 13:42:19 +0000 http://forum.codejock.com/forum_posts.asp?TID=16664&PID=58349&title=deleting-incorrect-row#58349 <![CDATA[Deleting Incorrect Row : I have an odd issue where I am...]]> http://forum.codejock.com/forum_posts.asp?TID=16664&PID=58348&title=deleting-incorrect-row#58348 Author: XiMaker
Subject: 16664
Posted: 06 May 2010 at 1:09pm

I have an odd issue where I am deleting records from the reportcontrol and everything works like it should most of the time but at some point even when nothing else has changed, it will start deleting rows 2 or 3 lines below where the focusedrow is located.   during the debug phase I can see that the selectedrow.record contains the correct information that should be deleted but when I issue the removeat and then populate the row 2 or 3 lines below will go away. if I try to delete the same row again it throws an error like the correct row does not exist but it is showing on the reportcontrol row.   ANY IDEAS?]]> Thu, 06 May 2010 13:09:03 +0000 http://forum.codejock.com/forum_posts.asp?TID=16664&PID=58348&title=deleting-incorrect-row#58348