Results 1 to 5 of 5

Thread: [Resolved] Access VBA - Listbox Additem equivalent

  1. Feb 3rd, 2003, 03:36 PM #1
    Bruce Fox
    Bruce Fox is offline

    Thread Starter
    INXSIVE Bruce Fox's Avatar
    Join Date
    Sep 2001
    Location
    Melbourne, Australia
    Posts
    7,429

    [Resolved] Access VBA - Listbox Additem equivalent

    Hi Guys,


    I'm trying to add table data from the current M$ Access recordset
    into a (VBA) ListBox.


    Can't figure out the syntax tho.
    Eg: What is the VBA ListBox equivalent of (ListBox) .AddItem?



    Regards,
    Bruce.
    Last edited by Bruce Fox; Feb 3rd, 2003 at 04:33 PM.
    Reply With Quote Reply With Quote
  2. Feb 3rd, 2003, 04:17 PM #2
    ralph
    ralph is offline
    Fanatic Member
    Join Date
    Aug 2001
    Location
    Connecticut
    Posts
    855
    create a string, sItems (semicolon delimited, I think)
    then
    List1.RowSource = sItems
    Last edited by ralph; Feb 3rd, 2003 at 04:22 PM.
    VB 6.0, Access, Sql server, Asp
    Reply With Quote Reply With Quote
  3. Feb 3rd, 2003, 04:24 PM #3
    Ephesians
    Ephesians is offline
    Hyperactive Member
    Join Date
    Mar 2002
    Posts
    424
    Just make sure you've changed the listbox RowSourceType to value list first..

    Erin
    Reply With Quote Reply With Quote
  4. Feb 3rd, 2003, 04:26 PM #4
    Bruce Fox
    Bruce Fox is offline

    Thread Starter
    INXSIVE Bruce Fox's Avatar
    Join Date
    Sep 2001
    Location
    Melbourne, Australia
    Posts
    7,429
    I'll give it a go......
    Reply With Quote Reply With Quote
  6. Feb 3rd, 2003, 04:33 PM #5
    Bruce Fox
    Bruce Fox is offline

    Thread Starter
    INXSIVE Bruce Fox's Avatar
    Join Date
    Sep 2001
    Location
    Melbourne, Australia
    Posts
    7,429
    Thanks guys, that worked



    Bruce.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width