Sub Cell Information In A Table

Aug 9, 2005

I am not sure if this has been done in a table before. I have seen it in forms but not in tables.

Here is my problem.
I have created a database for a planespotters club. This database has the tables.
ac_logged
ac_maker
ac_model
country
airport

I am trying to display selected information in the ac_logged tbl that is related to other cells. For example: If someone selects boeing in the maker field they will only boeing models in the model field. Also, if someone enters Ireland in the country field only the airports for that country would be listed.

I don’t want to do this in a form but I could settle for a query if I have to.

I was just wondering if this could be done in a table as opposed to any other way.

Hope I have made myself clear on this one. :confused:

View Replies


ADVERTISEMENT

Replacing Cell Value In A Table

Aug 1, 2007

OK, here is my situation. I have an access database which is updated automatically every night with new data. My companies solution to this is each morning, the entire database is downloaded to my computer to be used by another application.

In one of the tables, there is a field that doesn't work for my purposes, so each day I have to manually open the table, and change the contents of that field for every record. For example, lets say I have the following table:

Field1 Field2 Field3 Field4
Rec1 Wigets Faucet Model1A
Rec2 Wigets Faucet Model1B
Rec3 Wigets Sink Model1A
Rec4 Wigets Sink Model1B
Rec5 Wigets Toilet Model1A

Each day I manually change Field2 so it reads "Total" and whatever is in Field2:

Field1 Field2 Field3 Field4
Rec1 Total Faucets Faucet Model1A
Rec2 Total Faucets Faucet Model1B
Rec3 Total Sinks Sink Model1A
Rec4 Total Sinks Sink Model1B
Rec5 Total Toilets Toilet Model1A

Each morning when I receive the new database download, they all go back to widgets.

Is there a macro or module I can create to automatically look at Field3, and then assign a new value to Field2 based on Field3's value?

Any help would be appreciated!!!!

View 3 Replies View Related

Tables :: Different Numeric Values In One Cell Of Table

Jan 30, 2014

Is there a way to write different numerical values in single cell of table via form.

View 2 Replies View Related

Queries :: Check For Same Cell Value Access Table?

Jun 19, 2014

I've created a database with entries corresponding to different participants in a tasting experiment. All the entries are stored in a single table. The participants are each members of a family, with participants of a family given a family number (increments with family) (see image link below).

imgur.com/yM1vO59

I want to be able to check that for either 'Mother' or 'Father' of 'Child1','Child2', etc. within the same family, the location within the sweet, sour, bitter column is the same.

(I'm asssuming five queries will have to be run, one for each of the flavours).

To reiterate, I want to check for example if 'Mother' and 'Child1' within 'Family Number' 3 taste 'Bitter' in the same place (Which they do - 'Middle').

View 3 Replies View Related

Forms :: Two Textboxes In Form To One Cell In Table?

Dec 12, 2013

I have a form to input info into a table how can I combine 2 txtboxes to one column separated by ", "

Example:

textboxes:
txtboxFirstName txtboxLastName

output:

Last, First
into the "Name" Field in my table

View 1 Replies View Related

Sequential Number On The Basis Of Cell Value In Table

Feb 25, 2014

I have a table called External Audit.

I want each record to get a unique sequential number on the basis of Type of Audit.

Type of Audit column has 3 options OB, INR, MINR to choose from

If i select type as OB then the notification number should start from 1 and carry on numbering it whenever I select the same value.

When I select different type eg: INR then it should again start number on the basis of type. INR1 INR2, INR3 etc.

Is sequential number is the right word to use for this function ?

View 10 Replies View Related

Populating A Table With Value From Cell Above Across Multiple Columns

Sep 15, 2014

Doing Ctrl + ' will put in the value from the cell above it. But I want to do this across 4 columns. On one row, I am selecting across 4 columns and doing Ctrl + ' and only the first cell populates with the value above it.

Is there a way to get the 3 other columns to populate with the value of them (the values are different across all columns).

View 2 Replies View Related

Queries :: Update Table Where Column Cell Is Empty?

Aug 6, 2015

I have a small problem: I have a table with over 20 columns. In every column there are some 1's, but the other cells or tuples are empty. In these empty cells I want to write a 0. So I need an UPDATE query.

But what should I write for the WHERE condition? So he should check every cell and if there's no 1, write a 0.

View 7 Replies View Related

Tables :: How To Insert Text Box Value To First Empty Cell In Table

Mar 17, 2014

I have a simple form (frmAddPaper): txtPaper where user enters name of new newspaper, and cboCity, where user selects the newspapers town.

Also Close and Save buttons.I also have a table, tblCity. Columns as follow: CityID, City, Paper1, Paper2, Paper3, Paper4, Paper5, Paper 6.

Some cities have values (Newspaper names) in just Paper1 field. Others in Paper 1 & Paper 2, and some in Paper1, Paper2 and Paper3.I want to add the txtPaper value, to the first empty column, in the row where cboCity matches City column.

View 14 Replies View Related

Populate Table Cell With Value From Another Table

Jun 1, 2005

I have a form1 which record source table1 is and this form1 contains a continuous subform linked to table2. how do I automatically populate a field of table2 with th primarykey from table1, in order to show in the subform only those records related to the same primarykey as from form1.

thanks in advance!

View 1 Replies View Related

Queries :: Pulling A Cell From One Table To Another Based On (Account Number)

Jul 22, 2013

Table 1:
Account Number
Start Date
End Date
Cost data**
Budget data**

Table 2 (Imported excel file with cost/budget data):
Account Number
Cost data**
Budget data**

Table 1 is the main table that will be viewable in this database. The idea here is that new Account Numbers can be added to Table 1 throughout the year. It then pulls the cost/budget data into Table 1 based on the matching Account Number between table 1 and 2.

So, if the Account Number (Table 1) = Account Number (Table 2) then it pulls the cost/budget data into the cells on that row. I am trying to make this automated since this data is updated weekly and imported into Table 2 from excel.

View 4 Replies View Related

General :: Extract Multiple Values From A Cell To A Separate Table?

Aug 18, 2015

I have imported an Excel table with a column which has several values in one cell separated by "". In my case names of institutions afiliated with a patent. Example of the format of a single cell: MASSACHUSETTS INSTITUTE OF TECHNOLOGY (US) RIVE TECHNOLOGY INC (US)

In order to normalize the Access database I would like to extract the institutions to a separate table (institutions) and that the patent is related to both institutions.

I am using Access 2007.

View 2 Replies View Related

Queries :: Concatenate Field Data Into One Cell In Query According To Linked Table ID?

Mar 8, 2014

i need to Concatenate a fields data into one cell in a query according to linked table ID....

View 3 Replies View Related

Add Value To Cell According To Another Cell In Same Record

Nov 21, 2006

i have a table of articles. A field in the table is ArticleSubject

the ArticleID is made up of 3 letters then 3 numbers. i want the 3 letters to be something according to the subject
for example i want the first 3 letters of the ArticleID to be MAT*** (* is a number) if the subject is Maths
or ENG*** if the subject is English

the subject is picked from a listbox in the same record

how would i do this in a table . i am reluctant to use append or update queries.
but will do so if its the only way.

View 4 Replies View Related

DLookup Function To Load Information From Table To Another Table Using Subform

Mar 22, 2013

I have 3 table table; Invoice table, Product table and Sale_product table. Sale product table records all sale from the product table

Invoice table has these fields
ID
TOTAL
CASH_TENDERED
CHANGE

Product table has

ID
CODE
QUANTITY
NAME
PRICE

and Sale_Product table has these
ID
PRODUCT_CODE
QUANTITY
PRODUCT_NAME
PRICE
SUBTOTAL
INVOICE

I did main form from Invoice table and sub form from Sale_product table. I want to use DLOOKUP function to load the name and price, quantity and calculate subtotal automatically from the product table based on the product code entered. i have being trying hard and i keep on getting "Name? error"

View 1 Replies View Related

Information Within A Table

Apr 14, 2005

i am trying to create a form with a sub-form in it. i have got my client details in it - address, phone, etc then within that table i would like to keep a track of treatments for each time they visit in decending order. can anyone help me out with this? hope someone understands what i mean

View 3 Replies View Related

Looking Up Specific Information From One Table To Another

Aug 3, 2005

Hey everyone,

Ive got a bit of a problem with my database at the moment. Here are the two tables im specificly having problems with:

Item Stock

Item size
Serial Number
Delivery Date
Date out
Stock level

Item Fitted

Item Size
Date fitted
Reg number
Date Removed
Serial Number
Position

Here I have Item stock as my base table. Item Size and Serial Number info is collected from the base table and put into a combo box.

What im trying to do is when a specific item has been fitted, for access to note the size, serial number and date fitted, and place it into the correct record in the base table. serial number and size to be put in its respective table, and date fitted to be put in the "date out" field.

This is rather annoying i know and a bit difficult to explain, if anyone could help over msn that would be great - david_4321@hotmail.com

Thanks

David

View 1 Replies View Related

Query Table Information With T-SQL

Sep 12, 2005

I have been looking all over for the answer to this and can't find the slightest thing about it.

I need to know how I can query information about what tables are in a MS Access database. Lets say for example I can't access the database with the MS Access application and I want to write a web query in asp to list the tables in the database. For example, I may not know what tables are in there and need to find out.

I know there is a way with mySQL using the "show tables" command but it doen't appear to work with Access

I also came accross some code with OpenSchema(adSchemaTables) that is suppose to do the trick, but it either doesn't work or my shared-hosting provider doen't have it set up to work.

If anyone could PLEASE help me out with the T-SQL query code to get table info I would be greatly thankful!

Thanks in advance,
Dan
dan@innovativead.com

View 1 Replies View Related

Need Default Information From Another Table

Feb 7, 2007

Hello, I have been looking around trying to gather as much access info as I can. I could really use some help with what seems like it should be pretty basic to me. I am making database for excavation estimation and have a table with my equipment and a field for default costs. I then have a table where I assign costs to a specific job. So I would choose a piece of equipment from the equipment table and then would like the default values entered in from the equipment table into the job table for the default costs. So a default value is put there that can be edited for the specific job. I am guessing I need to enter something into the default data area on either the table or on a field on a form? Can anyone give me the format for putting this in. The primary key in the equipment table (auto-number) is linked to a foreign key in the job table. Thanks in advance.

View 1 Replies View Related

Problem With Getting Information From A Table

Feb 14, 2007

Im using Access 2003.


I have a form with a combo box that has a list of all the names that are contained in a table.

I am trying allow the user to select a name but then when the user selects that name it pops up the email in another text box. The name that is being selected is in the same record that the email is in.

whats the easiest way to do this? vba?

View 1 Replies View Related

How To Call Information From One Table In Two Spots

Jun 19, 2006

Please help!!

I am creating a program that will allow the user to select a sale and pull up only those product items associated to that sale in the details. Any help would be appreciated. Then with in the details section the user will/should be able to enter in the Quantity needed to order. Any suggestions on how to do this. My tblSale does provide the data needed so how do I get the data to go to the form?

I am new to this forum so if I have not asked properly I apologise now.

The Database is attached. Form Orders is the form that I am using to accomplish my task. The getproducts4Sale Query is the information needed.

View 1 Replies View Related

Adding Information To A Read-only Table?

Jan 31, 2008

Hello,

I wasn't sure which area to post this question in...since it involves queries, tables, and forms :)

There is a read-only table in my company's data warehouse that stores a lot of records. I wish to set up a form that will allow users to add or relate data (fields) to each of those records.

Updating the data warehouse table structure is not an option.

How can I best do this...

1. set up my own table somewhere, that will automatically append any new data warehouse records every night, so basically I'll always have a copy of the DW table, but with additional fields that can be updated?

2. set up another table/query that are linked to the DW table via unique identifier...but if I do this, how do I display the DW records alongside the new fields in a way that makes sense? another query? will I be able to write in data in this fashion?

3. ...some other way?

Any assistance will be very much appreciated!

View 2 Replies View Related

Table Structure - Transfering Information

Sep 25, 2006

I am creating a database for a hyperthetical car hire company. I have a table for the customer details, a table for car details, a mid table with current car hire information. I want to create a table for previous car hire information. Is there a way that i can transfer the details from the current car hire table to the previous car hire table without copying and pasting? (when the customer returns their car)

View 1 Replies View Related

Transfering Information From Query To Table

Mar 15, 2006

Hi there, this is probably a very simple problem for people with experience of Access, however i have been having problems with being able to tranfer information from a query to a table.

I have made a query which displays a number of different items with their prices and who bought them (ie. booking ID)

I have then made a query which asks for the booking ID, then once you have input that it searches the items and adds up the price for all the items which that booking ID has.

both these queries work fine. The problem i am having is that i want to transfer this total price into a table. I have been able to do this by manually typing into the sql code the price, however when i try to get the query to collect the price itselfs, it gives the error
"operation must use an updateable query"

btw i am making the query as a update query,

sorry if this post is a tad long and messy,
thx in advance for any help

View 1 Replies View Related

Forms :: Look Up Information In Backend Table?

Aug 2, 2013

Is there a way to set up a keyword search within a form and use it to look up information in a backend table?

View 3 Replies View Related

Tables :: Pull Information From One Table To Another

Nov 19, 2012

I am brand new to building a database.What I want is a database to store Quote, Job and Invoicing information. We receive quotes first and then they can, but don't always, turn into jobs. We can also receive a job without quoting it. We currently have two spreadsheets. One is for Quotes and the other is for Jobs.

QUOTES INFORMATION
Quote #
Date
Customer Name
Part #
Part Name
Quote Due Date
Qty
Lead Time
Price
Unit

JOBS INFORMATION
Job #
Qty
Quote #
Customer Name
PO#
Part #
Part Name
Est Hours
Start Date
Due Date
Price

As you can see a lot of the information in the Quote spreadsheet is also used in the Job spreadsheet. (Bold represents duplicated items) We currently type the information into each spreadsheet.

Then there are different forms that are filled out for quotes and jobs that contain the information in the spreadsheets.Is there a way that I can have the QUOTE Table automatically populate the JOB Table information?

View 6 Replies View Related







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