General :: Combo Box - Multiple Tables

Jun 26, 2014

I have
tblProducts - Where is my inventory list and
tblServices - where are my services

Also I have made an invoice form and a datasheet subform (orderDetails) where I enter/choose (using combo box) said services/products but I know only how to do it for one table ex. tblProducts. My question is can I make a drop down list for two tables? One column - ServiceName / ProductName
So I can choose a service or a product in the same order line.Or do I have to join my services and products in the same table?

View Replies


ADVERTISEMENT

General :: How To Filter Records Using Multiple Combo Boxes

Jun 29, 2014

I have a table with the following 5 fields. (Service Type), (Valve Name),(Size),(Rating),(Description).

I want to do two thing:

First: I want to select the required information from the first 4 fields using combo boxes and get the last field (description) based on the selected 4 fields. In other words, i want the record to be filtered using first 4 fields to give me the last field info.

Second: I want to store the filtered record (all 5 fields) in another table.

View 6 Replies View Related

Choosing Subform From Multiple Tables With Combo Box

Sep 6, 2005

Hi guys,

I've run into a little problem while working on a electronics component database:

My plan was to use one specific table for each kind of components, i.e. resistors, capacitors, transistors etc as the specific data of each type is quite different from the other types (resistance/capacitance etc). I also thought I'd use a main form with a drop box allowing the user to choose which component to look for and then a component type specific subform to let the user make a more detailed search.

The thing is that I'm not quite sure how to call different subforms based on the drop box selection (I guess I need a subform for each type of component)? Or can I call a table with each component's specific data types and generate a subform based on this table? (I'd prefer the latter...)

To find a specific resistor you might want to specify the resistance, the type of resistive material, size and tolerance whereas an integrated circuit requires information on type of circuit, package, size etc.

All similar questions I've found relates to the use of a single, main, table only, I can't really see how to do that here...

View 1 Replies View Related

Combo Box To Find Records From Multiple Tables

Jul 30, 2013

I have a main form that has fields from different tables. This is a research study, so each form enters data into different tables. Well, each record is a person's data. Instead of scrolling through each record, I need an option on the main form that allows me to search for a specific person and have their data populate into the form.So far I am able to make a combo box that pulls up the record from one table. Well, HOW do i do it from ALL the tables!?? Do I have to make a query?

View 3 Replies View Related

General :: Dynamically Search Multiple Fields From Combo Box On Form

Mar 21, 2013

[URL] ....I am trying to dynamically search multiple fields from a combo box on a form that includes a subform. I am using code from the above referenced link within this forum.

It works without the "setFocus" for the Listbox except it jumps to a record after the very first character is entered instead of narrowing down as characters are typed. If I leave in the "setFocus" I get run-time error 2110.

View 14 Replies View Related

Adding A Field To A Form Using Multiple Tables (And A Combo Box)

Jun 15, 2006

Hello!

It's been a while since I've asked a question here, but I can't seem to figure this problem out.

I am setting up a form using data from 4 different tables, all related, and I can't figure out how to add fields that I didn't initially add during the wizard set-up. I used the wizard because it's easier for me to do that and then go in and make the changes I want to make.


When I get data from just one table, all of the available fields from that table are in the "Field List" no matter what fields I chose to include in the wizard process. That's good. But when I get data from more than one table, only the fields I initially chose in the Wizard process are showing up in the field list. I can't figure out how to add a new and different field from one of those tables.

The way I "solved" this problem the first time was to start over, creating my form from scratch--but now that I've done a lot of work, it just occurred to me that I will need to add 2 more fields. (I actually don't even have those fields in a table yet, but I will add them later.) So, this will be an ongoing problem. Since this form will get much use, by several people, I don't want to have to re-create it every time I want to change something.

So, is this possible? How can I add another field?

Also, while I am at it... A combo box was working beautifully to look up specific records when I was gathering information from only one table. It isn't working anymore.

Thanks in advance!

-Siena

View 8 Replies View Related

Tables :: Select Multiple Items In Combo Box In Form?

Mar 6, 2015

I have a form with a combo box named 'Venue'. The combo box values comes from a Table with a list of about 200 countries. As of now a user is able to select only one country. However, I want users to be able to select more than one country.

View 1 Replies View Related

General :: Multiple Tables In Reports

Jan 27, 2014

I have a DB with 3 tables;

1) Customer details (address, phone etc)
2) Equipment they have
3) Service History

So that I can print a report showing all of the above on a A4 form I have a simple query which filters using a tick box (on Customer Details).

This works well unless I tick 2 box's. I then customer details, equipment & Service History get jumbled up and isn't record specific.

View 3 Replies View Related

General :: Exporting Multiple Tables As XML?

Oct 11, 2014

I can use the following codes to export from Table1 to the exported.xml file.

Application.ExportXML _
ObjectType:=acExportTable, _
DataSource:="Table1", _
DataTarget:="Exported.xml"

If I also want to export multiple tables, can i use the following from Access 02/03.

Dim objOtherTbls As AdditionalData
Set objOtherTbls = Application.CreateAdditionalData
objOtherTbls.Add "Table1"
objOtherTbls.Add "Table2"
objOtherTbls.Add "Table3"
Application.ExportXML ObjectType:=acExportTable, _
DataSource:="Table1", _
DataTarget:="Exported.xml", _
AdditionalData:=objOtherTbls

I think Access 03 Application will have problem recognising CreateAdditionalData. Is this correct?

View 1 Replies View Related

General :: Multiple Tables Into One Form

Jun 2, 2014

I have 3 table each with the same columns.

1st table = current documents
2nd table = documents awaiting approval
3rd table = old documents no longer in use

I currently have a subform within my search form that I use to filter the results via a textbox on the form. I would like to have the contents of all three tables present in the subform.

View 1 Replies View Related

Forms :: Create A Form Using Combo Box To Populate Multiple Fields And Tables?

May 26, 2013

I'm trying to create a form using a combo box to populate multiple fields and tables.

I've created a text field to display the added information using this format:

=Comboboxname.Column(x)

in the text box control source field, and this works for display purposes.However, I need it to populate this data into a field on a table.

For example:

My combo box looks up data that has 2 columns, Part Number and Description.

The control source for the combo box is "Part Number". And that populates the part number in the "Main" table no problem.

The text box I created using the above format in the control source populates the field in the form, but not the "Main" table.

Is there a way for the other (description) field to also populate the "Main" table as well?

View 5 Replies View Related

General :: Add And Update Multiple Records To Different Tables

Jan 12, 2013

I have a pretty normalized Access Database. The table that I am trying to add new records is tbl_returns and has 4 fields: return_ID, serial, reason and inv_num.

When I sell a card (or a range of the cards) an invoice including all the information is saved as a record in a new row in tbl_invoices.

If a vendor wanted to return a card (or a range of the cards) in the next visit (weeks or months later) I will accept and in most cases they want me to switch the cards with new ones. Therefore in a new invoice (different date and invoice number) I will give him new cards and return the cards that he wanted to change or return.

Now I have to assign NULL to the inv_ID field in tbl_allPins in order to make it available for sell in future. At the same time I want to have a record of the returned cards including serial number , the reasoning of return, invoice number and/or a little note about each one/range of the card(s).These are to be recorded in tbl_returns as you can see.

For instance you want to return serial numbers between 9876 and 9880 (includes 5 cards) because of the "scratch off problems" and your invoice number is 22222, using frm_returns. After you process it and then open the tbl_returns to check the result, you will see 6 records are added instead of 5. I was able to understand why it is happening (I believe so!) but I could not fix it. Also I cold not write a VBA to remove the inv_ID in front of the related serial numbers in tbl_allPins.

Also in another trial was ended up to creating the Form1. Form1 looks better (has no extra records) but I have trouble to navigate through the records in tbl_returns. There was a sub-form added but it was showing all the records in tbl_returns which is unwanted.

By the way, serial numbers and PIN numbers are each a unique number in tbl_allPins.

View 3 Replies View Related

General :: Adding Record To Multiple Tables

Jun 6, 2013

I have a main table with subject id and other fields. I also have 16 other tables which have questionnaire information at 17 different timepoints. In those tables, the subject id is the only connected field between the main table and 17 different years. When I add a new record (by subject id) on the main table, I want it to add that same subject id to the 17 other tables because that subject id will eventually get all 17 years worth of data. But even using subforms, it will not add a new subject to the other tables unless I add some sort of information such as (date received) into the subform.

View 6 Replies View Related

General :: Creating Multiple Relationships Between Two Tables

Aug 2, 2013

I'm trying to create multiple relationships between the same two tables, but I run into problems every time I try. I'm using Access 2007.

Specifics:
I have a table with information on meetings and there are two hosts. So I have fields Host 1 and Host 2. I have a second table that lists possible hosts and their personal information. I have a relationship between table 1 "Host 1" and the Host in table 2; I cannot create another working relationship between table 1 "Host 2" and the Host in table 2.

how I can get that to work? With just the one relationship, I can go to table 2 of the hosts, click on their name, and see all their meetings.But if I add another relationship, it takes out all of the information. I've been working on this for over an hour,

View 2 Replies View Related

General :: Comparing Data From Multiple Tables

Nov 5, 2013

We have an "item" table that contains information specific to an item (the item number is unique); and multiple "production line" tables. There is a relationship between the Items table and the Production Line tables (all 8 of them). Each item can be entered on 1 or more production line tables because one item may be produced on multiple lines and the settings vary based on the line they're produced. When entering an item in the Production table we MUST make a selection from the Item table.

Now, what I want to do is identify which item number(s) from the Items table does not have a specific field entry in ANY of the Production Line tables.

View 9 Replies View Related

General :: 3 Different Tables - Export To Multiple Tabs In Excel

Jun 30, 2015

I have information held in 3 different tables and I would like to extract this information to three different tabs in a singe Excel workbook - preferably in one step.

My access knowledge is fairly basic but I have been looking online and I can only find out how to do it using a VBA script - which is quite terrifying! Is there a simple way to do this?

View 1 Replies View Related

General :: Using One Entry To Create A Record In Multiple Tables?

Oct 21, 2012

I'm pretty new to making databases outside of a basic access class..Is it possible to make a record in one table that makes a new record in 5 different tables using different bits of the initial record?I want to use the data entered in an evaluation form to create a new entry with the basic identifying information in 4 different tables.

View 12 Replies View Related

General :: Export Multiple Tables To One Excel Worksheet

Apr 23, 2013

I am using Access and Excel 2007. This Db is for a mental health practice to track and store the paper questionnaires that the patients fill out. The data then needs to be exported to Excel so that it can be imported into a proprietary software that analyzes the data and recommends treatment plans. (It does NOT play nice with Access, forget it.) There are many forms and all of them are fine and export to separate worksheets no problems.

Now for the problem child: One form has 493 fields. Obviously I could fit that into two tables, but it seemed cleaner to use a main form and main table with the patient information (ID_Number, Name, Date, etc.), then tabbed subforms and separate tables for each “section” of the questionnaire (School, Work, Home, etc. There are 11 tables/forms in all.) These tables are all related by the ID_Number. The problem is the export. I need all 493 fields to write to one worksheet in order. This would of course involve removing the ID_Number field from all the tables except the main one. A query obviously can’t handle that many fields. VBA I can TransferSpreadsheet but then each table goes to a separate worksheet.

I’m thinking maybe calling some SQL code that will drop the unneeded fields and keep appending the data to the worksheet one table at a time? Of course the rows would somehow need to be defined WHERE ID_Number = ID_Number so that the same patients information is all on one row.

View 10 Replies View Related

General :: Export Multiple Tables To XML But Excluding Linking Fields

Feb 4, 2015

I've been using a series of 5 tables to export an XML file using Access's native XML export. In order to keep the XML intact, there are relationships setup to link each sets of elements together via an ID number(link) field in each table.

Access does a great job at exporting, but then we need to rely on another program to delete these link fields that links the tables together so our XML validates. Additionally, we use this program to reorganize some of the XML, as one of our tables puts itself at the end of the XML element and not in the middle where it should be. This is not a problem when I'm dealing with a few hundred records, as the 3rd part program does the trick. The problem is when I have enough data to generate a 30+MB file that my other program chokes on when trying to manipulate the XML.

So my question is...how can I export these 5 tables to XML while omitting the linking member fields and organizing it how it should be? I have examples of code below. How Access Exports it

Code:
<MASTER-RECORDS>
<RECORD-ID-NUMBER>5648743524654</RECORD-ID-NUMBER>
<RECORD-ID-NAME>JOHN SMITH</RECORD-ID-NAME>
<link-for-pseudonyms>123456</<link-for-pseudonyms>
<PLACE>USA</PLACE>
<DAY>MONDAY</DAY>

[Code] .....

View 5 Replies View Related

General :: Auto Fill Multiple Fields In A Form From 2 Tables

Apr 3, 2015

I have two tables, "Summary" and 'POC Information". In the "POC Information Table I have all my Contacts Information (Name, Title, Phone, Email, etc...) and I am trying to assign 2 POCs to each of my multiple projects located in the "Summary" Table. I am using a Form called "JCIDS Tracker Input Form" as the link. So far I am able to assign one POC by a combo box that lists "Full Name", then it autofills the other information...Phone Number, Email, etc... The problem come into being when I want to assign a second POC to the same Project...I can assign a name, but it won't correctly autofill the rest of the information...it just autofills in the information from the first POC that was selected.

View 8 Replies View Related

General :: Merging Data From Multiple Tables Into Single Column

Sep 10, 2012

I've created a access database containing multiple tables, theres one main table that will contain all the data compiled.

I then have other tables that contain some matching data but with an additonal column filled in,

I want to be able to pull the data from these other tables into the main table and compile it including merging some data into a single feild.

Effectively this is what the inputs will be:

Code:

Table 1
Ident Number Solution TRN
T0941A1 SLN019149 EFE0008
T0941B1 SLN019149 EFE0008
T0941C1 SLN019149 EFE0008

Code:

Table 2
Ident Number Solution TRN
T0941A1 SLN019149 EFE0167
T0941B1 SLN019149 EFE0167
T0941C1 SLN019149 EFE0167

Code:

Table 3
Ident Number Solution TRN
T0941A1 SLN019149 EFE0188
T0941B1 SLN019149 EFE0188
T0941C1 SLN019149 EFE0188

Then the main table i want to compile the data like this:

Code:
Table 4
Ident Number Solution TRN
T0941A1 SLN019149 EFE0008,TRN0167,EFE0188
T0941B1 SLN019149 EFE0008,TRN0167,EFE0188
T0941C1 SLN019149 EFE0008,TRN0167,EFE0188

i want it to show as 1 line item and compile the TRN numbers into a single feild per row rather than having duplicates.

View 1 Replies View Related

Tables :: Linking Multiple Field Values To A Field Selected From Combo Box

Feb 16, 2014

I'm pretty good with setting up a very simple database such as inventory, profiles, etc.. However I'm creating a database to keep track of a football (soccer) team's players and match statistics.What I have so farsample attached)

Tables:
* Players - PlayerID, Fname, Lname, position, goals, assists, etc (all details regarding a player)
* Position - Positons (Table containing positions eg: defender. Data is selected in player's form as a combo-box)
* Competition - Competition types (Cup, League, Friendly. Data is selected in Match's form as a combo-box
* Venue - similar to Competition table
* Opponent - Similar to above two tables
* Match - MatchID, Competition, Venue, etc (form corresponding to table attached)

Forms:
* Player form
* Match form

Now as shown in the sample, I choose players using the combo-box. Then whatever stats they had during the match are entered on the fields provided. How to link the player (selected using combo box) to the stat fields (goals, assist, YC, etc).

View 1 Replies View Related

Append Query, Multiple Tables To Multiple Tables In Another Database

Nov 29, 2007

Can a Append Query move all my data stored in multiple tables to another database with a identical table structure?

Because as I try to work the query, I keep getting prompted to "Select a table" I want to append to, and I don't want to append to just one table...

View 4 Replies View Related

Filtering Combo Box Based On A Value From Another Combo Box (in Multiple Items Form)

Mar 11, 2012

Let's assume we have 3 tables:

Order_Category (Order_Category_ID, Order_Type_Name) with 2 records:
1, Minor
2, Major

Order_Type (Order_Category_ID, Order_Type) with 4 records:
1, Book
1, Pencil
2, Car
2, House

Orders (Order_Category_ID, Order_Type, value) with 2 records:
1, NULL, NULL
1, NULL, NULL
2, NULL, NULL

I want to create a Multiple Items form presenting Orders table with two Combo Boxes:

1. A combo box to select Order_Category_ID.
2. A combo box to select Order_Type. When 1 (Minor) is chosen in the first combo box it should show Book and Pencil, when 2 (Major) is chosen it should show Car and House.

Examples in the Internet show how to do it on a 'single row' forms using the RowSource property. I tried to use a query like:

SELECT Order_Type
FROM Order_Type
INNER JOIN Orders ON Order_Type.Order_Category_ID = Orders.Order_Category_ID
WHERE Order_Category_ID = [comboBoxOrderCategoryID]

But it sets same values for all records in the Multiple Items form and it should return different values in each rows based on value in the first combo box (Order_Category_ID).

View 5 Replies View Related

Combo Box Multiple Colums As One Colum In Combo

Mar 28, 2006

Hello

I have had a look through the forum and I am not sure if this can be done. I have a table. i.e. with columns Decsription 1, Cost 1, Description 2, Cost 2 Description 3, Cost 3 description 4, cost 4 etc.

I am looking to try and gave a combo box show this information as follows. I.e

Colum 1 on Combo; Column 2 on Combo

Description 1 Cost 1
Description 2 Cost 2
Description 3 Cost 3
Description 4 Cost 4

I want to be able to auto fill some fields on a form based on the combo box selection.
Has anyone done this before and can it be done.

Thanks

View 1 Replies View Related

General :: Export Access Table To Multiple Excel Workbooks With Multiple Tabs

Dec 13, 2012

I am using Access 2010 and Excel 2010. I need to have VB script to export the access table 502 records by 38 fields into Multiple Excel workbooks each having multiple tabs. In the Access table each record has two fields: Div and Tab that will be used to name each workbook and each tab (sheet). There are 6 unique "Div"'s to name the 6 workbooks and there are several "Tab" names for each Div (workbook).

Note: These 6 workbooks with multiple tabs were originally imported into Access from one common folder on my desktop by this routine:

Option Compare Database
Option Explicit
Private Sub Command1_Click()
Dim blnHasFieldNames As Boolean, blnEXCEL As Boolean, blnReadOnly As Boolean
Dim lngCount As Long

[Code] .....

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved