Results 1 to 6 of 6

Thread: How can I put the colums of my database in separate colums in my listbox?

  1. #1

    Thread Starter
    New Member
    Join Date
    Apr 2002
    Location
    Belgium
    Posts
    7

    How can I put the colums of my database in separate colums in my listbox?

    The subject says it all, doesn't it??
    How can I put the columns of my database in separate columns in my listbox? So I want to make a selection list in my listbox and the shown data comes from a SQL server. There are multiple lines.

    Note that I'm totally new to vb, so be gentle with me

  2. #2
    Member
    Join Date
    Sep 2001
    Location
    Mexico
    Posts
    33
    you might find the DataGrid Control more usefull than a listbox for what youre trying to do.

  3. #3

    Thread Starter
    New Member
    Join Date
    Apr 2002
    Location
    Belgium
    Posts
    7
    Is that available in VBA for MS Office?
    I don't find that component.

    Thx 4 the quick reply.

  4. #4

    Thread Starter
    New Member
    Join Date
    Apr 2002
    Location
    Belgium
    Posts
    7
    OK I found it!
    But when I try to use it, it says "cannot create... because of wrong licence"
    Seems like I will have to use listbox after all.

  5. #5
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170
    I don't believe you need a license to work with the DataGrid. Are you sure you've set the correct component?

    If you DO have that problem, then:
    You can't do that in a listbox. How bout going for a flexgrid? It'll require you to explicitly code it, but you get the results you want. DO you know ADO?

  6. #6

    Thread Starter
    New Member
    Join Date
    Apr 2002
    Location
    Belgium
    Posts
    7
    Can I just insert a datagrid or do I first have to insert another component?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width