473,326 Members | 2,125 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Data Wizard

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
Aug 30 '06 #1
7 1322
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****@papamurphys.nospamplease.comschreef in bericht
news:%2****************@TK2MSFTNGP03.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

Aug 31 '06 #2
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**************@TK2MSFTNGP04.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****@papamurphys.nospamplease.comschreef in bericht
news:%2****************@TK2MSFTNGP03.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


Aug 31 '06 #3
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****@papamurphys.nospamplease.comschreef in bericht
news:%2****************@TK2MSFTNGP06.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**************@TK2MSFTNGP04.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****@papamurphys.nospamplease.comschreef in bericht
news:%2****************@TK2MSFTNGP03.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



Sep 1 '06 #4
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.StatusName. 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******************@TK2MSFTNGP03.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****@papamurphys.nospamplease.comschreef in bericht
news:%2****************@TK2MSFTNGP06.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**************@TK2MSFTNGP04.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****@papamurphys.nospamplease.comschreef in
bericht news:%2****************@TK2MSFTNGP03.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



Sep 5 '06 #5
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****@papamurphys.nospamplease.comschreef in bericht
news:eZ**************@TK2MSFTNGP03.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.StatusName. 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******************@TK2MSFTNGP03.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****@papamurphys.nospamplease.comschreef in bericht
news:%2****************@TK2MSFTNGP06.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**************@TK2MSFTNGP04.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****@papamurphys.nospamplease.comschreef in
bericht news:%2****************@TK2MSFTNGP03.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
>




Sep 6 '06 #6
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****************@TK2MSFTNGP05.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****@papamurphys.nospamplease.comschreef in bericht
news:eZ**************@TK2MSFTNGP03.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.StatusName. 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******************@TK2MSFTNGP03.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****@papamurphys.nospamplease.comschreef in
bericht
news:%2****************@TK2MSFTNGP06.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**************@TK2MSFTNGP04.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****@papamurphys.nospamplease.comschreef in
bericht news:%2****************@TK2MSFTNGP03.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
>>
>
>




Sep 7 '06 #7
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****@papamurphys.nospamplease.comwrote in message
news:ep**************@TK2MSFTNGP03.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****************@TK2MSFTNGP05.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****@papamurphys.nospamplease.comschreef in bericht
news:eZ**************@TK2MSFTNGP03.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.StatusName. 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******************@TK2MSFTNGP03.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****@papamurphys.nospamplease.comschreef in
bericht
news:%2****************@TK2MSFTNGP06.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**************@TK2MSFTNGP04.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****@papamurphys.nospamplease.comschreef in
>bericht news:%2****************@TK2MSFTNGP03.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
>>>
>>
>>
>
>




Sep 7 '06 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: David C. Allen | last post by:
I am following thru the examples in the book I am studying for my MCSD. This is the web applications book. One example is to use the data form wizard to create a simple data form on the...
5
by: Rick | last post by:
The data adapter wizard allows you to add more than one table, but that doesn't seem to work right when setting up a dataset. Some of the documentation I have read states that only one table...
0
by: Steven Blair | last post by:
Hi, A bit long winded this one, but would be grateful for some help. I have a problem using the Wizard component and can think of only two ways of completing the task. Can anyone with some...
6
by: Bob | last post by:
I've located instruction as to how to add the Data Form Wizard into a VB.NET 2005 project at this location. ...
1
by: Demetri | last post by:
I have a question / concern regarding the new suggested way of creating a data access layer in an n-tier application. Typically, a web application specifically, using the SOA (Service Oriented...
3
by: ebrastow | last post by:
Hi folks, I'm a VB newbie - been using PowerBuilder for 12 years and thought I'd see how Visual Basic has come along these days. I'm using MS Visual Studio 2005 Professional, trying to connect...
1
by: cypher_key | last post by:
I want to write a simple application for my own use. I've already have the data populated in a database and I have a data source setup. I can use the wizards to generate a master detail data form...
1
by: rejoyce | last post by:
Hi Everyone, I just started to create new windows application in Visual Basic 2005, so i use the Data Source Configuration Wizard to add new data source connection. I choose the Microsoft Access...
5
geolemon
by: geolemon | last post by:
Import text wizard says: I'm banging my head on this one, here's why: I've been importing files using this process and data format, with success! I created a temporary table in Access to...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.