Concatenating Values From Unbound Sources And Bound Sources
Jul 6, 2005
I know that it isnt advised to store the concatenated value but in this case, I have a memo field which is the description of a particular system component.
i have Unbound Combo Boxes for descriptive elements such as COLOUR, SIZE, CONNECTIVITY, MAKE.
ALL of these i would to store in a field in my table and called Description and separate them by colons or the actual words which describe the category.
Please Advise
View Replies
ADVERTISEMENT
Apr 24, 2006
Hi, I have two seperate sets of data which have been made by queries... These two queries are called "qryTopHalf" and "qryBottomHalf," and I wish to combine one field from each of these two queries by making another query... The SQL code I have tried to use is:
SELECT qryTopHalf.PlayerID, qryBottomHalf.PlayerID
FROM qryTopHalf, qryBottomHalf
I do not get an error message but I do end up getting duplicate values in the results from the new query I have made using the above SQL code... It doesn't seem logical for me to be getting 4 values in each field of the new query results when there were only 2 values in both qryTopHalf.PlayerID and qryBottomHalf.PlayerID.
Any suggestions/solutions? :-)
View 2 Replies
View Related
Jan 31, 2008
Hi,
Wondering if anyone has a solution for my problem.
I have 2 data sources, one which is an ODBC and one which is an import table. I have a 2 queries each querying the 2 data sources seperatly.
My problem is... One of the fields which I need to do a join to a reference table has a different data type in each of the data sources. I have tried changing this in the imported table NO JOY!! You cant change the data type in the ODBC link.
Is the anyway round this?
Any help appreciated...
View 4 Replies
View Related
Dec 14, 2005
Hi,
I have just split up a table into tables so that has interfered with the form I had created for it. I have 2 main tables:
tblDrawingRegister:
DrawingNum
DrawingName
tblRevision:
Drawing num
Revision
LatestIssueDate
OrderNum
I split them up because there was alot of dublication. One drawing can have many different revisions. So I think it was better to split it up like this?
Anyways the form allows the user to add this information so some of the controls are bound to one form and the others to another. I know that I could do a query to combine the two tables but is that the best way to do it from an optimisation/ good database design point of view?
From a layout point of view I would prefer not to use a subform.
Thanks for your time,
RCurtin
View 2 Replies
View Related
Jan 27, 2015
I have an option group where the user reads a question and either has to select yes or no. There are multiple questions on this form. If the user selects 'No' I'd like a "why" form to pop up and allow the user to write a reasoning down and have it saved in a record in a table (the same table that the yes or no answer is saved in).
Right now I have it working, but my method will force me to make a specific why form for each question (which will be over 50). This doesn't seem very efficient.
View 13 Replies
View Related
Jul 2, 2012
I work for a small manufacturing company and have been asked to set up an access database to track production. The end goal is to have a touch screen at every machine where operators will input data. This data will then dump to a different workbook for each machine. My question is: Is it possible to link one access tables with multiple xls documents so that, as data is added to any of the workbooks, it is then updated to a single access table? I also will need to find a quick way to link new files to the table as new parts are put into production.
View 4 Replies
View Related
Jun 29, 2006
Hi everyone,
Managed to build an Access database with switchboard, forms, reports & queries but I'm left with two annoying problems:
1) I have two columns in my main table called "SOURCE" and "SOURCE 2". They both take their data from a table called "SOURCE". I run a weekly query so that the jefes (bosses) can see the fruits of their advertising so I get the the advertising source and the number of times it was used by a client, grouped according to number of times used. My first problem is knowing how to produce a TOTAL at the end of the report of ALL the sources as well as the individual count.
EG: GOOGLE 24
YAHOO 12
MSN 2
TOTAL 38
In design view I have the following:
FIELD: CONTACTID SOURCE WHENREGISTERED
TABLE: CONTACTS CONTACTS CONTACTS
TOTAL: COUNT GROUP BY WHERE
SHOW: Y Y N
CRITERIA: Between [Enter the first date:] And [Enter the last date:]
I haven't used the "SOURCE 2" column due to problem nš2:
2) How do I combine "SOURCE" and "SOURCE 2" columns in my main table in a query? Is it possible? EG on my form a client may have contacted us via GOOGLE the 1st time and then by YAHOO the 2nd time. I want to reflect that in the query, which at the end of the day uses the same table ("SOURCE") to get it's values and then store them in the main "CONTACTS" table.
Hope this isn't too complicated and that I'm explaining myself well. Well done to all those experts whose comments to others have already helped me make some great tweaks, especially with mail merging. Thanks. Chris.
View 4 Replies
View Related
Feb 22, 2006
hi guys, im doing a uni project in access for a small business and the problem i have is that i am making a booking form, and on there needs to be
owner details,
animal details, and
booking details.
these all need to be entered when making a new booking, the problem i have is that i can only seem to be able to use one control source (from the owner table) how do i use multiple control sources on that one form? :confused:
Jez
View 3 Replies
View Related
Nov 27, 2014
I'm looking into create a small unique identifier to put on top of each invoice generated by the database. (.MDB A2010)where '000' its just 3 zeros added for extra badassery, '1' is the actual ID from the database table and -2014 its the current year when the record was added...So maybe I have info from 2 fields (ID, YEAR)... but How do I add the ceros to the ID field... so its 0001 not 1 or 0135 not 135... ???.
View 5 Replies
View Related
Sep 12, 2012
I am working on a project where I have data coming in from about 70 different sources across my state... but right now, they're all submitting their data in different ways (some through websites, some through databases, and some through excel spreadsheets they send monthly). As you can imagine, this is a nightmare for trying to get all of the data in one place to do some statistics on.
My question is this - if I were to set up an Access form where each client could fill in the blanks with the same information they've been submitting to all these other sources, could I send it out to them and have it all compile in one place? The last place I worked, we used Access to manage all of our on-site stuff, but we were all on the same network. Could it work the same way if everyone is spread across one state?
View 1 Replies
View Related
Aug 5, 2006
Hi, I'm trying to connect to SQL Server Express from MS Access 2003.
I've created an ODBC data source and tested it within the ODBC Wizard. It successfully connects to the SQL Server database.
From within MS Access, I choose File > Get External Data > Import and I'm presented with a dialogue for choosing the data source. As soon as I choose ODBC from the Files of Type drop-list, the dialogue disappears. No error-message, nothing!
Has anyone else had this problem?
View 1 Replies
View Related
May 14, 2007
my tab control contains several pages and each page contains several
controls. i set each control it's control source. but i couldn't find the
record source in the Tab Control Page Property. because of that problem i
couldn't see any records displaying in it's controls.
Answer for this problem is greatly appriciated....!
View 1 Replies
View Related
Jan 28, 2013
i want to create a summary report from multiple queries.
what are the best possible methods for this ? should i need to use subreport function or anything else?
View 1 Replies
View Related
Oct 3, 2014
My scenario is that I am using a one time table that is a copy of my real transaction table (called GLAcTranLine) to enter general ledger transactions. Both my form and my sub-form are unbound. The form is called GLFI50 and the sub form is called GLFI50TranSub on disk and inside the main form. That is, both the sub form and its description inside the form (in the label that appears when I build the sub form with the wizard) bear that name.
So in the load for the main form I carry out these job steps.
1. I take a "No Data" copy of the transaction table GLAcTranLine, to get the structure. That works fine. The name I give to it is prefaced with GLFI50 and ends with a random number. That works fine too.
2. I insert a blank record into the new table. That also works fine.
3. Assign the control source to the Sub form and to its individual objects. That just dies in a crumpled heap. Neither the form not the individual columns code works.
The error I get (in both cases) is the Run-time error '2465' Application-defined or object-defined error.
I believe this means that it just cannot work out what idiotic error I have made. The code all passes the compiler test.
Here is the SUB.
Private Sub Form_Load()
'STEP 1. I take a "no data" copy of Create the Work Table and assign it as a control source to the sub form
'================================================= ======================
'(Copies the structure of the source table to a new target one. It isn't a temporary table so I need to
'find a way of assigning a temporary name and then using that name on this prog.
'The True on the end says "Do not copy the data)"
'GLFI50Work is the Global variable that holds the temporary table name.
Dim RandomInt As Single
[Code] .....
View 6 Replies
View Related
Dec 29, 2014
I am creating a database in which to store my data collected in my research. I have 8 tables that are linked by a SampleID number. I have created a form which has tabs, the first tab contains the information required for entry on table 1; how I am going to add the controls from table 2 onto the second tab.
I know how to make additional tabs and I have created a separate form for table 2 with the form wizard, cut and pasted the fields into the second tab on my first form BUT how to establish the source for those controls back to the second table. To make matters worse (of course not to be too dramatic here) I can see the other table in my Field List of related tables.
View 8 Replies
View Related
Jun 24, 2013
Please see the screen shot attached.
I have a single form with multiple tabs. At the top of the form appears the name of an individual and below the name are multiple tabs containing information specific to that individual. Each tab has a separate underlying table, which is the data source for the information contained on that tab.
As best as I can tell, I can only use one single data source (a query at the moment) to populate all the data that appears on all the tabs. Is there a way that I can have a separate data source (namely, a table) for each tab?
View 1 Replies
View Related
Oct 28, 2014
I have a reservations form, which will be used to store the checkin and checkout dates for customers; these are related to the reservations table. On the same form I also want room details showing such as room number, this is on a separate rooms table. I believe that the room number will be a query to show which rooms are available and therefore display the room number on the form. So I need integrating this into the form. Also I have not set it as a subform, the reservations form carries on from the customers form, as a new form.
View 1 Replies
View Related
Nov 16, 2013
importing data from two excel sources to one table. I have a table with: Unit, Info1, info2, info3, info4, info5, info6, info7. I have been able to import from the first file which has all of the unit information-'info1-5'. I need to import another file to fill 'info6-7' based on specific unit numbers. I have created two excel tables the first with the headers "unit, info1-5" and the second with the headers "unit, info6-7." The first works fine and adds all the data I want it to, but when I try to do the same with the second it doesn't add any new data.I cannot add the last two fields to my first spread sheet because it would involve sorting through 700+ units and adding the data manually to 400+ of them.
View 3 Replies
View Related
Jun 12, 2013
I am trying to create a columnar report that relies on information that are expressions in various queries. Unfortunately, I can't seem to create them in one query because the criteria is mutually exclusive. I used the report wizard to start the report based on the single expression in the first query. Now I want to start adding the other data but I can't seem to get it to work. All I really want to do is include fields that have the have the value, which is already summed, from the other query. When I try that I get error messages like "you tried to execute a query that does not include the specified expression 'expressionName' as part of an aggregate function' and it just goes further downhill from there. What is the easiest way to get this simple values into the report? Is there a way I can create a field in the report that uses a SQL statement for just that field so I don't have to have the report linking to 50 different queries?
View 14 Replies
View Related
Apr 17, 2006
hello guys
i have values in two unbound textboxes and now i would like to assign the sum to a bound textbox. Also need AfterUpdate event too.
Can any expert help?
Thank you
View 4 Replies
View Related
Jan 19, 2006
hey all i was wondering, can a unbound text box be a bound textbox. I have just noticed that my unbound text box doesnt not save in the field in my table, that is because it is unboune right? but i need it to save to my table, and i guees the only way to do that is to save in in the save button right? thanks
View 2 Replies
View Related
Jan 19, 2006
hey all i was wondering, can a unbound text box be a bound textbox. I have just noticed that my unbound text box doesnt not save in the field in my table, that is because it is unboune right? but i need it to save to my table, and i guees the only way to do that is to save in in the save button right? thanks
View 9 Replies
View Related
Mar 24, 2006
Please help,
I have a form with a subform in it. The main form has a combobox, called vendor. The subform shows all software.
When i select a vendor, i want only the software for that vendor to show in the subform.
What I am trying to do is set up the link child fields and link master fields so that this works. However, i am getting an error saying, 'Can't build a link between unbound forms'.
I have checked to make sure that relationships exist between the vendors and Software tables but the problems persist.
What should i do here???
View 1 Replies
View Related
Sep 27, 2006
Hi all,
My current database (built with a lot of help and sample code form this site..thankyou to all for their advice) tracks the escalations we receive into the business but as we have used it more and more I have started experiencing a massive performance issue.
I basically have a main table that captures the basic details, reference, product, escalation source, escalation reason etc, and these are captured from combo box selections (so only capturing the id numebr of the row in the combo box)
My main problem seems to be a table I have that we have linked, via the unique escalationID, that we cna add notes for each escalation.
So for instance a particular escalations can 1 or 50 notes (or more) depending on the work involved to resolve.
This table now has thousands of entries and is about 10Mb on it;s own.
It seems that when I open my bound forms the query is having to scan not only the main table, but also all of the notes in the journal table.
My question is,
Would I be better to -
1 - Use unbound forms and pull the data via a recordset call or
2 - could I use a query that captures everything for only the open escalations and then have my main form query that query or
3 - have the form load but do not link the journal table and have the form pull the data in seperately ?
Hope that makes sense and appreciate any help on this one.
MattP
View 6 Replies
View Related
Nov 25, 2005
I am trying to concatenate values from seperate columns. Which is fine, however if there are no values in any of these columns I wish to include a dot (.). I also need to add a dot (.) inbetween values.
So for example
Column1 Column 2 Column 3
B11 Europe
would concatenate as:
B11.Europe.
View 1 Replies
View Related
May 14, 2013
I am trying to concatenate 2 unique values which are parts of 2 identical rows(records) in order to have only 1 row(record) with concatenated field where the values are unique. For illustration here is what I need to achieve :
Initial table:
Fld1 Fld2 Fld3 Fld4
AAA XXX BBB CCC
AAA YYY BBB CCC
Final Table:
Fld1_____Fld2______Fld3__ Fld4
AAA____XXX,YYY___BBB___CCC
View 1 Replies
View Related
