Subdatasheet Question

Feb 7, 2005

I have a table for Inventory Items which lists the Item #, Description, Vendor, Pricing, Etc. I also have a table for Inventory Control which lists the quantites in inventory, what was sold and bought, etc. I want to create a subdata sheet in the Inventory Control table, so when you expand it only the information on that item comes up, but when I create the subdatasheet it brings up all the items. How do I create the subdata sheet so only the information I want is shown and not the whole table?

View Replies


ADVERTISEMENT

Print Subdatasheet

Nov 24, 2005

Hi!

I would like to print a table including subdatasheets in Access. However, in Access 2002 it collapses them, and closes the table when I click on Print Preview. (In Access 2000 it works.)
Any ideas?

View 1 Replies View Related

Sum Of Column Of Subdatasheet

Apr 7, 2008

Dear folks,

I have a form, which in it's turn has a subform (datasheettype). Each work with different tables and are related to eachother. Unique key of motherform's table has several occurences in the subform's table.

Enfin, what I now want to do is have a textbox inside my main form displaying the total amount of values of one of the subform's columns. Please advice!

Thanks so much in advance!

View 5 Replies View Related

Applying A Parameter Query To Subdatasheet

May 11, 2007

I want to apply a parameter query to a subdatasheet.

I have a primary query that has a list of all the machines we service, this same query will count the number of service calls within a given date range that the user inputs.
(For the date criteria- Between [Enter Period Start Date] and [Enter Period End Date])

The resulting query datasheet is linked to a subdatasheet from another query that searches all the service calls and links it to the Machine ID.
So when I expand the subdatasheet it shows all the service calls for that machine, beyond the date range.

How can I make it so that the date range from the primary query applies to the subquery?

(without having to re-enter the date range everytime I expand the subdatasheet)

View 1 Replies View Related

Automatically Copy Data Into A Subdatasheet

May 9, 2006

Please forgive me if this has already been explained...but I've searched and searched and haven't found anything like it...

I have a form which contains a command button to open another form which is attached to a subdatasheet in Microsoft Access 2002. When I click on the button to open the sub form, I would like for it to automatically copy the contents of a text box on the original form to a text box on the sub form.

Any help you could offer would be appreciated.

- Taylor

View 2 Replies View Related

Subdatasheet Not Sufficient, Please Give Alternative

Dec 28, 2004

What I am doing, is I have various products with 5 basic fields. I then wanted to add an array of text fields to 2 of those original 5 basic fields. I attempted to do this with a subdatasheet, however, a subdatasheet is not record specific, is not directed to a specific field, and really does not do anything that I want.

Say that the basic field is ProductDescription. I want one column of fields to correlate to it, like below.
ProductDescription
Is blue
Is large
Is heavy
Is strong

Each product will have a different amount of varying descriptor fields. Once understand how to incorporate this with my project, I then will need to understand how to add the subdatasheet to a report easily. Thanks for any help,
-SethTherrien

View 3 Replies View Related

Queries :: How To Make Subdatasheet To Look Like Default One

Jul 2, 2015

Linked field is shown both in Master and child tables, but not in the default subdatasheets made by when a relationship is made between a Master and Child Table.

View 5 Replies View Related

2007 Upgrade - Change Subdatasheet Property??

May 30, 2007

We just upgraded to Office 2007 and are experiencing very slow access performance. This microsoft article addresses the problem:

http://support.microsoft.com/kb/275085

It won't let me change Subdatasheet Name property to [NONE].

Even if I am able to change it, will this affect my table links. I have a lot of them.

I am just the part-time Access "programmer" here and am somewhat lost trying to figure this out. Does anyone have a simple explanation and solution? I would appreciate any help so much!!

View 1 Replies View Related

Forms :: Highlight Duplicates In Form And Subdatasheet

Mar 26, 2014

I have a form which has a subdatasheet attached to it. there could be 1000 records in the main form but only 10O records in the Subdatasheet that match the records in the main form , these are linked by a "product number" .

Is it possible for the row in the main form to be "red" where there is data in the Subdatasheet that is matched by the "product number".

View 5 Replies View Related

Modules & VBA :: Mainform Event - Hidden Column In Subform (Subdatasheet)?

Jul 22, 2014

In open Mainform event

Forms!Mainform.Form!SubForm!controlname.columnhidd en = false doesn't work. Ms Access can't find "subform"

On load and open events in subform doesn't work with columnhidden. (no reaction)

View 7 Replies View Related







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