[ Home  |  FAQ-Related Q&As  |  General Q&As  |  Answered Questions ]

    Search the Q&A Archives

...fill in a list box from using an access database

<< Back to: FAQ: comp.lang.basic.visual VB/Win Commercial VBX List

Question by liv
Submitted on 2/4/2004
Related FAQ: FAQ: comp.lang.basic.visual VB/Win Commercial VBX List
Rating: Not yet rated Rate this question: Vote
How do you fill in a list box from using an access database


Answer by sravan
Submitted on 6/25/2004
Rating:  Rate this answer: Vote
take a list box named list1

now here the code by using ado controls

---code starts here

in references check the ms adodb 2.1 library

dim cn as new adodb.conncetion
dim rs as new adodb.recordset

in form load
cn.open "Enter dsn name"

set rs=cn.execute("select * from table")

if rs.eof =false then
while not rs.eof
list1.additem rs(0)'''get the required file
  rs.movenext
wend
end if

 

Answer by lizzybaby
Submitted on 3/8/2006
Rating: Not yet rated Rate this answer: Vote
Great site, I like it

 

Your answer will be published for anyone to see and rate.  Your answer will not be displayed immediately.  If you'd like to get expert points and benefit from positive ratings, please create a new account or login into an existing account below.


Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer:

FAQS.ORG reserves the right to edit your answer as to improve its clarity.  By submitting your answer you authorize FAQS.ORG to publish your answer on the WWW without any restrictions. You agree to hold harmless and indemnify FAQS.ORG against any claims, costs, or damages resulting from publishing your answer.

 

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

 

<< Back to: FAQ: comp.lang.basic.visual VB/Win Commercial VBX List

[ Home  |  FAQ-Related Q&As  |  General Q&As  |  Answered Questions ]
© 2008 FAQS.ORG. All rights reserved.