Results 1 to 5 of 5

Thread: Combo/List box

  1. #1
    Join Date
    Jul 2003
    Location
    Portugal
    Posts
    111

    Unanswered: Combo/List box

    Using Access 2k additem and removeitem gives a compile error: Method or data member not found.

    Access 2k doesn't support these features or do I need to select some Reference? In this case, what Reference? I tried some and nothing...

    Thank you.

    Regards

    Ruas

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: Combo/List box

    Originally posted by jmruas
    Using Access 2k additem and removeitem gives a compile error: Method or data member not found.

    Access 2k doesn't support these features or do I need to select some Reference? In this case, what Reference? I tried some and nothing...

    Thank you.

    Regards

    Ruas
    Nope. Doesn't support them. You have to go to 2002 to get those methods. You have to concat and assign with the RowSource or use a table/query ...

  3. #3
    Join Date
    Jul 2003
    Location
    Portugal
    Posts
    111
    Yes, that's true.

    But... after searching, I found in this forum the solution post sometime ago.

    It can be found here:
    http://www.dbforums.com/showthread.p...ght=removeitem

    Thank you for your post.

    Ruas

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Originally posted by jmruas
    Yes, that's true.

    But... after searching, I found in this forum the solution post sometime ago.

    It can be found here:
    http://www.dbforums.com/showthread.p...ght=removeitem

    Thank you for your post.

    Ruas
    And if you noticed ... I was part of that also.

  5. #5
    Join Date
    Jul 2003
    Location
    Portugal
    Posts
    111
    And with an important contribute:

    "ListBoxes for Access 2000 and before do not have the AddItem method like 2002 does ... You have to use the Value List and Row Source concatenation or build a table/query that populates the ListBox."

    and

    "the available space of the row source is only 2K ... So if the items to be added will total to lesss than 2K it's fine. 1 character over that and you might as well make a temp table to store the listbox values in and query from that."

    Sorry, Owen, for the "lapsus".

    Ruas

Posting Permissions

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