BEWARE beginner questions!!

I have some experience in Access but never as much as I want or need. I have
decided to get in on VB.Net. I would only
rate myself in Access as a Beginner/Intermediate VBA programmer. I have
decided to go at learning VB.Net in a
more organized manner. I have some questions where answers are not becoming
clear with VB.Net. So here goes.

1 All of the books I have accessed do basic one-two form examples utilizing
one or two basic tables. I have used
Dobson's book and created two datagrids on the same form using the
Relationship wizard. What I can't see and
I am wondering about is what code uses the Primary/Foreign key and ties the
two datagrids together. I have a major Access database that combines
multiple tables that have relationships. But I probably will be using
combinations of individual textboxes and datagrid to display the data on one
or more forms. I need to know how to keep all data synched.

2. I am assuming that a data connector and data adapter is needed for each
table or query that is used on the form. Correct?

3. What is the standard for program development in relationship to
resolution? Are most people developing for 800 x 600 or 1024 x 764 when the
ultimate end-user is unknown?

4. One thing I have never figured out is how to size/auto resize a form. How
do I work with the answer to #3 and allow the form still be displayed
properly in the other resolution?

Thank you for any and all answers.

Fay

"Hi Fay

Programming is not like access filling in a table and do what someone has
decided for you.

You can do it mostly anyway you want, therefore most of your questions are a
little bit subjective for a programmer, and I gues you get a lot of
different answers. Not because they are wrong in contrary they will be
mostly right.

> 1 All of the books I have accessed do basic one-two form examples
utilizing
> one or two basic tables. I have used
> Dobson's book and created two datagrids on the same form using the
> Relationship wizard. What I can't see and
> I am wondering about is what code uses the Primary/Foreign key and ties
the
> two datagrids together. I have a major Access database that combines
> multiple tables that have relationships. But I probably will be using
> combinations of individual textboxes and datagrid to display the data on
one
> or more forms. I need to know how to keep all data synched.

Have a look at databinding, datasource and currencymanager

> 2. I am assuming that a data connector and data adapter is needed for each
> table or query that is used on the form. Correct?

I think that when you talking about the data adapter you are talking about
the drag and drop dataAdapter. It is very simple to use, but soon you will
see the disadvantages of it.
After a while you while probably do it in code and after a while than again
you will also see that it is much easier, have a look in code for (Oleddb or
SQL everytime before it) Connection, Command, Adapter, Commandbuilder.

> 3. What is the standard for program development in relationship to
> resolution? Are most people developing for 800 x 600 or 1024 x 764 when
the
> ultimate end-user is unknown?

This will of course be important where you live. I asume that in the rich
countries larger screens are used than in the other ones.

> 4. One thing I have never figured out is how to size/auto resize a form.
How
> do I work with the answer to #3 and allow the form still be displayed
> properly in the other resolution?

Have a look for that at "dock" and "Anchor"

I hope this helps something?

Cor

Yes Cor this does help. Thank you.

Fay

"Cor" <(E-Mail Removed)> wrote in message
news:O$(E-Mail Removed)...
> "Hi Fay
>
> Programming is not like access filling in a table and do what someone has
> decided for you.
>
> You can do it mostly anyway you want, therefore most of your questions are
a
> little bit subjective for a programmer, and I gues you get a lot of
> different answers. Not because they are wrong in contrary they will be
> mostly right.
>
> > 1 All of the books I have accessed do basic one-two form examples
> utilizing
> > one or two basic tables. I have used
> > Dobson's book and created two datagrids on the same form using the
> > Relationship wizard. What I can't see and
> > I am wondering about is what code uses the Primary/Foreign key and ties
> the
> > two datagrids together. I have a major Access database that combines
> > multiple tables that have relationships. But I probably will be using
> > combinations of individual textboxes and datagrid to display the data on
> one
> > or more forms. I need to know how to keep all data synched.
>
> Have a look at databinding, datasource and currencymanager
>
> > 2. I am assuming that a data connector and data adapter is needed for
each
> > table or query that is used on the form. Correct?
>
> I think that when you talking about the data adapter you are talking about
> the drag and drop dataAdapter. It is very simple to use, but soon you will
> see the disadvantages of it.
> After a while you while probably do it in code and after a while than
again
> you will also see that it is much easier, have a look in code for (Oleddb
or
> SQL everytime before it) Connection, Command, Adapter, Commandbuilder.
>
> > 3. What is the standard for program development in relationship to
> > resolution? Are most people developing for 800 x 600 or 1024 x 764 when
> the
> > ultimate end-user is unknown?
>
> This will of course be important where you live. I asume that in the rich
> countries larger screens are used than in the other ones.
>
> > 4. One thing I have never figured out is how to size/auto resize a form.
> How
> > do I work with the answer to #3 and allow the form still be displayed
> > properly in the other resolution?
>
> Have a look for that at "dock" and "Anchor"
>
> I hope this helps something?
>
> Cor
>
>
>
>