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.
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.
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.
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:
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
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.
I've created a macro that will export one of my tables to a .csv. Everything is all fine and dandy, except that I need to find a way to have this command work on any computer. As of now, the command exports to C:UsersKodyDocuments, and can only do so because this path exists on my computer. But if I were to send this Access file to someone else to use, they would get an error stating that the specified path is not valid. Is it possible to create a general export directory which would work with any computer this is ran on?
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?
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.
I have the code below and I want it to open a file from my documents folder. The only problem is that every computers path is different to this folder. Any easy way to work around and open a file in My Documents without the full path?
I want to eliminate the part of the path in red and make it universal because computers will have a different number.
Operating System: Windows 7
Code below:
Public Function AddITARPicOffloadAnalysis() Dim xlApp As Object Set xlApp = CreateObject("Excel.Application") With xlApp Dim wb As Object Dim ws As Object Dim Lastrow As Long
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.
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.
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.
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.
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... ???.
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?
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!
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.
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?
Basically I have a Customer Form, which I have a New party button on it,this button opens up the party form to a new party, what I would like it to do is open up a new party but make the new party for the customer I had selected in the previous form.I have tried the GoTo macro's but cannot seem to get it to work.
I am thinking on clicking the button it will need to get the Customer ID, and then open the party form, create new party, and paste in the Customer ID, which then updates the Name - Date - Address - Company Fields.
I have been tasked with creating a tool to analyse mobile phone bill data and present the analysis, and our recommendation, to a customers. Being new to Access (other than basic tuition) this has been a slow uphill task, which is finally nearing completion, however there is a problem which I have not yet been able to overcome.
The requirement is for the DB to open first on a splash screen (lets call it Form A) with fancy picture where our customer is selected from a combo box, the customer is then telephoned, a linked computer screen is established and our staff then click "Go" to proceed to a second form (Form B) showing an account overview and more details.
The problem I have is when "Go" is clicked, the second form loads via on click event, and even populates the correct customer in its combo box. Unfortunately that is as far as it gets - the combo does not look up the information. The customer needs to be selected again for the subforms and subreports to load with the customer overview. To clarify, form B just sits there blank until the customer is re-selcted from the combo box in form B.
On the form: User enters first name, then last name. Upon updating the last name field, I would like another form to pop-up and display all the people with that same first name and last name that the user just entered.
On the pop-up form: All of the matching first names/last names are listed with a button control beside each record that says 'Select'. The user clicks the select button beside the record he/she wants. This pop-up form closes and all of the data from this selected record is now showing on the original form.
So far, I have a query/form that pops up only showing the matching first/last names. I'm having a hard time getting my original form to auto-populate with that record that the user selects on the pop-up.
(Also my main form is actually a sub-sub form - so in my trials I could've been massacring my syntax trying to point to it.)
I am trying to create a user form with sub form using the form wizard. I have only 2 tables, Employee (main table) and Vacation (subform table). I pick the fields from Employee Table then fields fro Vacation, but the wizard treat the Vacation as main form and Employee as sub form.
I have a fault form which the user enters details of a fault. When the fault form is submitted the data is saved in the relevant table and the form is cleared so that the user can enter the next fault. On the fault form i have a subform which displays the faults previously entered by the user. I want the user to be able to click on an entry in the subform and open the orignal fault form and see the data that had been entered. How can i create this functionality??
