Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

loop a list box in access 2013 form

Posted on 2013-06-11
3
Medium Priority
?
634 Views
Last Modified: 2013-06-11
hi


i have a listbox in a form in access and i want to make some stuff on every row in the list box how can i loop the entire list box

how i write while not end of the listbox? and what to write when i want to  move to a next record?
0
Comment
Question by:bill201
3 Comments
 
LVL 29

Accepted Solution

by:
IrogSinta earned 1200 total points
ID: 39239642
This may get you started:
   
    Dim i As Integer
    
    For i = 0 To Me.NameOfListbox.ListCount - 1
        Debug.Print Me.NameOfListbox.Column(0, i)
    Next

Open in new window

0
 
LVL 21

Assisted Solution

by:Boyd (HiTechCoach) Trimmell, Microsoft Access MVP
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 800 total points
ID: 39239643
0
 

Author Closing Comment

by:bill201
ID: 39239662
Many thanks
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
If you are a mobile app developer and especially develop hybrid mobile apps then these 4 mistakes you must avoid for hybrid app development to be the more genuine app developer.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
Progress

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question