Is it possible to pull information out of a subdata sheet to simplify a query or report? I am currently running a query based on 2 tables, however this produces multiple instances of the same info. If possible it would be much more beneficial to collect all info from the main table but I have not been able to find any info on how to access/reference the subdatasheet. Is there a way to do this or is this much more complicated than it sounds?
View RepliesHi all!
I want to insert a subdatasheet into a table but I only want certain records of the subdatasheet to be viewable/accessible e.g. Record 1 of my table should be related to records 1-5 of the subdatasheet. Is this even possible? Or worth doing for that matter!
Thanks in advance! You've all been really helpful in previous crises/head-scratching moments! :D
Hello,
I'm sorry if this has been already discussed but I've been searching without result.
I have a table "A", with table "B" in it as a subdatasheet.
Now when i insert a new row into "A", i need a new copy of the table "B" to be created, meaning every row in "A" would have it's private copy of "B". Is there a way to do this? I don't insist on subdatasheet solution, i just need a new copy of B to be created and linked to any new record in A.
Any suggestions?
I wondering if it's possible to have more than one subdatasheet for one table. My table relations are as follows:
tbl1: Offices
col1: ID (autonumber)
col2: Office (text)
tbl2: Sections
col1: ID (autonumber)
col2: Section (text)
col3: Parent_Office (number) (relation to [Offices].[ID])
tbl3: Staff
col1: ID (autonumber)
col2: Name (text)
col3: Parent_Office (number) (relation to [Offices].[ID])
col4: Parent_Section (number) (relation to [Sections].[ID])
As you can see the "Staff" table has two relations. One to the "Offices" table, and one to the "Sections" table. I'm trying this because this company has some employees under an office, and some employees under a section under an office. And in the end was hoping to be able to look at the "Offices" table, then expand an office to show both contacts related to that office, as well as sections related to that office.
Is this possible? Or am I beating a dead horse?
Help is much appreciated.
Liam.
Hi once again!
I am trying to see if it would be possible to realize this design:
I have a table with 20 records (equipment names) and each one of them as a unique serial number and a lot of other fields;
Somehow I need to create a subdatasheet for each one of those records! This subdatasheet will contain pin to pin connections informations (lots of records maybe 70) for the cables attached to the equipment !
Example:
TabEquipment_Names
eqp1
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
eqp2
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
eqp3
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
|__frompin || topin || signal || modified...
As you can understand each equipment has a proprietary cable with specific pin to pin connections so I CANNOT create a single subdatasheet for the whole TabEquipment_Names table, but I would need to specifically create a table for each record in the Equipment_Names table, isn`t that correct?
Is there any way to do this?
Thank you.
e.
Hi, all! I need some help. I am trying to figure out how to enable the subdatasheet in my subform. I've already told the root query to include the subdatasheet, and it works. My subform only allows datasheet view, and I've enabled the subdatasheet visible property in the subform. What am I missing? I really need it to show up. It would be SO cool if it would work. Thanks!
KellyJo
I have a continuous form with a bound subform in the footer section. Is there a way (with VBA?) to set the tab order so that it tabs down to the subform in the footer after a few controls in the main form and then back to the main form after going through the subform?
Also I have a form with a subform in datasheet view. Can I have the tab order set so that it tabs through a few fields in the datasheet view, expands the subdatasheet and allows you to tab through it, then tab back to the main datasheet?
I want users to fill out a few fields in the main form, go the subform easily, enter the data there, then go back to the main form easily and enter the rest of the data before going to the next record in the main form.
I have a main table and multiple other tables that I want to link to each row of the main table.The main table "Data" consists of columns (Name, x, y) where "Name" is the primary key and all values are unique.Each of the other tables have columns (Name2, z) where the value of "Name2" is the same in each row and also corresponds to the table name.
I want to make each table a subdatasheet of "Data" where each row in "Data" shows the values in the table corresponding to its name. (i.e. where Name = Name2).Below is what I have so far, but the code doesn't work because linkchildfields and linkmasterfields need to be run from a subform.(?)
The error I am getting is 'Property Not Found' once the code reached the linkchildfields line.
Quote:
Sub STS()
Dim i As TableDef
Dim db As Database
Dim tbl As TableDef
Set db = CurrentDb()
Set tbl = db.TableDefs("Data")
[code]....
I have a table for all my members, then a table for each class (for attendance purposes) and the class tables are linked to the master via subdatasheets. I also have a form that pulls up all the details of a member and I want to show all the times they've attended class. Is it possible to add the subdata sheets to the form or would I have to add the attendance record as a subform that filters on the person?
View 1 Replies View Related