Refresh datalist contents - Microsoft Access / VBA

Martin Wulfe

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!

Nov 12 '05 #1

Subscribe Post Reply

2616

Larry Linson

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.database
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" <su**************@yahoo.com> wrote in message
news:3f*********************@news.frii.net...

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!

Nov 12 '05 #2

Martin Wulfe

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!

Nov 12 '05 #3

Similar topics

usercontrol refresh

by: Rob Koch | last post by:

What's the best way to refresh a usercontrol using a parameter? My usercontrol is just a DataList that retrieves data from SQL in association with a public propterty. I click on a LinkButton in...

ASP.NET

Postback, DataBinding, Refresh

by: John | last post by:

Hi - I've got a couple of pages where a DataList is populated only if(!Postback). I have buttons in the datagrid that allow for the 'deletion' of items from that DataList. The problem is that...

ASP.NET

Help Needed -- Datalist linkbutton

by: Bharat | last post by:

Hi Folks, Suppose I have two link button on a page (say lnkBtn1 and lnkBtn2). On the click event of the lnkbtn1 I have to add a dynamically created control. And On the click event of the lnkBtn2 I...

ASP.NET

DataList with checkbox Postback Problem

by: Glenn Owens | last post by:

Here's the scenario: I have a DataList populated from a datatable sitting inside a fieldset. Each element (row) in the Datalist has the following child controls: asp:checkbox, asp:image,...

ASP.NET

What print options from ascx control with datalist

by: yer darn tootin | last post by:

Ahoy, I have an aspx web page that loads an ascx control that's populated with various items ( in a datalist ). Select an item and the page reloads and the datalist now shows the details. ...

ASP.NET

How do I add rows to a DataList without losing state of controls?

by: bryanp10 | last post by:

I have a DataList on my page which contains multiple DropDownLists. My page defaults to showing six rows in the DataList. I want the ability to dynamically add rows if needed. Right now I'm just...

ASP.NET

Nested datalist - parent datalist refresh

by: schapopa | last post by:

Hi, I have nested datalist and I have some events that work, but I cannot find out how to refresh child and parent datalist after executing events on the child datalist. My childdatalist is an...

ASP.NET

Reading contents of DataList problem

by: David | last post by:

Hi, This one appears a little strange to me. Here is the scenario. I load a datalist the first time a page is run. The page has a !IsPostback and the datalist gets loaded at this point. I...

ASP.NET

Refresh Trigger

by: Peter | last post by:

ASP.NET 3.5 I have a web page and this web page has a DataList, when user hovers the mouse over a picture in the datalist a popup appers, this popup is a User Control and it has a cancel button....

ASP.NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++