|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Data WizardDoes 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 Dahrl,
It has it much nicer not only based on Access db. http://www.vb-tips.com/dbpages.aspx?ID=1139f14a-c236-4ad7-8882-b1ed16424252 I hope this helps, Cor Show quoteHide quote "Darhl Thomason" <darhlt@papamurphys.nospamplease.com> schreef in bericht news:%23rAoMEJzGHA.5048@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 > 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 Show quoteHide quote "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message news:OeOE1XMzGHA.4232@TK2MSFTNGP04.phx.gbl... > Dahrl, > > It has it much nicer not only based on Access db. > > http://www.vb-tips.com/dbpages.aspx?ID=1139f14a-c236-4ad7-8882-b1ed16424252 > > I hope this helps, > > Cor > > "Darhl Thomason" <darhlt@papamurphys.nospamplease.com> schreef in bericht > news:%23rAoMEJzGHA.5048@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 >> > > 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. :-) CorShow quoteHide quote "Darhl Thomason" <darhlt@papamurphys.nospamplease.com> schreef in bericht news:%23FHtSJSzGHA.1936@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]" <notmyfirstn***@planet.nl> wrote in message > news:OeOE1XMzGHA.4232@TK2MSFTNGP04.phx.gbl... >> Dahrl, >> >> It has it much nicer not only based on Access db. >> >> http://www.vb-tips.com/dbpages.aspx?ID=1139f14a-c236-4ad7-8882-b1ed16424252 >> >> I hope this helps, >> >> Cor >> >> "Darhl Thomason" <darhlt@papamurphys.nospamplease.com> schreef in bericht >> news:%23rAoMEJzGHA.5048@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 >>> >> >> > > 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 Show quoteHide quote "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message news:%23Ig%23DpezGHA.4972@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" <darhlt@papamurphys.nospamplease.com> schreef in bericht > news:%23FHtSJSzGHA.1936@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]" <notmyfirstn***@planet.nl> wrote in message >> news:OeOE1XMzGHA.4232@TK2MSFTNGP04.phx.gbl... >>> Dahrl, >>> >>> It has it much nicer not only based on Access db. >>> >>> http://www.vb-tips.com/dbpages.aspx?ID=1139f14a-c236-4ad7-8882-b1ed16424252 >>> >>> I hope this helps, >>> >>> Cor >>> >>> "Darhl Thomason" <darhlt@papamurphys.nospamplease.com> schreef in >>> bericht news:%23rAoMEJzGHA.5048@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 >>>> >>> >>> >> >> > > 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?ID=28fdf87c-e705-4a75-8285-29ce9ff01d75 I hope this helps, Cor Show quoteHide quote "Darhl Thomason" <darhlt@papamurphys.nospamplease.com> schreef in bericht news:eZNlJ0T0GHA.1292@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]" <notmyfirstn***@planet.nl> wrote in message > news:%23Ig%23DpezGHA.4972@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" <darhlt@papamurphys.nospamplease.com> schreef in bericht >> news:%23FHtSJSzGHA.1936@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]" <notmyfirstn***@planet.nl> wrote in message >>> news:OeOE1XMzGHA.4232@TK2MSFTNGP04.phx.gbl... >>>> Dahrl, >>>> >>>> It has it much nicer not only based on Access db. >>>> >>>> http://www.vb-tips.com/dbpages.aspx?ID=1139f14a-c236-4ad7-8882-b1ed16424252 >>>> >>>> I hope this helps, >>>> >>>> Cor >>>> >>>> "Darhl Thomason" <darhlt@papamurphys.nospamplease.com> schreef in >>>> bericht news:%23rAoMEJzGHA.5048@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 >>>>> >>>> >>>> >>> >>> >> >> > > 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 Show quoteHide quote "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message news:Oz%23JzbW0GHA.4264@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?ID=28fdf87c-e705-4a75-8285-29ce9ff01d75 > > I hope this helps, > > Cor > > > "Darhl Thomason" <darhlt@papamurphys.nospamplease.com> schreef in bericht > news:eZNlJ0T0GHA.1292@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]" <notmyfirstn***@planet.nl> wrote in message >> news:%23Ig%23DpezGHA.4972@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" <darhlt@papamurphys.nospamplease.com> schreef in >>> bericht >>> news:%23FHtSJSzGHA.1936@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]" <notmyfirstn***@planet.nl> wrote in message >>>> news:OeOE1XMzGHA.4232@TK2MSFTNGP04.phx.gbl... >>>>> Dahrl, >>>>> >>>>> It has it much nicer not only based on Access db. >>>>> >>>>> http://www.vb-tips.com/dbpages.aspx?ID=1139f14a-c236-4ad7-8882-b1ed16424252 >>>>> >>>>> I hope this helps, >>>>> >>>>> Cor >>>>> >>>>> "Darhl Thomason" <darhlt@papamurphys.nospamplease.com> schreef in >>>>> bericht news:%23rAoMEJzGHA.5048@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 >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > > 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 Show quoteHide quote "Darhl Thomason" <darhlt@papamurphys.nospamplease.com> wrote in message news:epcDoWo0GHA.4972@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]" <notmyfirstn***@planet.nl> wrote in message > news:Oz%23JzbW0GHA.4264@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?ID=28fdf87c-e705-4a75-8285-29ce9ff01d75 >> >> I hope this helps, >> >> Cor >> >> >> "Darhl Thomason" <darhlt@papamurphys.nospamplease.com> schreef in bericht >> news:eZNlJ0T0GHA.1292@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]" <notmyfirstn***@planet.nl> wrote in message >>> news:%23Ig%23DpezGHA.4972@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" <darhlt@papamurphys.nospamplease.com> schreef in >>>> bericht >>>> news:%23FHtSJSzGHA.1936@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]" <notmyfirstn***@planet.nl> wrote in message >>>>> news:OeOE1XMzGHA.4232@TK2MSFTNGP04.phx.gbl... >>>>>> Dahrl, >>>>>> >>>>>> It has it much nicer not only based on Access db. >>>>>> >>>>>> http://www.vb-tips.com/dbpages.aspx?ID=1139f14a-c236-4ad7-8882-b1ed16424252 >>>>>> >>>>>> I hope this helps, >>>>>> >>>>>> Cor >>>>>> >>>>>> "Darhl Thomason" <darhlt@papamurphys.nospamplease.com> schreef in >>>>>> bericht news:%23rAoMEJzGHA.5048@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 >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > > > > 
Other interesting topics
DataGridView and ComboBox
FOR ALL - Best Practices for navigating within code? -plus - Add-In's that help? Report is mostly hidden in the report viewer Multiple icons into 1 exe or dll How Microsoft does it? Sending email from Windows application Not working. how to get parent control of the context menu stip fill combobox1... combobox with data binding Play dvd |
|||||||||||||||||||||||
