VB DataBases - changing RecordSource in code

I am trying to use code to change the RecordSource to
another table, 
and I can't seem to get it to work.  I am using a combobox
as input to 
try to change tables, and I am using ADO.  How do I get this
to work?



 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://grou
ps.yahoo.com/group/helpwithvb/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://
groups.yahoo.com/group/helpwithvb/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:helpwithvb-digest@yahoogroups.com 
    mailto:helpwithvb-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    helpwithvb-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.c
om/info/terms/
 

Good Morning dbussep3.....

Welcome to Professor Smiley's Discussion List.

Are you using Classic VB-6, or is it VB dot Net ?
Are you filling a grid with the table contents ?
Are you using data-bound controls ?
Which controls ?

Either way, a web site that you might find to be
of great use is:
                 www.VB-Helper.com

Search on:   datagrid   or    ADODC    or    ADO

BTW, do you have a name that you use ?

All The Best,
Steve
.
12:36 PM EST Sunday, February 04, 2007
.
.
.
________________________________________
From: helpwithvb@yahoogroups.com 
[mailto:helpwithvb@yahoogroups.com] On Behalf Of dbussep3
Sent: Saturday, February 03, 2007 6:42 PM
To: helpwithvb@yahoogroups.com
Subject: [helpwithvb] VB DataBases - changing RecordSource
in code

I am trying to use code to change the RecordSource to
another table, 
and I can't seem to get it to work. I am using a combobox as
input to 
try to change tables, and I am using ADO. How do I get this
to work?
.
.
 



 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://grou
ps.yahoo.com/group/helpwithvb/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://
groups.yahoo.com/group/helpwithvb/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:helpwithvb-digest@yahoogroups.com 
    mailto:helpwithvb-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    helpwithvb-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.c
om/info/terms/
 

.
Hi Again,

I sent that previous e-mail too quickly...

Here is a specific page that might help you:

( my search term was:   recordsource  )

h
ttp://vb-helper.com/howto_get_datagrid_values.html

..where they say this:

"Display data in a DataGrid control and see what cell
is selected"

"The following code shows how to bind a DataGrid
control to an ADODC 
(ADO Data Control). First, select the Project menu's
Components command. 

Find the Microsoft ADO Data Control and the Microsoft
DataGrid Control 
entries, and select them. Now set the ADODC's ConnectString
and 
RecordSource properties to connect the ADODC to the
database. 

Set the DataGrid's DataSource property to the ADODC."


At the bottom of the page you can download 
the entire project ( small ) as a zipped folder.

Feel free to ask about that process 
if you have not done that before.

All The Best,
Steve
.
12:42 PM EST Sunday, February 04, 2007
.
.

______________________________________
From: helpwithvb@yahoogroups.com 
[mailto:helpwithvb@yahoogroups.com] On Behalf Of dbussep3
Sent: Saturday, February 03, 2007 6:42 PM
To: helpwithvb@yahoogroups.com
Subject: [helpwithvb] VB DataBases - changing RecordSource
in code

I am trying to use code to change the RecordSource to
another table, 
and I can't seem to get it to work. I am using a combobox as
input to 
try to change tables, and I am using ADO. How do I get this
to work?
.
.



 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://grou
ps.yahoo.com/group/helpwithvb/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://
groups.yahoo.com/group/helpwithvb/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:helpwithvb-digest@yahoogroups.com 
    mailto:helpwithvb-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    helpwithvb-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.c
om/info/terms/