Forms :: Concatenate Entries From A Single Field Based On Another Field
Apr 11, 2013
I have a datase that has the following fields.
Name
Comment1
Comment2
I have about 36 names and each of those names appears anywhere from 2 7 times each. Each name entry has a comment1 and a comment2.What I would like to do is create a form that allows me to choosea name and the display the comments 1 and comments 2 in text boxes.
I have made the form to allow me to choose a name and it shows one of the comment1 and one of teh comment2 in the adjacent text boxes as planned but, I want all the comment1s for Bob to show in the text box for comment1 and all of the comment2s for Bob to show in the Comment2 text box.I believe I need to concatenate the results in the comment1 and comment2 boxes, but I do not know where or how I would do that.
View Replies
ADVERTISEMENT
Jun 29, 2007
To anyone who can help,
I have created a function that loops through an amount of records and concatenates them into a single comma-separated string. What I would like to do is concatente the values into a list. Instead of:
value1, value2, value3
I would like to see
value1
value2
value3
This needs to be in a single record only. The code I am using is:
----------------------------
while not rec.eof
string = string & ", "
rec.movenext
wend
string=left(string,len(string)-2)
--------------------------------
Thanks for all your help. I have tried to insert char(20), but this only seems to work in Excel. Access gives me invalid char symbol.
View 1 Replies
View Related
Nov 4, 2013
I use following function to concatenate data from multiple rows into a single row/field. It puts a comma ',' after each concatenate. What I would like it to do more is to put 'and' instead of comma between the last two concatenated words. For example: Now it gives me Value 1 but I want to get Value 2.
Value 1:
FormRegNo CombinedParticipants
DC-190 Political parties, CSOs, community residents
Value 2:
FormRegNo CombinedParticipants
DC-190 Political parties, CSOs and community residents
Function:
Option Compare Database
Option Explicit
Public Function ConcatField(strSQL As String) As String
Dim dbs As Database
Dim rst As DAO.Recordset
Dim strConcat As String
[Code] ....
View 2 Replies
View Related
Jan 15, 2015
In Access 2013 I have a query that join two tables, Conduminium Owners to their possetions (fractions of conduminium).
Owners.OwnOwners.Vote SumOfTblFracPerc
O; P................................No............... .9,54
F....................................Yes.......... ......5,48
L; Q................................Yes.............. ..7,13
M; U...............................Yes............... .7,86
H...................................Yes........... .....5,71
D; R...............................Abstention......7, 78
etc...
This query is grouping and summing, and I want put the results in a form and see it grouping the fractions in lines like this:
"These were the votes of the owners of fractions:
O;P, voted No = 9,54
F, L;Q, M;U, H, G;W, C, N, I, voted Yes = 37,72
D; R - voted Abstention = 7,78
How can I do it?
View 1 Replies
View Related
Apr 11, 2008
Hi Guys, I'm new here and fairly new to anything indepth with Access.
I'm using Access 2003 and have a table which has a number of customer records. The two relevant fields are the CustomerID which is a simple integer and OrderDate obviously this is a date field!
What I need (to link in with the other forms) is a query that will return one record for each CustomerID it should be the most recent OrderDate.
I've had a few attempts and done a couple of searches but can't seem to find exactly what I'm looking for. If someone could point me in the right direction I'm happy to play with sample code and read up on bits other people have done (I tend to learn better that way) rather than just being given some code!
Thanks for any help you could can provide.
View 1 Replies
View Related
Aug 25, 2014
A user enters text into a memo field for an existing client, then it's closed, the same record reopened and more entered into the memo.The problem is when it's reopened the existing text is hi-lighted, and it's really easy for someone to begin typing and write over it.I want to reopen it, create a new line, enter a date stamp maybe, create another line with the cursor in it, ready for the user to enter new text.
View 6 Replies
View Related
Jun 30, 2015
I have my Assets form and the primary key is the ChargerID, in this form I have an "Add New Job For This Asset" button, which opens up the Jobs form at a new record.
How do I make it so that the ChargerID field is automatically filled with whatever the previous record was instead of being blank.
For example if I have Charger12345 open in the Asset form, I'd like to click the Add New Job button and it automatically have Charger12345 in the ChargerID field of the Jobs form.
View 5 Replies
View Related
Jun 4, 2013
I am making a very simple 'registration' database for a children's event in a couple of weeks.I the table/form there is a checkbox field called 'consent' which, if checked, indicates that a child can leave the event without parental consent.
There is a report printed on each child (a registration page which the leaders get a copy of). I would like on this report a 'red box' to appear if the child cannot leave without permission (i.e. the consent box is not checked). I would also like this 'red box' to appear on the form. I had thought of doing it this way - but I'm not sure if it's the best, or if it's possible:
Have a field in my table called 'consentindicator'. When the 'consent' box is checked, there is a period ('.') placed into the 'consentindicator' field. It is set to turn red when a period is present. That way, when the consent box is checked, a get a red 'box'.
View 12 Replies
View Related
Jul 13, 2013
I have a table that has been converted into a form for an input. Now suppose I have two columns. Say I enter value in first column. Now the second column is a lookup to a data from another table.
What I want is to see only those data in 2nd Column which have the value filled in Column 1. This is should be in run time mode. I fill in the value and then in the 2nd column I directly get to see only common values.
View 2 Replies
View Related
Aug 26, 2013
I have a form where a user can select from a listbox (pulled from a database) and "Add product" - it then goes into a Textbox, each taking a new line when "Add product" button pressed. Then when they press "Add Customer" those details along with other entered details gets stored in my Customer Database..
The textbox store multi-line entries in the "ProductName" field heading in database.
Is there anyway i can use a List instead of the textbox? Adding individual entries to one certain customer? I have an EDIT facility aswell so would be easier to have a "Remove Product" button instead of manually backspacing a whole product entry from another textbox (containing all products, on new lines).
View 4 Replies
View Related
May 8, 2013
I am facing some problem regarding sub form row.When i want to disable single filed then it disable all rows field. i will be able to disable single field in sub form.
View 3 Replies
View Related
Jul 31, 2015
So I'm making a database for an office and I'm having a little trouble getting the information linked together. This is my first access project.
Here's the information:
Desktops_TBL
Desktop ID (PK)
Location (FK)
Serial Number
Product Number
Operating System
etc
[Code]....
How I want it to work:
-New users or equipment is entered via a new entry form and stored in the respective table with a dummy Location (i.e. "Backstock"). This part I understand how to do
-To assign a user and equipment to a location, I want there to be a master form for that location. In that master form, there are subforms displaying the current pieces of equipment attributed (if there are any) to that location. A combo box displays the possible choices, and choosing a choice attributes the equipment to that location.
I have the form with subforms set up. The number of records corresponds to the number of locations in the office. Going through the records displays the correct information of attributed equipment in the subforms.
Where I am stuck: What I want is for the user of the database to be able to click on the Desktop serial number combo box, choose a different record, and have it assign the Location from the main form to the Desktop Location FK so that they link. When I try to do this, it writes a new blank record in Desttop_TBL, assigning the Desktop ID to the PC Serial Number spot, but that's it.
View 2 Replies
View Related
Nov 24, 2014
I have recently started working for a new company and have inherited a nightmare of a system!
I have basic knowledge of Access and have been asked to stop duplicate entries under the same PO Number.
I have tried using DLookups by looking at other posts on the forum with no success.
The input form is called Purchase Order Entry, with the field called PO_No. The table is called Orders, with the field called Purchase Order Number.
I have tried to make the Purchase Order Number in the Orders table, the primary key but an error that it cannot contain a null value appears.
The Purchase orders may not be entered into the database in numerical order also.
View 14 Replies
View Related
Aug 24, 2014
I have a form used to track attendance of employees:
I want to update a value in Field B to a default value if a specific criteria is selected in Field A. How? I cannot seem to find a answer...
Specifically: If the combo box value "Not Present" is selected from Field A, I want to value in Field B to automatically update to "Not Available".
View 11 Replies
View Related
Nov 17, 2014
I have a continuous subform that draws information from a table (Calls). This subform shows a variety of fields among them one called "ResolutionDetails".
This field can have various values such as "In process, Completed" Initial contacts", Repairing,..."
I have been asked to simplify this subform by hiding this field and adding another one (not to the table, just to the continuous form) that shows only two possible values: "In Process" or "Completed"
So let's say I create a new unbound field in this continuous form; How can I do so this field checks the value of "ResolutionDetails" and it shows one of the two options? My guess is that I need to give this new field a default value of "In process" and have it change to "Completed" when "ResolutionDetails" value is "Completed"
View 2 Replies
View Related
Apr 21, 2013
I have a table in which there are approximately 15k records. The name field has approximately 2500 unique values. I need to search the table for multiple names and return the results from the table. This would then be used as a report. Due to the users being very novice, a form is needed for the search.
Example:
Search for Smith, John; Wilson, Bill; Jones, Jeff
Return
Name Year Brand Make
Smith, John 1999 Oldsmobile 88
Smith, John 2001 Chrysler 300s
Wilson, Bill 1994 Porsche Carrera
Wilson, Bill 2007 Kia Sporty
Jones, Jeff 2004 Chevrolet Camaro
Jones, Jeff 2011 Chevrolet Impala
My knowledge of forms is basic, however, I can be a quick learner if on the right track.
View 1 Replies
View Related
Aug 15, 2013
Im constructing a form with check boxes next to names. Id like to have the checked names input serially into a single table field like:
IssuedTo
Name1, Name2, Name3
There are 8 possible Names. Is there way to do this without a long complicated If-Else-Then function?
View 5 Replies
View Related
Jan 31, 2014
A third-party application I use exports data with 3 header rows. I usually have to go into Excel and concatenate the rows into a single header row, then export the file to Access to apply queries. I want to minimize the steps in this process, so I'm wondering if it's possible to do this concatenation in Access (with or without VBA).
View 13 Replies
View Related
Mar 14, 2007
I have a query which select the records who have a certain criteria.
The result is something like this.
A 0012345
A 0032432
Note that the records that have this criteria will be smaller or equal than 2.
I want the query to give me this answer instead.
A0012345, A 0032343
(in the same field that is).
Is this possible, if so can someone help me. My email address is russcami@yahoo.com
Thanks
View 2 Replies
View Related
Dec 15, 2012
I'm looking for a way to summarize multiple fields of data from the same column in a single field. I've seen this page but have been unable to get it to work. I save the code listed but do not know which of the example fields would relate to my table.
Code:
SELECT CompanyName, ConcatRelated("OrderDate", "tblOrders", "CompanyID = " & [CompanyID])
FROM tblCompany;
I saw that I can create a report and select "group by," but then all the columns appear on different lines rather than summarized on one line. Here is an example of how I would like the data to appear, separated by commas or with specific dates within parentheses. The reason I want them all on one line is to provide an easier to read/more succinct summary.
e.g.
ITEM
LOCATION
DATE
GORP
EAST
1/1/2012
GORP
EAST
2/1/2012
[code]...
View 7 Replies
View Related
Mar 9, 2007
Hi All,
I can use some help with a jumping off poit.
*Please see attached file*
I have 2 tables tblSFDC and tblTheCall
tblSFDC (contact information) includes CustID (primary key) and a memo field "Notes"
tblTheCall (call information) includes CustID (relates to tblSFDC) and "activity data fields" ie "Live", Left Message" , Sent email".
tblTheCall may in some cases have multiple records for each CustID
I need to :
Concatenate from tblTheCall Field Names and field values (that are not null)
Insert into tblSFDC.Notes
Where tblTheCall.CustID = tblSFDC.CustID
*Please see attached file*
TIA
Detrie
View 8 Replies
View Related
Jul 8, 2005
Hi,
I have a combo box which is populated by a table with the fields ID, First Name and Surname. What I want to do is display the first name and surname concatenated and hide the ID column, but populate the field with the ID number.
Is this possible?
View 3 Replies
View Related
Feb 2, 2005
I have an Access 2000 project and am trying in a query view to join 3 values into one.
2 of the values come from tables, the third comes from another query view (all linked in the query design screen)
Value 1 is always populated, but for each record either Value 2 or Value 3 will always be empty.
All values are strings.
I have tried this formula in the query design grid:
dbo.Value1 + '/' + dbo.Table2.Value2 + dbo.vieTable3.Value3
..in an attempt to give the result Value1/Value2 or value1/Value3 according to the
particular record.
Unfortunately it doesn't work! ...just returns blank results when the query view is run.
Any suggestions would be greatly appreciated
thanks....nick
View 4 Replies
View Related
Nov 16, 2013
I have a table:
"tb_skybox_Types", with the fields, [Policy_URN], [Box_Type]
Sample:
Policy_URN Box_Type
001 Standard
001 Sky HD
002 Sky +
002 Sky + HD
I'm mail merging this, so naturally it's giving me a row per box type against which I need to be one. Desired output:
Policy_URN Box_Type
001 Standard | Sky HD
002 Sky + | Sky + HD
I'm then going to make this into a temp table, then match the URN back to the customer table to get a single row per customer.
View 3 Replies
View Related
Jun 18, 2013
My database has a 'markets' table, where there could be multiple markets per campaign.
So right now in my report, it's displaying like this
campaign 1
Market 1
Market 2
Market 3
Etc.
Is there a way, to Concatenate multiple rows into 1 field. So it would look something like this
Campaign 1
Market 1, Market 2, Market 3
That would save a lot of space in the report, and make it easier to read.
View 11 Replies
View Related
Jul 10, 2014
I have
Field1
Field2
Field3
I need to concatenate these three fields into one but for each record the order can be different. What I want to do is have another field in the table to store the concatenation order as the field names not the field values.
I also need to display the concatenated field as the actual field values and not field names in a form or a report
So if field4 was the concatenated field store it would store the information like this
[Field1] & " " & [Field3] & " " & [Field2]
In a form or a report
Field4 should show as Values of those fields
Monkey Dog Cat
View 1 Replies
View Related
