![]() |
Report control instead of listview |
Post Reply ![]() |
Author | |
cjzer ![]() Newbie ![]() Joined: 14 January 2009 Location: Philippines Status: Offline Points: 7 |
![]() ![]() ![]() ![]() ![]() Posted: 07 February 2009 at 9:28am |
![]() Public Sub Populate() Dim i As Integer Set rs = New ADODB.Recordset 'If rs.State = 1 Then rs.Close rs.Open "SELECT DISTINCT studentno, fname FROM studentinfo;", db, adOpenDynamic, adLockPessimistic lstSubject.ListItems.Clear i = 1 While rs.EOF = False lstSubject.ListItems.Add lstSubject.ListItems(i).Text = rs(0) lstSubject.ListItems(i).SubItems(1) = rs(1) i = i + 1 rs.MoveNext Wend rs.Close Set rs = Nothing End Sub '================================================== I used the code above but it won't work when I use it to the report control... I'm confused ... I can't understand the samples of report control please help ![]() ![]() I want to use the report control using the recordset. Please help for the codes... thanks... ![]() |
|
![]() |
|
Aaron ![]() Senior Member ![]() Joined: 29 January 2008 Status: Offline Points: 2192 |
![]() ![]() ![]() ![]() ![]() |
Product: Xtreme SuitePro (ActiveX) version 15.0.2
Platform: Windows XP (32bit) - SP 2 Language: Visual Basic 6.0 Zero replies is not an option.... |
|
![]() |
|
cjzer ![]() Newbie ![]() Joined: 14 January 2009 Location: Philippines Status: Offline Points: 7 |
![]() ![]() ![]() ![]() ![]() |
thanks...
![]() |
|
![]() |
Post Reply ![]() |
|
Tweet
|
Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |