Solved

VBA Listbox

Posted on 2012-03-23
3
879 Views
Last Modified: 2012-03-23
Can you please help me to add values dynamically to listbox columns.?

The following code giving me an error (2nd line) "Object required"

Me.List_Box_Account.AddItem "my vlaue a1"
            Me.List_Box_Account.Column(0, 1) = "my value a2"


Requirement: Trying to populate Listbox with three columns using vba (access).

Thanks in advance
0
Comment
Question by:gtmathewDallas
  • 2
3 Comments
 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 500 total points
Comment Utility
assuming that you are creating a two column list, try:

    me.list_box_Account.AddItem "my value a1; my value a2"
0
 

Author Comment

by:gtmathewDallas
Comment Utility
Thanks a lot  Fyed,.. Its working for me.., Also I  want to thank you for your other posts- which  helped(helping) me a lot during the development..
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
Comment Utility
Thanks,

Glad to help.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

743 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

16 Experts available now in Live!

Get 1:1 Help Now