---

Hi,

I'm rather new in reading databases using VB. A question about reading an
Access-databse.

How can I display a field of a database in a listbox from record FIRST till
record LAST. I think I haven to use a loop but I don't know how.


Private Sub Command1_Click()
Data1.RecordSet.Move First

' ## start loop
' display Filed "PageNumber"

List1.AddItem "PageNumber"
' ## end loop
End Sub


Thanks,

Sjoerd

---

I news:ck3g3k$nqe$1@news6.zwoll1.ov.home.nl,
skrev asd987 <asd987@home.nl>:
> Hi,
>
> I'm rather new in reading databases using VB. A question about
> reading an Access-databse.
>
> How can I display a field of a database in a listbox from record
> FIRST till record LAST. I think I haven to use a loop but I don't
> know how.
>
>
Private Sub Command1_Click()
myRecordSet.MoveFirst
Do While Not myRecordSet.EOF
List1.AddItem myRecordSet("PageNumber")
myRecordSet.MoveNext
Loop
End Sub

Remember some error handeling in case your recordset is empty or your field
is Null


--
mvh
Jens Vestergaard (mailadr i dette indlæg er ikke gyldig!)
www.railsoft.dk
Døgnets jernbanenyheder: www.railsoft.dk/medier.asp