Refresh datalist contents

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Martin Wulfe

    Refresh datalist contents

    I want to use a connection to an existing MS Access database, but I want
    to be able to change which table is used to fill the datalist, using
    VB6, at run time by late binding the datalist to the table. Using
    either an ADO connection or an ADODC control, I can fill the datalist OK
    the first time, but when I try to clear it and fill it from another
    table, the contents of the datalist do not change. I must be doing
    something really dumb here, but I can't figure it out. Any help would
    be appreciated.

    TIA,

    Martin

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
  • Larry  Linson

    #2
    Re: Refresh datalist contents

    There are some people here who use (or used to use) VB, in addition to
    Access, but it's primarily devoted to the Access product, not to all users
    of Jet databases. This question would definitely have a better chance of
    getting a good answer if asked in a Visual Basic newsgroup... USENET
    newsgroups comp.lang.basic .visual.misc and comp.lang.basic .visual.databas e
    are two; there are other sponsored newsgroups at news.microsoft. com (a free
    news server).

    I'm even having some difficulty remembering what a "datalist" is -- do you
    mean a List Box Control?

    Larry Linson
    Microsoft Access MVP




    "Martin Wulfe" <surveyman45-devx@yahoo.com> wrote in message
    news:3ff4d792$0 $202$75868355@n ews.frii.net...[color=blue]
    > I want to use a connection to an existing MS Access database, but I want
    > to be able to change which table is used to fill the datalist, using
    > VB6, at run time by late binding the datalist to the table. Using
    > either an ADO connection or an ADODC control, I can fill the datalist OK
    > the first time, but when I try to clear it and fill it from another
    > table, the contents of the datalist do not change. I must be doing
    > something really dumb here, but I can't figure it out. Any help would
    > be appreciated.
    >
    > TIA,
    >
    > Martin
    >
    > *** Sent via Developersdex http://www.developersdex.com ***
    > Don't just participate in USENET...get rewarded for it![/color]


    Comment

    • Martin Wulfe

      #3
      Re: Refresh datalist contents

      Larry -

      Thanks for the quick response. No, the datalist is a separate control,
      in MSDATLST.OCX. I will try the other groups.

      Martin



      *** Sent via Developersdex http://www.developersdex.com ***
      Don't just participate in USENET...get rewarded for it!

      Comment

      Working...