Creation Of "subtable" ?

Nov 16, 2004

I don't even know how to ask this question! Is it possible to do something like this (dotted line is not part of the data):

DNA Primer Set............Reagents.............Initial....... ........Final

COMBIII.....................Template DNA.........50.....................7
................................PCR Buffer.............10.....................1
................................Nucleotides....... .....10.....................5

I would like to be able to get the the Reagent, Initial, and Final information for each DNA Primer Set without having to create a separate record for each line of information:
COMBIII Template DNA 50 7
COMBIII PCR Buffer 10 1
COMBIII Nucleotides 10 5

Thanks

View Replies


ADVERTISEMENT

How To Make Creation Of A Record In A Table Trigger Creation Of New Table

Jul 17, 2013

I have a table that is a list of all of my events. Each record of events should have a child table that list all of the things that happened at the event. When a new record (event) is added how can I have a new child table created and linked to that record. Also I have a blank table to serve as a template for what each child should look like. How do I make sure this occurs? The child tables can have the same name as the index. I am just using numbers 1- for the index with 1 being the first event and so on?

View 8 Replies View Related

Subtable

Feb 14, 2005

Hi
i have a small access program set up and it all works except one item, there is a sub table that we would like to add in information relating to the order number etc:

order number 1

sub table would have j number 12345

allocation 5

and j number 56789

allocation 25

order number 2 (new record)

could have j number 148

allocation 1

j number 2143213

allocation 12345555

j number 86868

allocation 34

etc



then when you move between each order the information in the table will show the specific information relative to the order number
at the moment when you move from record to record it clears the fields but enters the information into a table

hope this makes some sort of sense

any assistance would be gratefully received

best regards

kev
p.s.if it would i could attach a copy of the database

View 5 Replies View Related

Is Subtable Possible?

Aug 9, 2006

Hi all!!
I've inherited a new db that was created by folks fresh out of school.
I've been looking through it, checking to see how they built it, trying to scope out any neat and nifty new tricks they've used, before something goes wrong and I have to work on it.

They have a table that displays grouped records, and I'm not sure how they did it.

For example:
In the PRODUCTS table, the first record is for [Product Type] "Sticky Stuff", [Product Name] "GooGoo", [Manufacturer] "XYZ Co.", etc, with a + sign in front of the record.
When you expand the record, you get what looks like a sub-table listing all the transactions having to do with "GooGoo".

While trying to figure out how they got this effect, I checked out the Inventory Management sample db that's available on-line. They also have this type of grouped records in a product table.

Is there a simple explanation of how this is done, or do I need to invest some serious study time?

As always, thanks for any guidance you can give me.

Froggiebeckie

View 3 Replies View Related

Subtable

Mar 9, 2008

How do we create a subtable in access. When you open a table. First column come with + singn. When you click the + sign you get another sub table. How do we creat that table. What is the purpose of this table?

regards,
- Mahen

View 5 Replies View Related

Setting Up New Subtable??

Aug 30, 2004

Employee Record table:
Name
Department
etc...

ICU Required Inservices:
Name
Conscious Sedation/Analgesia (Yes/No)
Intraaortic Balloon Pumps (yes/no)
Inservice 3 (Yes/No)
Inservice 4 (Yes/No)

I am trying to build a query or table that will pull all Employees
in the ICU and include the required inservices so that I can
track who has attended and who has not.

This is a huge database I built for the entire hospital.

I need a relationship between the two that won't require me to
have EVERY employee record (all 850 of them) in the related table
so that I can pull just the ICU names.

Any ideas???? thanks!

View 1 Replies View Related

How To Highlight Cell In Subtable

Oct 1, 2012

Ok, there is one main form and a subform which is linked directly to a table. A VBA routine checks entries and flags certain rows for errors. We want to highlight specific cells that are out of tolerance.

Been playing around with the Me.ActiveControl.BackColor = vbYellow

But if this can be done to a particular cell on a table, and if this can be done using VBA.

View 14 Replies View Related

Forms- Subtable Filtering Controls

Apr 28, 2008

Hi,

I'm new to Access and am having trouble designing a database that houses application details.

All applications have a list of unique wrap id's but have different tables housing different details for these wraps.

I have a main table which is for data entry and lets me input whether or not a piece of software is Vista compatible (yes/no) etc.

I also have a field in this table showing which analyst is responsible for researching compatiblity of an application.

I have another table with different regions i.e. london, manchester etc that has the region/city listed as the field heading and then contains a list of wraps used in that city under the relevant field.

My main entry form is linked to the main data entry table that holds specifics for an app, name, vista compatible etc. This form is used for data entry. I want to add a subform on this form which shows a list of all applications, in table format, but I want a drop down list so I can select an analyst name / region so that analysts can update details for a specific area assigned to them. In the table I want all of the records based on this criteria to be displayed.


I guess I need to make a filter button on my subform but do not know how to do this. I put in a button control for apply filter by form but then dont know what to do.

I'm new to access and don't know much VB - e.g. the only thing I can do in VB is a make a message box that says hello world on the screen.

Any help is sincerely appreciated. Apologies for the Essay.

Kind Regards
Bal

View 7 Replies View Related

Queries :: Insert Into Subtable For Each Record In Main Table

Nov 27, 2013

I have a sub table that acts as a revision history for the items in my main table. I've just finished uploading all the records into the main table and now I want to insert one record into the subtable for each record in the main table to start the history with the record creation.

The sub table looks like this:

tblRevisions
- RevID (auto Number / primary Key)
- RevDate (date of revision)
- RevName (Who made the revision)
- RevDesc (What revision was made)
- RevAuthorized (Who authorized the revision)
- RevLabel (Foreign key to the primary table)

The info I want to insert is:

RevID - Auto Number
RevDate - 11/27/2013
RevName - 3
RevDesc - "Added Label to database"
RevAuthorized - 1
RevLabel - (One for each record ID in tblLabels)

I suspect that I want to start with an insert into statement, something along the lines of:

Code:

Insert into tblRevisions (Revdate, RevName, RevDesc, RevAuthorized, RevLabel)
Values ("11/27/2013",3,"Added label to database", 1, ?)

I'm not sure how to indicate that there should be one label for each Record in tblLabels or that revLabel value should match the ID from tblLabels though.

View 6 Replies View Related

Modules & VBA :: Exporting Subtable Records With Primary Records

Jan 12, 2014

All seemed to be working well, however, I noticed that all my subtable records in the database are exporting with each Primary table record. In my output, I'm looking to see each primary table record followed by one or more subtable records from a one to many relationship.

(Office 2010) Access/Word

Private Sub cmdPrint1_Click()
Dim objWord As Word.Application
Dim docm As Word.Document
Dim db As DAO.Database
Dim rstLandSales As DAO.Recordset

[Code] ......

View 14 Replies View Related

Get A Field In Table To Be Populated By Field In Related Subtable

Jun 12, 2015

I'm sub-novice when it comes to Access I'm trying to get calculated data in a field in a sub table to autofill in a field in a related table. So all of the data in 'total hours' column is calculated by the variable inputs in the 'hours' fields. Once there, I want it to feed itself into the 'total hours' field on the main table. Is that possible? Also - the 'total hours' field in the sub table won't calculate anything unless a value is placed in EVERY 'hours' field in the same sub table (e.g. 0).

View 14 Replies View Related

New Table Creation Using SQL

Apr 9, 2008

How would I archive all orders place by customer 'x' in to a new table called tblArchive?

something like:

CREATE INDEX tblArchive ON tblCustomers WHERE customername = "x" ?

View 5 Replies View Related

Counter Creation

Jun 20, 2005

Hi everyone,

Here is my problem:

I Have a form that shows bills in a continuous form. My problem is that I want to put a textbox or a label that will display a kind of counter for each bills. For example, If I have 3 bills to display, I want my label or textbox to display 1 for the first bill, 2 for the second, 3 for the third, and so on.

But I don't know how to do that with a continuous form.

Could someone help me, please...

Thanks in advance!

View 1 Replies View Related

Form Creation Help

May 30, 2006

hi there,

i also need help in my form creation. as you can tell from my post, i am clueless.

anyways, here is what i want to do.

i have an input text as:

title1
name1
address1

these will grow based on how many people information one needs to enter. so say if i have 3 people i should have:
title1
name1
address1

title2
name2
address2

title3
name3
address3

and so on

the thing is i only want to show input text 2, 3, etc when i have several names to enter.

so what i want is, a button, such that when i click on that button, it creates input text 2, 3, based on the number of people i have.

i know how to do this easily with html/javascript, but i MUST do this in ms access, so i hope somebody can help.

TIA
chocho

View 1 Replies View Related

Report Creation

Apr 18, 2005

I am attempting to create a report that the user can specifiy a contact type which is selected from a drop down list and the report will only show those records. The name of the report is "Contact Listing bu User Supplied Contact Type." I also have a form called "Report Contact Selection."
Right now I am getting only contact type of "recruiters" to appear when I run the report even when I select a different contact type. As you will see when you look at the "contacts" table, I do have records with different contact types.
I am including a *.zipped version of this database and if you should need any additional information, please feel free to ask.
Thank you.

View 6 Replies View Related

New Table Creation

Apr 15, 2005

I created a new table for my database that contains three fields. A first name, last name, and a full name field. Is there a way in the definition of the table that I can define the full name to =[TrackComposerFirstName] & " " & [TrackComposerLastName]? I'm not sure where I would define a formula in data elements of a table.

View 10 Replies View Related

Daily Record Creation

Jun 26, 2006

i have a table..

staffdayid
date
timein
timeout
notes


i want to have a feature in my database like the following..

these are basically day to day clock in times for my staff..

is there a way that everday.. a new record will be created..

eg.. on 04/06/06... i turn on my pc for the first time.. and when i view the timesheet form.. a record for today is automatically created.. then throughout the rest of the day, this form will be displayed..

when i turn on my pc on 05/06/06, the database will know its a different day, so it creates a new record for today... then i can just move back and forth throughout the days to see the details..

if i then turn my computer off for 5 days, then turn it on at 10/06/06, it still should have made records for 6,7,8, and 9th June, but they will be empty, and the record im shown is for the 10/06/06,

how can i make this?

View 3 Replies View Related

Log Creation For Editing On A Table

Dec 7, 2005

Hello,

I have created a table containing jobs that need to be done from my team (IT production). Each time someone start or finishes a job, he must fill a box that updates a specific row in the table. I want to log the time of that action.

Any ideas of how I could set this up in Access? I have tried the Now() function in the Default Value of the field End Time, but this is updated everytime I refresh the table

View 5 Replies View Related

Creation Of Two Fields From Parts Of Another

Jul 5, 2006

In a field “NAME” I have “Adam Smith”.
From this field I want in a QBE window (not in VB) to make two new fields “FIRST NAME” “Adam” and “LAST NAME” “Smith”.
In Excel there are the functions FIND and SEARCH with which I take the number of the gap “ ” (5) between Adam and Smith and with the functions LEN, RIGHTS and LEFTS I have a result.
What could I do in Access 2003?

View 3 Replies View Related

Run Query On Record Creation

Aug 9, 2007

I been tasked with a project to be written in access which I am rather unfamiliar with, web design is more my area.

For part of the project I need to copy some pricing fields from a pricing table to a new record at the point that the new record is created. The new record is created when a 'new form' button is clicked.

What I would like to know is what and where I should trigger the copy query from and what function should I be using?

cheers
John

View 1 Replies View Related

Need Help On Join Creation Query

Mar 12, 2008

Hi! Im wondering why my code below Does not work!.... any suggestion???


strStatement = "SELECT SessionData.RunNumber, SessionData.SessionID, SessionData.SequenceNo, SessionData.SubjectID, SessionData.Latency, SessionData.BeamBrk1, SessionData.BeamBrk2, SessionData.BeamBrk3, SessionHeader.SessionDate, SessionHeader.ChamberNo" & _
"SessionHeader.GroupID, SessionHeader.SubjectVariables, SessionHeader.TestDefName FROM SessionData" & _
"INNER JOIN SessionHeader ON SessionData.RunNumber = SessionHeader.RunNumber;"

getQueryname = InputBox("Enter a name for New Query?", "Enter a Label or Name for Query", "Enter Query name/Label Here", 500, 700)

Set qryEmployees = curDatabase.CreateQueryDef("getQueryname", strStatement)

View 4 Replies View Related

Editable Textbox Creation

Jan 16, 2006

I have a continous form bound to a query which also has a group by function. Is it possible to create an editable bounded textbox because Access is giving a message saying recordset not updatable.

View 2 Replies View Related

Rumors Of Creation Stamp?

Sep 7, 2006

I been browsing and I seen a few statement regarding a timestamp that displays when you create a new record so each new record would have the time it was created. What function is this?

View 1 Replies View Related

Creation Of New Record When Tab Last Field

Sep 7, 2011

I have a subform with a lot of fields in which require input. I have set the tab order correctly so they go through in sequence. However, I have found when I tab out of the last field. Its creates a new record which I dont want.I want it to either return to the first field to just stop.

View 2 Replies View Related

Automated Table Creation And Backup

Aug 17, 2005

Hello all,

I need some advice for an ASP.NET web application I am working on. I am trying to automate the making of a new table within a database and then have all records from an old table migrated to the newly made table. I would like this task to run from the scheduled tasks on the server in the way of an .exe

The new table would be created on the first day of every month, taking the name of that month. I was thinking to use an empty template table which already has all the fields, and then making a copy and renaming it to the current month.

After the new table has been created I need to copy all the records from the table that represents the previous month over to the new table that represents the current month.

Any advice would be much appreciated.

Thanks

View 1 Replies View Related

Database Locking During Query Creation - Need Help!!

Oct 13, 2005

why is it that as soon as you fix one problem another one needs dealing with :mad:

OK, the problem i have is that i have a BE/FE configuration database in a multiuser environment. I have built all the tables and the relationships in the BE configuration. In the FE configurations i have built the main forms to input data. It has no come to the point where i have begun to create the queries to allow reporting and data searching. And this is where i have a problem. I am trying to create a simply query and i do mean simple (at the moment i simply want 2 fields from 1 table and 2 fields from another table) no calculations or anything i just want it to display the data. I have tried creating this query numerous times and i keep getting the same error.

"The wizard is unable to open your query in datasheet view, possibly because another user has a source table open in exclusive mode. Your query will be opened in design view"

the above is the error i get when i use a wizard to create the query, after getting this message and going into design view i try to view the results in datasheet view and get the following error "Type Mismatch in expression"

If i dont use a wizard and create it in design view, when i go to view the results i get the second error message everytime.

If i create a query from 1 table only the query works without errors, but i always get errors when i have more than one table in the query.

Also i am the only person with the database open so therefore it is total impossible for the database to be open by another user in exclusive mode.

Anyone know what the problem might be or how to fix. Your answers will be very much appreciated.

View 1 Replies View Related







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