Copying Table Structure
Nov 27, 2006Is there a way to create a new independent table from the structure of an existing table? I want to create the same table with no records and place it in a separate folder
Thanks in advance for your help.
ADVERTISEMENT
Copying The Structure Of Forms And Tables And Their Associations?
Sep 8, 2011I have a psychology project where we soon use a questionnaire on a daily basis (maybe 80 variables per day per subject). Currently, there is no data in the database.
I've managed to create a table called day1 (with 80 day1 variables) and a form that looks like the questionnaire we want to use (and linked apropriately to the variables in the table for day1).
What is an easy way of duplicating the table and form for successive days? That is, i want the structure of the day1 table copied to another table (call it day2). It has exactly the same variables except they are slightly different to differentiate them from day1. I would like the form for day2 to have exactly the same layout as the form for day1, but link to the variables in table 2.
I know i could just couple the day1 table, change the variable names slightly, and then copy the form for day1 and change the links to point to table2, but there are many assessments (18 days).
Tables :: Normalize Existing Table Containing Data And Copying PK Value To FK In New Table
Nov 21, 2014I am working from an existing database which is just two table. The main table has a massive amount of redundancy and duplication and needs splitting into, at first glance, 5 tables.
After I have run my various make table queries and added a Primary Key and FK field to the new tables how do I populate the FK with the Parent PK.
I thought I could simply add all the fields from the new table and then create an adhoc join in an update query to populate the PK to the FK. When I do this however I get "You are about to update 0 records"
I have tried the table analyzer but it doesn't give the correct options to split the table the way I need.
Modules & VBA :: Copy Structure Of A Table To Make A Temp Table
Apr 20, 2015I'm trying to copy the structure of a table to make a temp table. I'm using CopyObject (which also copies the data). So when I delete the data from the temp table, it also deletes data from the source table. Is the data linked? It should just be deleted from the temp table. Below is the beginning of the code. I've stepped through, and at the last step shown, the data in the source table deletes.
Code:
Dim strFile As String
Dim temp As String
Dim tbl As String
Dim db As DAO.Database
' error handle
On Error GoTo F_Error
[Code] .....
Copying Of Data Between Table's.
Nov 25, 2004I am creating a database where I want to have a table that has references to another table.
I have an ID field in both that are linked. I want to be able to on creation of a new record in this new table have it grab the ID field from the other table.
Copying Records To A New Table
Feb 16, 2005I am trying to help a new employee with an MS Access 2000 problem. The db was created years ago, and the main table (permits) needed some major changes. She created a new db with a table that has all the same fields as the old db, but many new ones as well. We want to now import the data from the old db's "Permit" table to the new db's "Permit" table. All the field names are correct, but we keep getting errors trying to import and export. There are approximately 940 records.
Is there an easy way to do this? Thank you!
Mike
Copying Data To A New Table
Mar 1, 2005hi
I am trying to copy the data from one table into another table. I then wanted to update the table where it is copied from. This data i then wanted copied into that table in another row.
Any ideas?
Copying Table Contents
May 18, 2005Hi,
I am trying to copy the contents of a table with 11 fields into a new table which is the same except for an additional two fields at the end.
Any advice would be appreciated..
Thanks..
Copying Data In One Table To Another-how To?
Jan 12, 2007Hi:
I am looking for some guidance in doing the following:
I have a tableO that contains a list of objects that have associated attributes, specifically a list of system_names (object) and the associated attributes (additional fields in the table) that include port_name, port_direction. Think of each one of the records as a template that will supply data to another table, called the Instance table (tableI). The concept is that the user can populate the template with various objects and associated ports, and direction.
The table cols are;
PK|FK|system_name|port_name|port_direction|
The data for this table is manually entered via an associated form.
At some later time, the user want to make a copy of an object(e.g. a record in tableO) by populating Table I (the instance table). The first few fields of tableI are named identical to tableO. Table I contains additional fields that further refine the template, by adding a object_property field, and a port_direction_property field.
Table I looks like:
PK|FK|system_name|port_name|port_direction|prop1|p rop2
The forms interface allows the user to fill in the fields in the TableI (intance table) directly, or, lets the user scroll through the list of objects in the template table, and chose a template, copy the fields:system_name|port_name|port_direction into the same fields in table I, and then add values to prop1 and prop 2 manually.
I made the combo box control that will list the objects from the object column of the template table (table O) and make the desired selection. I have a radio button adjacent to the combo box that when clicked, will copy the selected record and designated fields from the template object table (tableO), into the same fields of the instance table (table I). The instance table is displayed on an adjacent form.
After the fields are copied to the instance table, the user can type in the data into the additional fields (e.g. prop_1, prop_2), and complete the record.
I do not know how I can do the 'copy' from tableO to table I when the radio button is pushed. I know to allow an action when the radiobutton is 'clicked'. Table O and tableI are not currently related.
Can you provide some guidance?
Thanks a lot for your time
J
Copying Data From One Table To Another..
Dec 13, 2007Hi,
I'm looking to include a button on a form that opens a new entry in another table and copies some field entries from the first table into the second table. I tried an append query, but it seems to be unable to be displayed in a form. I just want to copy data from one form to another. Thanks.
Need Help With Table Structure
Oct 28, 2004Here’s a little scenario:
An engineer requests that “x” amount of computers are ordered for the company. The estimated costs of the system(s) are determined. The estimated cost of the systems is forwarded to a manager, and the request must be approved by a manager before the order is placed. Once the manager approves the request, the order is placed through the ordering company. After the ordering company approves the order, an order number is assigned and serial number(s) specific to each computer is associated with that order number. At this point it is possible to track the order status via existing programs using the assigned order number and serial numbers. After it is determined through the existing software that the order has been shipped, invoiced, and received by the Receiving department, I need to physically go pick up the systems and submit them into my Central Inventory. From the central inventory, systems will be checked out to employees as needed, checked back in when testing is finished, or transferred internally between employees......
Table Structure
Nov 15, 2004Hi everybody,
Please, I really need some help with my normalised tables and relations:
1.AdmissionID
AdminYr
.......
2.StudID
SName
AdminID
.........
3. ParentContactID
Fname
StudID
4. CycleNO
cycname
.....
5. DisciplineID
Discname
CycleNo
StudID
.......
6.SubjectID
subName
DiscID
....
7. ExamID
examdate
StudID
8. Results
StudID
ExamID
mark
......
I have a feeling this relationship, is still a bit messy?
I also need to keep track of students daily class attendance, at the end of the tern, or year to find out how many students dropt out of a particular class etc. Is this a new table?
thanks in advance.
haag
3nf Table Structure, I Think, No What?
Dec 15, 2004I have been reading up on normalizing table structures. I have this database that I am working on, to work as a hiring database. It should hold information about people applying to the law firm I work at.
I am looking for advice on if this table structure is normalized and sound. I am also looking for specific help on creating good forms.
Thanks for any help that can be given!
ps. I am attaching a zip that has a jpg view of the tables and their relationships, as well as the db with the table structure.
I would love any and all advice. I want a very clear concept for this db before I do anything!
Thanks again!
:D
Structure Of A Table
Apr 27, 2005I was having a discussion with a friend of mine about this... and I couldn't come up with the best explination. Hopefuly someone here can point me in the right direction.
He has a table
Recipies(Id, name, item1, quantity1, item2, quantity2, item3, quantity3, item4, quantity4)
I don't believe that this is the proper way to create a table. What happens if you happen to come across a Recipie that needs 6 items?? or more??
After researching it, I believe it violates 2NF. Is this correct?
Instead I think a better structure would be
Recipies(Id, name)
RecipiesIngredients(Recipies.ID, Ingredients.ID, quantity)
Ingredients (Id, Name)
The problem my friends sees with this method is the fact that the Xref table will get giant.
In the example... Speed is of utmost importance, as the tables will most likely contain thousands of records and be queried against frequently.
Thanks for any input.
-Mike
Table Structure.........
Aug 27, 2005hello this is my 1st posting....... :o
please help me .........
I have 3 tables.....
Table : Customers
CustomerID
CustomerType (i.e. 1st Allottee, 2nd Allottee etc.)
Name
Address
C/o
...
Table: Apartments
File# (every apartment has unique file#)
Category
App#
Level
Area
Price
Discounted (yes/no)
DiscountRate %
...
Table: Receipts
Rec#
RecType (Down Payment, 1st Installment, 2nd Installment...)
Ref
Date
Chq#
Amount
...
one customer can have more than 1 apartments, and one apartment can be transfered to another customer (file# same but customerID changed)
one customer is paying different types of payments against his apartment.
please help me to manage tables and relationships.
Table Structure Help
Jan 29, 2006I need some help trying to setup tables on a new database. I want to setup a house analysis database where I can evaluate each room for it’s condition broken down by feature. I can’t seem to figure out a good way to tie all the rooms and evaluations back to that house’s address (primary key). I want the fields to work as shown below with the room evaluations tracked to each room and house address. If possible I would like to be able to enter the as many room names as needed for each address.
House Address
Bedroom 1______________Bedroom 2_______________Bathroom 1
Ceiling condition –Good____Ceiling condition-Fair____Ceiling condition- Good
Floor condition – Fair______Floor condition – Fair____Floor condition - Fair
Wall condition – Good_____ Wall condition – Bad____Wall condition - Good
Can someone please explain to me how I should structure the tables to work. As a novice Access programmer I am out of ideas. Please help me!!
Table Structure
Jan 30, 2006What's the best way to setup this db?
I have the following information:
Company
Company ID
Program A
Program B
Program C
Program D
2000
2001
2002
2003
2004
2005
The years indicate the year the Program participated in the company. For example, Program A participated in Company Z from 2000 to 2005, Program D participanted in Company Z from 2001 to 2002.
Should I have a table with the Companies and Program A and the years from 2000 to 2005
and a table for the Companies and Program B and the years, etc? I was going to add a yes/no field for each program, too. There must be a simplier way.
I want to be able to query participation of workers in any of the programs.
What is the best way to set this up?
Thanks.
Table Structure
Apr 14, 2006I've got some tables, and I want to make sure I relate them in the best possible way.
Table1 has a one to many relationship with Table2
Table1 has a one to many relationship with Table3
Table2 has a many to many relationship with Table3
Would it be best to set them up this way or is there another way that would be better?
Fields for Table1
Table1_ID
.
.
Fields for Table2
Table2_ID
Table1_ID
.
.
Fields for Table3
Table3_ID
Table1_ID
.
.
Is My Table Structure Ok?
May 14, 2007Hi,
Thanks for taking time out reading my thread!
I want to start entering data, but i'm not to sure weather my relationship structure is good enough to start inputing.
Heres a pic of my relationships
http://img201.imageshack.us/my.php?image=almostdoneae0.jpg
Thanks.
Help With Table Structure
Sep 4, 2007i have been asked to design an access databse for a friend who is a bricklayer. He wants to use it to store all the work he does so he can produce his timesheet quicker.
He works on building sites and has to show a plot number next to all the work he does. He wants to be able to search for a plot number and see what jobs he has already booked in for a particular plot number.
For example, if he is working on a block of flats, each flat will have individual plot numbers. If he is working on the outer wall of the flat his timesheet has to show all plot numbers for that block so he will normally show this as plots 100-110. however, if he works on an internal wall in one of the flats he will have to show just one plot number on his time sheet, for instance plot 104.
my problem is that he wants to be able to search for plot 104 and have it list both jobs he has done even though one job is shown as plots 100-110. How can i structure the database tables to allow this to happen.
Any advice would be much appreciated.
Table Structure
Oct 10, 2007hi everyone,i'm new to access and despite reading quite abit im just not grasping how to set up tables and relationships for what im wanting to do.I need a customer contacts table/form to keep track of my customers info (name, address, etc) & who's placing orders, easy enough.Now with some of my customers its always the same person who places the order but with others it can be anyone of up to about 15 different people who place the order each one can have their own direct phone no.So what im wanting to do is create a customer contact table/form and then linked to that who in that company placed the order with their phone no. Ideally i'd like it so once I have entered the info I can just use drop down menu's to select the company name then it opens up a list of all the people who I deal with in that company so I can just select the person/phone no who is placing the order.Can anyone help & advise me through best way of doing thisthanks alot
View 5 Replies View RelatedTable Structure Help
Nov 14, 2007Hello, I want to fix a database I built and I needed some help on the table structure since its saving the data and not the ID number. I have it done and it works but its not correct since I dont understand normalization very well I took the easy way out and now its killing me and I want to fix it. Please take a look and give me some advise or show me a structure on what I need to do to normalize the DB... This would be my first DB so bare with me....
The comments section of each category will have a list of positive phrases and negative phrase equal to the subject like Safety, Quality, Quanity ect. "I didnt pur the phrases in each table yet"
Thanks!
Help With Table Structure Please
Dec 9, 2007Hi peeps,
I'm creating a simple db to stor project details. Each project has a unique name, and is part of a programme. Each programme name (ie SIG023) can have multiple projects. these projects recieve numerous support plans, guides and tto plans. I also want to store comments on each project.
Does my relationships and table structures look ok? am i starting in the right lines?
Has anyone come accross a similar db?
Appreciate any advice.
Mike
Help On Table Structure
Jan 18, 2008Good morning,since this is my first post I hope I'm not making to many mistakes.I'm making a database for school in Access 2003. In this database I have 2 parts.. A part for Patch connections and a part for PC repairs. The PC repair part is doing okay. The patch part is where I'm having some trouble.I don't exactly know how to start with it, and I'm hoping someone here can help me out.The form, I want to make based on tables should look something like this:A ComboBox filled from a table with about 10 entries in it. (Patchkasten)A textfield in which I have to enter something like this: XX-00 (x stands for alphabetic - 0 stands for nummeric)(Patchnummer) This will have around ~3000 entries.Those 2 should somehow be connected in a table as 1 field. (if that is possible offcourse)If not, is there another way to do something like this, because the combination of (patchkasten)and(patchnummer) has to be unique.. And at last a combobox (ruimte) with around ~ 150-200 entries.Now my question is if someone could help me setting this up somehow. Help would be appriciated.Thanks,F3dde
View 1 Replies View RelatedTable Structure
Dec 10, 2004Hello
I have a big MS access database with many tables. Now I want to print out all this tables including there fieldname and the field description.
Does someone know how to do this in VB?
thanks
greetings
Koen
Need Help With Table Structure
Jul 20, 2006i am currently working with a human resource outsourcing company. we deploy contractual employees to different companies.
we usually use ms excel in keeping records of our employees, now my boss wants me to create a database using ms access. this is my first time in creating database using ms access.
here are the headers that we used with our excel database:
- ID number
- Account number
- First name
- Last name
- Middle initial
- Start date with the agency
- Start date with the company
- Status (active, end contract, resigned, terminated)
- Previous contract start
- Previous contract end
- Present contract start
- Present contract end
- Company
- Outlet location
- Position
- Pay class (daily or monthly)
- Basic Rate
- Allowance
- Total Pay
- Home address
- Home tel. no.
- Mobile no.
- Civil status
- Date of birth
- SSN
what i did was divide the headers into several tables for ms access as follows:
1st table (Personal Info)
- ID number
- First name
- Last name
- Middle initial
- Home address
- Home tel. no.
- Mobile no.
- Civil status
- Date of birth
- SSN
2nd table (Company info)
- Company ID
- Company Name
- Company address
- Contact number
- Contact person
3rd table (Position info)
- Position ID
- Start date with the agency
- Start date with the company
- Status (active, end contract, resigned, terminated)
- Previous contract start
- Previous contract end
- Present contract start
- Present contract end
- Pay class (daily or monthly)
- Basic Rate
- Allowance
- Total Pay
4th table (Outlet Info)
- Outlet ID
5th table (Status info)
- Status ID
6th table (Pay class info)
- Pay class ID
7th table (Pay class info)
- Civil status ID
are these correct? please feel free to comment or suggest. i do apologize for the inconvenience. i am just a newbie and i need to finish this project. i appreciate your response. thank you in advance.