• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 665
  • Last Modified:

VBA - Databinding mysql database table to listbox

Hi,

I am very new to VBA.  Can someone give me a tutorial or example of how to databind a field in a mySQL table to a listbox?

Thanks
0
NerishaB
Asked:
NerishaB
1 Solution
 
jkpieterseCommented:
You'd have to use something like ADO to fetch a recordset from the mySQL table and then populate the listbox with the values in the returned recordset. See this site for examples on working with ADO:
http://www.erlandsendata.no/english/index.php?t=envbadac
0
 
NorieVBA ExpertCommented:
Where is your listbox?

Access?

MySQL?

Excel?
0
 
NerishaBAuthor Commented:
Thanks, the examples helped me alot.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now