Is there a way in Access to store more than one value in a field that has
been selected from a combo box?
For example, if a combo box had three values that you can select, "One",
"Two", and "Three". How do you drop down the list and select a first value
("One") then do the same and select a second value ("Two") so that the value
in the field is now "One, Two". I have situations where I need to do this
with fields that
If there is a better way to do this rather than a combo box? 4 6123
I am sorry, I did complete a sentence in this message. Here is the post
again:
Is there a way in Access to store more than one value in a field that has
been selected from a combo box?
For example, if a combo box had three values that you can select, "One",
"Two", and "Three". How do you drop down the list and select a first value
("One") then do the same and select a second value ("Two") so that the value
in the field is now "One, Two". I have situations where I need to do this
with fields that with both a "value list" and with a query to other tables.
If there is a better way to do this rather than a combo box?
If you feel compelled to use "multi-valued fields" (a violation of good
relational database design practices), you would have to use VBA code set
the value... that could be done easily enough with a Text Box bound to the
field, and an unbound Combo Box with code that would append the selected
values to the end of the text string in the Text Box. But, I caution that
you may make more work for yourself when you later need to use that field...
for example, in queries.
Larry Linson
Microsoft Access MVP
"LD" <wa*********@ya hoo.com> wrote in message
news:dl******** **@murdoch.acc. Virginia.EDU... I am sorry, I did complete a sentence in this message. Here is the post again: Is there a way in Access to store more than one value in a field that has been selected from a combo box?
For example, if a combo box had three values that you can select, "One", "Two", and "Three". How do you drop down the list and select a first value ("One") then do the same and select a second value ("Two") so that the value in the field is now "One, Two". I have situations where I need to do this with fields that with both a "value list" and with a query to other tables.
If there is a better way to do this rather than a combo box?
Thanks Larry. I do not expect any queries created in the future will
include criteria for this field. I am creating a computer job database.
Three of the fields are "Run Day", "Input" and "Output". There are a
limited number of input files and output destinations but each job can
contain one or more run days, input files, and output files.
Thank you for your help.
Lloyd
"Larry Linson" <bo*****@localh ost.not> wrote in message
news:nT5ff.2781 3$9T4.14418@trn ddc04... If you feel compelled to use "multi-valued fields" (a violation of good relational database design practices), you would have to use VBA code set the value... that could be done easily enough with a Text Box bound to the field, and an unbound Combo Box with code that would append the selected values to the end of the text string in the Text Box. But, I caution that you may make more work for yourself when you later need to use that field... for example, in queries.
Larry Linson Microsoft Access MVP
"LD" <wa*********@ya hoo.com> wrote in message news:dl******** **@murdoch.acc. Virginia.EDU...I am sorry, I did complete a sentence in this message. Here is the post again: Is there a way in Access to store more than one value in a field that has been selected from a combo box?
For example, if a combo box had three values that you can select, "One", "Two", and "Three". How do you drop down the list and select a first value ("One") then do the same and select a second value ("Two") so that the value in the field is now "One, Two". I have situations where I need to do this with fields that with both a "value list" and with a query to other tables.
If there is a better way to do this rather than a combo box?
On Thu, 17 Nov 2005 15:25:45 -0500, LD wrote: I am sorry, I did complete a sentence in this message. Here is the post again: Is there a way in Access to store more than one value in a field that has been selected from a combo box?
For example, if a combo box had three values that you can select, "One", "Two", and "Three". How do you drop down the list and select a first value ("One") then do the same and select a second value ("Two") so that the value in the field is now "One, Two". I have situations where I need to do this with fields that with both a "value list" and with a query to other tables.
If there is a better way to do this rather than a combo box?
It's not a good idea, but if you must .....
Add a regular text control to your form, bound to the field you wish
to store the data in.
Code the Combo AfterUpdate event:
Me![ControlName] = Me![ControlName] & ", " & Me.[ComboName]
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: vgrssrtrs |
last post by:
<html>
<head>
<script language="JavaScript">
<!--
/*
*** Multiple dynamic combo boxes
*** by Mirko Elviro, 9 Mar 2005
***
***Please do not remove this comment
|
by: Jen F. |
last post by:
I have inherited a medical database in which there are multiple values
stored in a single field (ie. "Current Conditions" field might contain
1-20 different conditions, separated by comma (ie. "Heart
Disease,Hyper Tyroid,Cancer" etc.
I would like to search via combo box for any one or more than one
value in this field, ie-what patients have Heart Disease or Cancer by
selecting these disorders off the combo box list.
Any help would be...
|
by: DC Gringo |
last post by:
I have two listboxes, the first of which is an autopostback=true that allows
multiple row selection. When I select multiple values (by holding down CTL)
in the first one, it should query the second one. I seem unable to do this
as it only sends back the first item I select whether I have the CTL key
down or not. Upon the return trip, I can select another one, but it still
only sends value for the last one I selected.
-- MY LISTBOX --...
|
by: sverdlov |
last post by:
Hi all,
I have, let's say, 1 column called Payment_type.
In the column, there are 6 types of values: 1, 2, 3, 4, 5, 6, like in
---------------------------------
Payment_type |
---------------------------------
1 |
---------------------------------
3 |
---------------------------------
|
by: ykong1214 |
last post by:
In my project, there is a single select tag,
<html:select property="userName" size="7">
<html:options collection="UserList" property="value" labelProperty="label" />
</html:select>
<br><br>
<input type="button" value="Select" onClick="go()">
<input type="button" value="Cancel" onClick="cancel()">
when user choose any one and click "select" button, the value will be transfered to original window:
| |
by: billa856 |
last post by:
Hi,
My Project is in MS Access.
In that I have one form in which I have some textboxes,comboboxes and listboxes.
Now when I select value from 1st combobox(CustomerID) then it wil generate list for 1st listbox(PalletNo).
Now I want to select miltiple values from that 1st listbox(PalletNo).
and based upon this selection from 1st listbox(PalletNo) and combobox(CustomerID) I want to generate list for 2nd listbox(PONo).
For example
...
|
by: sarayu |
last post by:
Hi All,
How can i select multiple values in a form without using options.I want to select more than one image from a table and submit those selected values as a request to the next page.I don't want to use the select box for this.
Can u please help me about this?
Thanks in advance
|
by: jeremyjcochran |
last post by:
I am writing a code for a shopping cart, the customer selects the color, which also has the price. I want to send the color and the price to "price" and "color" on the mysql server. How do I code a SELECT to send two different variables to two different mysql names?
I have this right now....
echo "<select name='priceBox' name2='colorBox'>";
echo "<option value='" . $prodrow . "' value2='" . Black . "'>Black $" ....
|
by: MicaK |
last post by:
Good Morning,
I am new to this forum, and extremely new to VBA, so there may be a very simple explanation to this. I also apologize if I am giving you and excessive amount of detail. I have a table, tblAdmissions. One of the columns is for Certification and was set up as a lookup field that allows multiple values to be selected. In my form, the label for this field is called lblCertification, and the combo box is called cboCertification. ...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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: 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: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
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...
| |