Hi all
I'm new to vb but have a little experience in vba
im using vb.net
my question is with comboboxes
the fist combo box lists the manufactures when a selection is made the
second combox populates with the available products and when a selection is
made here then next combobox will be populated with model numbers and so on
can someone point me in the direction for this information and also does
information get stored in a data base or just within the code files
thanks Phil
5  1954 
Phil,
Next time don't use a name like comboboxes, a lot of (most) users use
Outlook Express to see newsgroups. It will search to a subject like yours
and your message will be connected to an older one, therefore in your
subject "Needs help with 3 comboboxes for 3 tables" will set this appart.
Your question, Yes that is easy to do.
What you need is 3 dataviews.
With rowfilters wich you make the datasources of your comboboxes.
When combobox 1 changes, you use the indexchange event of that combobox,
toset the rowfilter of the dataview to the selectedtext (or value) and so on
to the next combobox. http://msdn.microsoft.com/library/de...iltertopic.asp
It is as well possible with datareleations, however to get it fire you need
again the same procedure and therefore I see no benefit for that.
I hope this helps?
Cor
hi cor
my understanding of dataviewer is that it holds the data within the code
the solution I need will need a data base that is easy to up date like a
excel spreadsheet or something simular as the project information will be
undated every 6 months with numerous changes. Am I correct in my
understanding of dataview or have I totally confused myself
thanks Phil
"Cor Ligthert" <no************ @planet.nl> wrote in message
news:uu******** *****@TK2MSFTNG P12.phx.gbl... Phil,
Next time don't use a name like comboboxes, a lot of (most) users use
Outlook Express to see newsgroups. It will search to a subject like yours
and your message will be connected to an older one, therefore in your
subject "Needs help with 3 comboboxes for 3 tables" will set this appart.
Your question, Yes that is easy to do.
What you need is 3 dataviews.
With rowfilters wich you make the datasources of your comboboxes.
When combobox 1 changes, you use the indexchange event of that combobox,
toset the rowfilter of the dataview to the selectedtext (or value) and so
on to the next combobox.
http://msdn.microsoft.com/library/de...us/cpref/html/
frlrfsystemdata dataviewclassro wfiltertopic.as p
It is as well possible with datareleations, however to get it fire you
need again the same procedure and therefore I see no benefit for that.
I hope this helps?
Cor
Phil,
A dataview is a kind of filter that can be used between Datatables and
Controls (datagrid combobox etc). One of the things it does not is holding
data.
Read this first and when you have questions, reply those than http://msdn.microsoft.com/library/de...classtopic.asp
I hope this helps
Cor "Phil" <phespe remove this bigpond.net.au>
my understanding of dataviewer is that it holds the data within the code
the solution I need will need a data base that is easy to up date like a
excel spreadsheet or something simular as the project information will be
undated every 6 months with numerous changes. Am I correct in my
understanding of dataview or have I totally confused myself
thanks Phil
"Cor Ligthert" <no************ @planet.nl> wrote in message
news:uu******** *****@TK2MSFTNG P12.phx.gbl... Phil,
Next time don't use a name like comboboxes, a lot of (most) users use
Outlook Express to see newsgroups. It will search to a subject like yours
and your message will be connected to an older one, therefore in your
subject "Needs help with 3 comboboxes for 3 tables" will set this appart.
Your question, Yes that is easy to do.
What you need is 3 dataviews.
With rowfilters wich you make the datasources of your comboboxes.
When combobox 1 changes, you use the indexchange event of that combobox,
toset the rowfilter of the dataview to the selectedtext (or value) and so
on to the next combobox.
http://msdn.microsoft.com/library/de...us/cpref/html/
frlrfsystemdata dataviewclassro wfiltertopic.as p
It is as well possible with datareleations, however to get it fire you
need again the same procedure and therefore I see no benefit for that.
I hope this helps?
Cor
Hi cor
im starting to understand the concept but i'm confunsed on where to start
do i create a datatable through "add dataset" and which data set should i
use typed or untyped
and where do i add the contents to the tables
thanks phil
"Cor Ligthert" <no************ @planet.nl> wrote in message
news:ea******** ******@TK2MSFTN GP15.phx.gbl... Phil,
A dataview is a kind of filter that can be used between Datatables and
Controls (datagrid combobox etc). One of the things it does not is holding
data.
Read this first and when you have questions, reply those than
http://msdn.microsoft.com/library/de...us/cpref/html/
frlrfsystemdata dataviewclassto pic.asp
I hope this helps
Cor
"Phil" <phespe remove this bigpond.net.au>
my understanding of dataviewer is that it holds the data within the code
the solution I need will need a data base that is easy to up date like a
excel spreadsheet or something simular as the project information will
be undated every 6 months with numerous changes. Am I correct in my
understanding of dataview or have I totally confused myself
thanks Phil
"Cor Ligthert" <no************ @planet.nl> wrote in message
news:uu******** *****@TK2MSFTNG P12.phx.gbl... Phil,
Next time don't use a name like comboboxes, a lot of (most) users use
Outlook Express to see newsgroups. It will search to a subject like
yours and your message will be connected to an older one, therefore in your
subject "Needs help with 3 comboboxes for 3 tables" will set this
appart.
Your question, Yes that is easy to do.
What you need is 3 dataviews.
With rowfilters wich you make the datasources of your comboboxes.
When combobox 1 changes, you use the indexchange event of that
combobox, toset the rowfilter of the dataview to the selectedtext (or value) and
so on to the next combobox.
http://msdn.microsoft.com/library/de...us/cpref/html/ frlrfsystemdata dataviewclassro wfiltertopic.as p
It is as well possible with datareleations, however to get it fire you
need again the same procedure and therefore I see no benefit for that.
I hope this helps?
Cor
Phil,
A typed dataset and a untyped dataset are both dataset. The last one is
inherited from a dataset as well.
To create a dataview it is the most simple done with
dim dv as new dataview(mydata set.tables("myt able"))
in the non typed version
dim dv as new dataview(mydata set.mytable)
in the typed version.
I would start for learning with the non typed version, because than you
better understand what happens.
I hope this helps?
Cor
"Phil" <phespe remove this bigpond.net.au> schreef in bericht
news:%2******** ********@tk2msf tngp13.phx.gbl. .. Hi cor
im starting to understand the concept but i'm confunsed on where to start
do i create a datatable through "add dataset" and which data set should i
use typed or untyped
and where do i add the contents to the tables
thanks phil
"Cor Ligthert" <no************ @planet.nl> wrote in message
news:ea******** ******@TK2MSFTN GP15.phx.gbl... Phil,
A dataview is a kind of filter that can be used between Datatables and
Controls (datagrid combobox etc). One of the things it does not is
holding
data.
Read this first and when you have questions, reply those than
http://msdn.microsoft.com/library/de...us/cpref/html/
frlrfsystemdata dataviewclassto pic.asp
I hope this helps
Cor
>"Phil" <phespe remove this bigpond.net.au>
> my understanding of dataviewer is that it holds the data within the
> code
> the solution I need will need a data base that is easy to up date like
> a
> excel spreadsheet or something simular as the project information will be > undated every 6 months with numerous changes. Am I correct in my
> understanding of dataview or have I totally confused myself
> thanks Phil
> "Cor Ligthert" <no************ @planet.nl> wrote in message
> news:uu******** *****@TK2MSFTNG P12.phx.gbl...
>> Phil,
>>
>> Next time don't use a name like comboboxes, a lot of (most) users use
>> Outlook Express to see newsgroups. It will search to a subject like yours >> and your message will be connected to an older one, therefore in your
>> subject "Needs help with 3 comboboxes for 3 tables" will set this appart. >>
>> Your question, Yes that is easy to do.
>>
>> What you need is 3 dataviews.
>> With rowfilters wich you make the datasources of your comboboxes.
>>
>> When combobox 1 changes, you use the indexchange event of that combobox, >> toset the rowfilter of the dataview to the selectedtext (or value) and so > on
>> to the next combobox.
>>
>>
> http://msdn.microsoft.com/library/de...us/cpref/html/ > frlrfsystemdata dataviewclassro wfiltertopic.as p
>>
>> It is as well possible with datareleations, however to get it fire you
> need
>> again the same procedure and therefore I see no benefit for that.
>>
>> I hope this helps?
>>
>> Cor
>>
>>
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Kathy |
last post by:
In my custom menu one menu item opens a form to add new Makes to TblMakes and
another menu item opens a form to add new Models to TblModels. I have a form
that has a combobox for Makes and a combobox for Models. In both comboboxes I
use the NotInList event and code to allow users to enter Makes and Models that
are not in the database. When the form is open, I want to limit the users to
entering new Makes and Models in the comboboxes and not...
|
by: johnson_cy |
last post by:
I am using Access 2000.
My main form has a record source of a table (employeeTbl with key of
. It is filtering the record results.
My subform and mainform have the link child/link master set to
and the source object is the subform.
My subform record source is a query from another table (vacationTbl).
FYI: I was filtering on the subform, but removed it and replaced with
|
by: Craig G |
last post by:
for months we have been dabling round looking at various 3rd party
comboboxes that allow the user to type text into the combobox as a search
mechanism
what we've found is that the likes of OpinatedGeek comboboxes do seem to
work for exacrtly what we want to do but only if you use IE! if i try and
run them in netscape navigator it falls over with errors on the
load/rendering of the actual control itself
so is there any 3rd party...
|
by: Marcin Podle¶ny |
last post by:
Hi,
I've a form with three comboboxes. Each of them contains the same data - all
cities in my country. As you see it's a lot of data so it takes a lot of
memory. I'd like to use the same datasource for all three comboboxes but
property Datasource works in different way than I want. It looks like it
copies all data to items of each combobox. So it takes more memory (3 *
items + 1 * datasource) and works slowly.
Is this possible to use...
|
by: Sam |
last post by:
Hi,
I have a datagrid which has (amongst other stuff) 2 comboboxes columns.
So far so good. The trick is that when I select a value in my first
column, it must updates the items of the combobox in the second column
for the same row.
In the first column, comboboxes contain names of tables. In the second
column, comboboxes contain names of the fields in the table selected in
the first column.
| | |
by: ashishtarlekar |
last post by:
Hi all,
I have to add comboboxes in the first row of datagridview for
mapping the database fields.
For e.g. I have to show Id, FirstName, LastName in each comboboxes in
the first row. if i select a database which contains 2 fields then
this data should be displayed from second row so that the user can
choose the header name for this two columns from comboboxes like Id,
FirstName, LastName etc.
Can anybody tell me the solution?
|
by: Matt |
last post by:
Hi all, me again! :)
I've now got an issue with combo boxes. Basically, I have a number of
items that I want a user to pick from a single list. It's basically
along the lines of:
Fruit 1:
Fruit 2:
Fruit 3:
|
by: Randy |
last post by:
I have a routine that creates a series of comboboxes, each of which is
bound to a common dataview. Everything used to work fine, but now,
when I change the value of any of the comboboxes, the value in ALL of
the comboboxes changes to the new value. I have boiled down the code
to the simplest lines and placed it on its own form, but I still get
the same behavior. I have stepped through each line of code, and I
don't see any other lines...
|
by: Anthony Bollinger |
last post by:
I have two tables in a master-detail relationship. When I make a selection
in one combobox, how do I have it display the values from a second combobox?
Each table has a key and a text value for each record. I don't yet see the
way to update the list of values in the second combobox.
Thanks for any input,
Tony
|
by: Wingot |
last post by:
Hey,
I have a view to a database that I have created for Client Maintenance. It has
a number of fields, but the important ones are Medical Condition, Bill To, and
Country.
I have a couple of external tables: One for Countries that store each Country
as a ID (char(2)), and Name (varchar(50)) pair; One for Medical Conditions,
using ID (int) and Name (varchar(50)). Also, the BillTo field refers back to
the same table that is being...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
