+ Reply to Thread
Results 1 to 5 of 5

2D dynamic array to Access Form ListBox

  1. #1
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    2D dynamic array to Access Form ListBox

    Hi,

    Simple but don't have much experience with Access VBA

    Have a 2D array (Employees) that the Rows and Column of which will vary
    And in Form_Load() event I want to load this array into the listbox as we do in Excel listbox
    Please Login or Register  to view this content.
    But google did not return me some thing like that.

    Any idea?

    Help would be greatly appreciated.

    Best Regards

    Imran Bhatti
    Teach me Excel VBA

  2. #2
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: 2D dynamic array to Access Form ListBox

    Any idea please?

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: 2D dynamic array to Access Form ListBox

    You can't do that with an Access form. You'd have to loop and create a string delimited with semicolons and then assign that to the Rowsource property.
    Rory

  4. #4
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: 2D dynamic array to Access Form ListBox

    Thanks rorya for clarifying

    I was thinking there is a short way to load 2D array into Access form ListBox as we do in Excel userform.

  5. #5
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: 2D dynamic array to Access Form ListBox

    No, not really. They tend to be bound to queries generally.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] populating a listbox with dynamic array
    By bqheng in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-02-2018, 09:27 PM
  2. Show dynamic values at listbox depending value selected another listbox
    By Judith_Chao in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2017, 08:30 AM
  3. Help with a Dynamic array in VBA (to fill a listbox)
    By yoursamrit2000 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-28-2015, 02:51 PM
  4. Access form works with access Viewer but not full version of Access?
    By Shanyn in forum Access Tables & Databases
    Replies: 1
    Last Post: 10-22-2014, 01:14 PM
  5. [SOLVED] A re-usable Form with a listbox filled with an array defined when .SHOW - how to define?
    By Skotzmun in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-16-2013, 10:20 AM
  6. Access Dynamic Array from ThisWorkBook to Sheet1
    By broro in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-08-2012, 07:04 PM
  7. [SOLVED] Populate Listbox with all rows of a dynamic array where elements of a single array match.
    By Tayque_J_Holmes in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 08-07-2012, 04:54 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1