![]() |
Report control instead of listview |
Post Reply
|
| Author | |
cjzer
Newbie
Joined: 14 January 2009 Location: Philippines Status: Offline Points: 7 |
Post Options
Thanks(0)
Quote Reply
Topic: Report control instead of listviewPosted: 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 |
Post Options
Thanks(0)
Quote Reply
Posted: 10 February 2009 at 12:26pm |
|
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 |
Post Options
Thanks(0)
Quote Reply
Posted: 11 February 2009 at 12:00am |
|
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 |