Re: VB DataBases - changing RecordSource in code

.

Hi Dan,

Happy the link was of some help, and I think 
you will find that particular web site to be 
very valuable as you attempt to overcome the 
many little stumbling blocks that will appear, 
unexpectedly, in your path.

You can read 16 books, day-in, and day-out,
but nothing beats typing in the code
( up to a point ).

...typing in the new and important code
is the part you need to type into the
VB-6 Editor, while any other code that
you are now familiar with can be an
exercise in copy and paste.

Learning how to program is really
a multi-step, or multi-level, experience.

Take advantage of the code examples on the web,
and see what the code does, and figure out 
why the code does what it does.

You need to design the form layouts so 
they are both pleasing and effective,
and make some sense.

Look at, read through, and play around with,
all of the code snippets  at www.FreeVBcode.com

Oh, ...and don't forget the true advantages
of drawing things on paper, and letting shapes
represent certain tasks to accomplish, with
fancy arrows making their way to the next thing.

Seriously.  It really helps at times.

Other than that....

You need to identify what the User really
wants, or needs, and then you have to be
able to formulate a plan to make that work.

Your plan needs to anticipate what the User
will do 'wrong', and how they can mess things up.

You need to develop the ability to 'step back'
when things are getting difficult, and take
a look at the broad picture, to see if you have
navigated off-course to cause your difficulties.

You need to learn how to search the Internet
using the correct ( narrow and specific ) words.

Believe me, anything you, me, and Bob, can think
of doing with VB-6 code, has already been done
ten thousand times before, and at least 2 or 3
nice people have published a sample on the Web.

We just need to find it  < g >

So, how can the people on this list help you ?

Well, first, they expect you to try and solve
your own problems, but no one here expects you
( nor wants you to ) waste several hours 
trying to locate an answer to a question.

If you show everyone that you are trying on
your own, a tonne of people will help you out.

Question:  
I'm trying to allow the User to move
some customer data ( Name and SSN ) into my
textboxes by selecting a customer from a List.

I can get the name into the box, but is there
a good way to get the correct SSN into a box ?

Answer:
Often we will explain in words what you need to do,
rather than provide code, unless we know that
a certain task is a well defined stumbling block,
and then we will type in some code with our answer.

Or, rather than spend 16 hours typing the answer 
into an e-mail, we might often suggest an example 
project located on the Web, and suggest 
that you download the project and 
play with / experiment with / dissect  that code.

In any event, don't hesitate to ask a question, or
throw an idea on our table to see if it is a good idea.

There are many people here who will help you.


All The Best,
Steve
.
13:39 EST Tuesday, February 06, 2007
.
.
.
________________________________________
From: helpwithvb@yahoogroups.com 
[mailto:helpwithvb@yahoogroups.com] 
On Behalf Of dbussep3yahoo.com
Sent: Tuesday, February 06, 2007 10:42 AM
To: helpwithvb@yahoogroups.com
Subject: Re: [helpwithvb] 
         VB DataBases - changing RecordSource in code

Steve,
 
Thanks for the help.  I think the link you sent me will
help.  
I am so new to programming, that I have obtained a couple of
books 
to help me learn more.  I can do all the work such as set up
and 
build the forms, and set the properties, and all that, but 
I don't know enough at this point about the code.  

I need to learn that part of it more.  

If you know any good resources for learning the code part 
of VB-6 programming, I would sure appreciate that info.

Thanks again for the help.
 
Dan
.
.
----- Original Message ----
From: Steve Manser <smansertwcny.rr.com>
To: helpwithvb@yahoogroups.com
Sent: Sunday, February 4, 2007 12:42:32 PM
Subject: RE: [helpwithvb] VB DataBases - changing
RecordSource in code
.
Hi Again,

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

Here is a specific page that might help you:

( my search term was: recordsource )

http://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: helpwithvbyahoogro ups.com 
[mailto:helpwithvbyahoogro ups.com] On Behalf Of dbussep3
Sent: Saturday, February 03, 2007 6:42 PM
To: helpwithvbyahoogro ups.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/