Solved

loop a list box in access 2013 form

Posted on 2013-06-11
3
579 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 300 total points
Comment Utility
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 200 total points
Comment Utility
0
 

Author Closing Comment

by:bill201
Comment Utility
Many thanks
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

762 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now