Re: ComboBox Row Source = Result of DB Query?

From: Sijin Joseph (sijinNOSPAMdotnet_at_hotmail.com)
Date: 09/26/04 

Date: Sun, 26 Sep 2004 20:26:15 +0530

The easiest way would be to drag the table from server explorer (you
will need to create a new DB connection to the access table in the
server explorer to be able to view the table) onto your form, the
required connections and adapters get automatically setup, create a
dataset by r-clicking on the adapter, next set the datasource property
of the combo to the dataset.

These articles describe this in detail
http://www.developer.com/net/vb/article.php/3092741
http://www.startvbdotnet.com/ado/server.htm

Sijin Joseph
http://www.indiangeek.net
http://weblogs.asp.net/sjoseph

Zachary Turner wrote:
> I have an access database and I want to populate a combo box with the
> contents of a Table in my access database. What is the best way to do
> it? I was trying to do it at design time, but not sure if it can be
> done.

Relevant Pages

  • C# How to access the Connection established in server explorer
    ... I have established a connection to the MS Access database in the ... do i hav to write all the code we write when don't use server ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Odd network results from two installed adapters, wired/wirelss
    ... system has both wired and wireless adapters, ... I can't seem to establish any network ... Connection Type: Dynamic ...
    (microsoft.public.windowsxp.network_web)
  • Re: How to use access query computed fields in Word mailmerge
    ... Once you have gone through the connection process once, ... To make a DDE connection in code from Word 2000/2002 I think you will need ... My access databases have lots of these computed query ... >>> an access database with any data in it. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: How to stop source prompt in mail merge from access
    ... Are you calling OpenDataSource in your Access code? ... connection from the Word mail merge main document because Word will try to ... > The mail merge is being called from the Access database via a Visual Basic ...
    (microsoft.public.word.mailmerge.fields)
  • Re: error messages when connecting to an MS Access query
    ... I'm actually opening the Word document from VBA in the Access database, ... It's actually easy to run a Make Table query in Access, ... I got messages saying it couldn't make the connection. ... When you try to make a DDE connection, if the database is not already ...
    (microsoft.public.word.mailmerge.fields)