Data Wizard

[Darhl Thomason]

Does VB2005 have a wizard for creating a form based on an Access db? I know
that VB6 had this, but I can't seem to find anything similar in VB2005.

Thanks!

Darhl

[Cor Ligthert [MVP]]

Dahrl,

It has it much nicer not only based on Access db.

http://www.vb-tips.com/dbpages.aspx?...2-b1ed16424252

I hope this helps,

Cor

"Darhl Thomason" <da****@papamur phys.nospamplea se.comschreef in bericht
news:%2******** ********@TK2MSF TNGP03.phx.gbl. ..

Does VB2005 have a wizard for creating a form based on an Access db? I
know that VB6 had this, but I can't seem to find anything similar in
VB2005.

Thanks!

Darhl

[Darhl Thomason]

Hi Cor,

Thanks for the suggestion! This is a great start for me. Now my next
problem is figuring out how to make some of the controls be drop down combo
boxes that are populated by another table in the db.

But that'll be another post when I get there :-)

Thanks again!

Darhl
"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:Oe******** ******@TK2MSFTN GP04.phx.gbl...

Dahrl,

It has it much nicer not only based on Access db.

http://www.vb-tips.com/dbpages.aspx?...2-b1ed16424252

I hope this helps,

Cor

"Darhl Thomason" <da****@papamur phys.nospamplea se.comschreef in bericht
news:%2******** ********@TK2MSF TNGP03.phx.gbl. ..

>Does VB2005 have a wizard for creating a form based on an Access db? I
know that VB6 had this, but I can't seem to find anything similar in
VB2005.

Thanks!

Darhl

[Cor Ligthert [MVP]]

Dahrl,

It is very to add that combobox using the designer but keep in mind that you
first add the related table in top of the datasource box. Probably you do it
the first time wrong because you forget to select the dataset first.

:-)

Cor

"Darhl Thomason" <da****@papamur phys.nospamplea se.comschreef in bericht
news:%2******** ********@TK2MSF TNGP06.phx.gbl. ..

Hi Cor,

Thanks for the suggestion! This is a great start for me. Now my next
problem is figuring out how to make some of the controls be drop down
combo boxes that are populated by another table in the db.

But that'll be another post when I get there :-)

Thanks again!

Darhl
"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:Oe******** ******@TK2MSFTN GP04.phx.gbl...

>Dahrl,

It has it much nicer not only based on Access db.

http://www.vb-tips.com/dbpages.aspx?...2-b1ed16424252

I hope this helps,

Cor

"Darhl Thomason" <da****@papamur phys.nospamplea se.comschreef in bericht
news:%2******* *********@TK2MS FTNGP03.phx.gbl ...

>>Does VB2005 have a wizard for creating a form based on an Access db? I
know that VB6 had this, but I can't seem to find anything similar in
VB2005.

Thanks!

Darhl

[Darhl Thomason]

OK, I can see how to change the field to a combo box, then I can bring it to
my form, but it's not working how I am expecting. It is only displaying one
piece of the data in the table, and I want to be able choose from a list of
data. Maybe I'm doing something wrong...

My database has a number of "ID" fields that correlate to other tables.
Example, tblStoreData has OwnerID, StatusID, DMAID, RegionID, etc. I then
have tables for tblOwners, tblStatus, tblDMA, tblRegion, etc.

tblOwners has:
OwnerID
OwnerName
OwnerEmail
OwnerPhone

tblStatus has:
StatusID
StatusName

tblDMA has:
DMAID
DMAName

tblRegion has:
RegionID
RegionName

Hopefully you understand how I have my database laid out. My goal is to be
able to update the status of a store by choosing the value in a combo box.
The combo box gets its list from tblStatus.Statu sName. When I choose a
different StatusName from the combo, I want it to update the StatusID field
in tblStoreData. I want to be able to do the same for all of the ID fields
in tblStoreData (there are 8 fields as described above). I believe I have
all of my table relationships set correctly. I have this done using Access
2003, but I am updating my form to VB05 so I can deploy it to people who do
not have Access.

Thanks again for your help Cor, it's invaluable!

Darhl
"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:%2******** **********@TK2M SFTNGP03.phx.gb l...

Dahrl,

It is very to add that combobox using the designer but keep in mind that
you first add the related table in top of the datasource box. Probably you
do it the first time wrong because you forget to select the dataset first.

:-)

Cor

"Darhl Thomason" <da****@papamur phys.nospamplea se.comschreef in bericht
news:%2******** ********@TK2MSF TNGP06.phx.gbl. ..

>Hi Cor,

Thanks for the suggestion! This is a great start for me. Now my next
problem is figuring out how to make some of the controls be drop down
combo boxes that are populated by another table in the db.

But that'll be another post when I get there :-)

Thanks again!

Darhl
"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:Oe******* *******@TK2MSFT NGP04.phx.gbl.. .

>>Dahrl,

It has it much nicer not only based on Access db.

http://www.vb-tips.com/dbpages.aspx?...2-b1ed16424252

I hope this helps,

Cor

"Darhl Thomason" <da****@papamur phys.nospamplea se.comschreef in
bericht news:%2******** ********@TK2MSF TNGP03.phx.gbl. ..
Does VB2005 have a wizard for creating a form based on an Access db? I
know that VB6 had this, but I can't seem to find anything similar in
VB2005.

Thanks!

Darhl

[Cor Ligthert [MVP]]

Darhl,

It is hard to show that in a sample with the wizard, in the next article of
the Dutch Net magazine I have done an article about that. But it is a lot of
text and I assume that you are not from Holland.

Bassicly it is adding your tables using the wizard in top of the DataSource
pane to your dataset/dataadapter.

Than you open everytime a column and change that to a combobox. In that you
set the datasource (and than you will see that it will automaticly be
created). The problem is, that it is hard to tell, because you have to take
the datasource in one of the rows preceded with a cross.

Without the wizard it is like this.
http://www.vb-tips.com/dbpages.aspx?...5-29ce9ff01d75

I hope this helps,

Cor
"Darhl Thomason" <da****@papamur phys.nospamplea se.comschreef in bericht
news:eZ******** ******@TK2MSFTN GP03.phx.gbl...

OK, I can see how to change the field to a combo box, then I can bring it
to my form, but it's not working how I am expecting. It is only
displaying one piece of the data in the table, and I want to be able
choose from a list of data. Maybe I'm doing something wrong...

My database has a number of "ID" fields that correlate to other tables.
Example, tblStoreData has OwnerID, StatusID, DMAID, RegionID, etc. I then
have tables for tblOwners, tblStatus, tblDMA, tblRegion, etc.

tblOwners has:
OwnerID
OwnerName
OwnerEmail
OwnerPhone

tblStatus has:
StatusID
StatusName

tblDMA has:
DMAID
DMAName

tblRegion has:
RegionID
RegionName

Hopefully you understand how I have my database laid out. My goal is to
be able to update the status of a store by choosing the value in a combo
box. The combo box gets its list from tblStatus.Statu sName. When I choose
a different StatusName from the combo, I want it to update the StatusID
field in tblStoreData. I want to be able to do the same for all of the ID
fields in tblStoreData (there are 8 fields as described above). I believe
I have all of my table relationships set correctly. I have this done
using Access 2003, but I am updating my form to VB05 so I can deploy it to
people who do not have Access.

Thanks again for your help Cor, it's invaluable!

Darhl
"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:%2******** **********@TK2M SFTNGP03.phx.gb l...

>Dahrl,

It is very to add that combobox using the designer but keep in mind that
you first add the related table in top of the datasource box. Probably
you do it the first time wrong because you forget to select the dataset
first.

:-)

Cor

"Darhl Thomason" <da****@papamur phys.nospamplea se.comschreef in bericht
news:%2******* *********@TK2MS FTNGP06.phx.gbl ...

>>Hi Cor,

Thanks for the suggestion! This is a great start for me. Now my next
problem is figuring out how to make some of the controls be drop down
combo boxes that are populated by another table in the db.

But that'll be another post when I get there :-)

Thanks again!

Darhl
"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:Oe****** ********@TK2MSF TNGP04.phx.gbl. ..
Dahrl,

It has it much nicer not only based on Access db.

http://www.vb-tips.com/dbpages.aspx?...2-b1ed16424252

I hope this helps,

Cor

"Darhl Thomason" <da****@papamur phys.nospamplea se.comschreef in
bericht news:%2******** ********@TK2MSF TNGP03.phx.gbl. ..
Does VB2005 have a wizard for creating a form based on an Access db?
I know that VB6 had this, but I can't seem to find anything similar in
VB2005.
>
Thanks!
>
Darhl
>

[Darhl Thomason]

I think I have all of my tables set up right in the DataSource pane. I have
a screenshot showing my dsPane as well as the relationships on my website at
http://www.dnjhome.com/pos/dsPOSData.png. I'm still missing something, the
combo boxes aren't working how I'm expecting them to. Maybe my
relationships are backwards?

d

"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:Oz******** ********@TK2MSF TNGP05.phx.gbl. ..

Darhl,

It is hard to show that in a sample with the wizard, in the next article
of
the Dutch Net magazine I have done an article about that. But it is a lot
of
text and I assume that you are not from Holland.

Bassicly it is adding your tables using the wizard in top of the
DataSource
pane to your dataset/dataadapter.

Than you open everytime a column and change that to a combobox. In that
you
set the datasource (and than you will see that it will automaticly be
created). The problem is, that it is hard to tell, because you have to
take
the datasource in one of the rows preceded with a cross.

Without the wizard it is like this.
http://www.vb-tips.com/dbpages.aspx?...5-29ce9ff01d75

I hope this helps,

Cor
"Darhl Thomason" <da****@papamur phys.nospamplea se.comschreef in bericht
news:eZ******** ******@TK2MSFTN GP03.phx.gbl...

>OK, I can see how to change the field to a combo box, then I can bring it
to my form, but it's not working how I am expecting. It is only
displaying one piece of the data in the table, and I want to be able
choose from a list of data. Maybe I'm doing something wrong...

My database has a number of "ID" fields that correlate to other tables.
Example, tblStoreData has OwnerID, StatusID, DMAID, RegionID, etc. I
then
have tables for tblOwners, tblStatus, tblDMA, tblRegion, etc.

tblOwners has:
OwnerID
OwnerName
OwnerEmail
OwnerPhone

tblStatus has:
StatusID
StatusName

tblDMA has:
DMAID
DMAName

tblRegion has:
RegionID
RegionName

Hopefully you understand how I have my database laid out. My goal is to
be able to update the status of a store by choosing the value in a combo
box. The combo box gets its list from tblStatus.Statu sName. When I
choose
a different StatusName from the combo, I want it to update the StatusID
field in tblStoreData. I want to be able to do the same for all of the
ID
fields in tblStoreData (there are 8 fields as described above). I
believe
I have all of my table relationships set correctly. I have this done
using Access 2003, but I am updating my form to VB05 so I can deploy it
to
people who do not have Access.

Thanks again for your help Cor, it's invaluable!

Darhl
"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:%2******* ***********@TK2 MSFTNGP03.phx.g bl...

>>Dahrl,

It is very to add that combobox using the designer but keep in mind that
you first add the related table in top of the datasource box. Probably
you do it the first time wrong because you forget to select the dataset
first.

:-)

Cor

"Darhl Thomason" <da****@papamur phys.nospamplea se.comschreef in
bericht
news:%2****** **********@TK2M SFTNGP06.phx.gb l...
Hi Cor,

Thanks for the suggestion! This is a great start for me. Now my next
problem is figuring out how to make some of the controls be drop down
combo boxes that are populated by another table in the db.

But that'll be another post when I get there :-)

Thanks again!

Darhl
"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:Oe***** *********@TK2MS FTNGP04.phx.gbl ...
Dahrl,
>
It has it much nicer not only based on Access db.
>
http://www.vb-tips.com/dbpages.aspx?...2-b1ed16424252
>
I hope this helps,
>
Cor
>
"Darhl Thomason" <da****@papamur phys.nospamplea se.comschreef in
bericht news:%2******** ********@TK2MSF TNGP03.phx.gbl. ..
>Does VB2005 have a wizard for creating a form based on an Access db?
>I know that VB6 had this, but I can't seem to find anything similar
>in
>VB2005.
>>
>Thanks!
>>
>Darhl
>>
>
>

[Darhl Thomason]

OK, I reversed the direction of my relationships and its working better. At
least I can see the value I want to see. Now I need to be able to get the
combo boxes to list all of the items in the related table so I can use the
combo to change them.

Thanks,

d

"Darhl Thomason" <da****@papamur phys.nospamplea se.comwrote in message
news:ep******** ******@TK2MSFTN GP03.phx.gbl...

>I think I have all of my tables set up right in the DataSource pane. I
have a screenshot showing my dsPane as well as the relationships on my
website at http://www.dnjhome.com/pos/dsPOSData.png. I'm still missing
something, the combo boxes aren't working how I'm expecting them to. Maybe
my relationships are backwards?

d

"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:Oz******** ********@TK2MSF TNGP05.phx.gbl. ..

>Darhl,

It is hard to show that in a sample with the wizard, in the next article
of
the Dutch Net magazine I have done an article about that. But it is a lot
of
text and I assume that you are not from Holland.

Bassicly it is adding your tables using the wizard in top of the
DataSource
pane to your dataset/dataadapter.

Than you open everytime a column and change that to a combobox. In that
you
set the datasource (and than you will see that it will automaticly be
created). The problem is, that it is hard to tell, because you have to
take
the datasource in one of the rows preceded with a cross.

Without the wizard it is like this.
http://www.vb-tips.com/dbpages.aspx?...5-29ce9ff01d75

I hope this helps,

Cor
"Darhl Thomason" <da****@papamur phys.nospamplea se.comschreef in bericht
news:eZ******* *******@TK2MSFT NGP03.phx.gbl.. .

>>OK, I can see how to change the field to a combo box, then I can bring
it
to my form, but it's not working how I am expecting. It is only
displaying one piece of the data in the table, and I want to be able
choose from a list of data. Maybe I'm doing something wrong...

My database has a number of "ID" fields that correlate to other tables.
Example, tblStoreData has OwnerID, StatusID, DMAID, RegionID, etc. I
then
have tables for tblOwners, tblStatus, tblDMA, tblRegion, etc.

tblOwners has:
OwnerID
OwnerName
OwnerEmail
OwnerPhone

tblStatus has:
StatusID
StatusName

tblDMA has:
DMAID
DMAName

tblRegion has:
RegionID
RegionName

Hopefully you understand how I have my database laid out. My goal is to
be able to update the status of a store by choosing the value in a combo
box. The combo box gets its list from tblStatus.Statu sName. When I
choose
a different StatusName from the combo, I want it to update the StatusID
field in tblStoreData. I want to be able to do the same for all of the
ID
fields in tblStoreData (there are 8 fields as described above). I
believe
I have all of my table relationships set correctly. I have this done
using Access 2003, but I am updating my form to VB05 so I can deploy it
to
people who do not have Access.

Thanks again for your help Cor, it's invaluable!

Darhl
"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:%2****** ************@TK 2MSFTNGP03.phx. gbl...
Dahrl,

It is very to add that combobox using the designer but keep in mind
that
you first add the related table in top of the datasource box. Probably
you do it the first time wrong because you forget to select the dataset
first.

:-)

Cor

"Darhl Thomason" <da****@papamur phys.nospamplea se.comschreef in
bericht
news:%2***** ***********@TK2 MSFTNGP06.phx.g bl...
Hi Cor,
>
Thanks for the suggestion! This is a great start for me. Now my next
problem is figuring out how to make some of the controls be drop down
combo boxes that are populated by another table in the db.
>
But that'll be another post when I get there :-)
>
Thanks again!
>
Darhl
>
>
"Cor Ligthert [MVP]" <no************ @planet.nlwrote in message
news:Oe**** **********@TK2M SFTNGP04.phx.gb l...
>Dahrl,
>>
>It has it much nicer not only based on Access db.
>>
>http://www.vb-tips.com/dbpages.aspx?...2-b1ed16424252
>>
>I hope this helps,
>>
>Cor
>>
>"Darhl Thomason" <da****@papamur phys.nospamplea se.comschreef in
>bericht news:%2******** ********@TK2MSF TNGP03.phx.gbl. ..
>>Does VB2005 have a wizard for creating a form based on an Access db?
>>I know that VB6 had this, but I can't seem to find anything similar
>>in
>>VB2005.
>>>
>>Thanks!
>>>
>>Darhl
>>>
>>
>>
>
>