473,883 Members | 1,666 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Form, subform, sub-sub form?

Let' say we have an application for a production facility running 24/7
broken into 3 shifts 6-2,2-10,10-6

each production report date contains 3 shifts as above

in each shift there can be from one to several different product runs (the
average is about 4) but it could be more or less - it's not defined or
definite for many reasons

Then, for each run there is a production report of product, good pieces,
bad pieces total run time for that product etc. etc.

then for each run there is a list for # of rejects and reject code

SO I have ProductionRuns with rejects subform 1 to many but this results in
repeated entries of shift, date, time. So i could make a main table for
these and have the production run as a subform to this, but then I have a
subform to the prodution run form.

This gets confusing and requires me to put buttons for starting new date or
shift. Any better way of doing this?

Nov 12 '05 #1
2 2954
Without knowing the structure of your data, it would seem to me that you
would have a form with production run as the record... with a selection of
Date and Shift in the Form Header. Within that production run, same-level
but separate subforms for regular production information and reject
information.

Using Combo or List Boxes in the header to select date and shift, then
replacing the RecordSource with an SQL statement using date and shift as
criteria would limit the production runs to that particular date/shift. Or,
if you'd rather, use a calendar control to select the date.

If there's something about your data so this doesn't seem logical, follow up
with clarification. I may not see it, but surely someone will have a
suggestion.

Larry Linson
Microsoft Access MVP

"Claude" <Cl***********@ quickpic.net> wrote in message
news:KySic.3279 5$aQ6.1714744@a ttbi_s51...
Let' say we have an application for a production facility running 24/7
broken into 3 shifts 6-2,2-10,10-6

each production report date contains 3 shifts as above

in each shift there can be from one to several different product runs (the
average is about 4) but it could be more or less - it's not defined or
definite for many reasons

Then, for each run there is a production report of product, good pieces,
bad pieces total run time for that product etc. etc.

then for each run there is a list for # of rejects and reject code

SO I have ProductionRuns with rejects subform 1 to many but this results in repeated entries of shift, date, time. So i could make a main table for
these and have the production run as a subform to this, but then I have a
subform to the prodution run form.

This gets confusing and requires me to put buttons for starting new date or shift. Any better way of doing this?

Nov 12 '05 #2
Hi Claude,

I'd try one main form, and have 4 (or more) *cascading* subforms on it.
These subforms *could* be on seperate pages of a tab control if nessecary.

Main form ("frmProduction Date") has the production date info.(ShiftDate ,
Plant, etc)
First subform: "sbfShifts" -- (ShiftDate, ShiftNumber, StartTime, EndTime,
etc)
Second subform: "sbfProductionR uns" (ShiftNumber, RunNumber, StartRun,
EndRun, etc.)
Third subform: "sbfProduct s" (RunNumber, ProductNumber, ProductDescript ion)
Fourth subform: "sbfProductResu lts" (ProductNumber,
UnitsProduced,U nitsRejected, RejectCode, etc)

Each form or subform above should be bound to it's own table, with
one-to-many links defined.
Use an unbound textbox to retreive the unique ID for each subform, then use
that textbox as the LinkMaster for the subform (hierachly) below it.

i.e. "txtShiftNumber " textbox control with
"=Me![sbfShifts].Form![ShiftNumber]" as it's control source, which is then
used as the Link Master, and "ShiftNumbe r" as the LinkChild for the
"sbfProductionR uns" subform. Repeat this procedure as nessecary for the rest
of the subforms.

If this is all set up correctly:
1.) Choosing a date on the main form will display a list of shifts for that
day in "sbfShifts" , with the record pointer on the first of 3 records
2.) sbfProductionRu ns will display ALL the runs that occured during the
selected shift. Selecting a different shift in sbfShifts will cause
sbfProductionRu ns to show Production runs for that shift....
3.) ...and so on, and so on for each of the subforms beneath, in a cascading
fashion.
4.) These suforms can be used for viewing AND for entering new data, which
make this approach quite flexible.
5.) Data can be summarized at each subform level... summed, counted,
percentages calculated, etc. This can be done by inserting calculated
controls in each of the subforms form footers, then referencing those form
footer controls from other controls on the main form.

Other considerations:
Is it possible that there may be several RejectCodes for the same product,
during the same production run?
If so you may need another subform, and even a way to identify
(sequentiallly) each item that came off the production line.

Clear as mud, right? :)

--
HTH,
Don
=============== ==============
Use My*****@Telus.N et for e-mail
Disclaimer:
Professional PartsPerson
Amateur Database Programmer {:o)

I'm an Access97 user, so all posted code
samples are also Access97- based
unless otherwise noted.

Do Until SinksIn = True
File/Save, <slam fingers in desk drawer>
Loop

=============== =============== ==
"Claude" <Cl***********@ quickpic.net> wrote in message
news:KySic.3279 5$aQ6.1714744@a ttbi_s51...
Let' say we have an application for a production facility running 24/7
broken into 3 shifts 6-2,2-10,10-6

each production report date contains 3 shifts as above

in each shift there can be from one to several different product runs (the
average is about 4) but it could be more or less - it's not defined or
definite for many reasons

Then, for each run there is a production report of product, good pieces,
bad pieces total run time for that product etc. etc.

then for each run there is a list for # of rejects and reject code

SO I have ProductionRuns with rejects subform 1 to many but this results in repeated entries of shift, date, time. So i could make a main table for
these and have the production run as a subform to this, but then I have a
subform to the prodution run form.

This gets confusing and requires me to put buttons for starting new date or shift. Any better way of doing this?

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1544
by: Deano | last post by:
If I create 2 or more records in my subform and I then delete the main record, then all the controls on my subform disappear. Yet if there is only one record in the subform then it gets deleted ok and the controls are still there ready to await further input. Further info; Cascading Deletes are on. The subform Cycle property is set to Current Record.
4
2495
by: Deano | last post by:
If I create 2 or more records in my subform and I then delete the main record, then all the controls on my subform disappear. Yet if there is only one record in the subform then it gets deleted ok and the controls are still there ready to await further input. Further info; Cascading Deletes are on. The subform Cycle property is set to Current Record.
8
2442
by: PeteCresswell | last post by:
I'm looking for some code that makes a list presented in a subform autoscroll in response to the user typing - like a combo box dropdown or a regular ListBox does. I.e. The user is looking at subform that is a list of, say, 2,000 people's names. The first name is "Aardvark, John", and the last name is "Zero, James". Instead of scrolling, the user types "S" and is jumped to "Sammons". Then, on the next keystroke as they type "m", it...
1
1631
by: (Pete Cresswell) | last post by:
I'm using a subform as a navigation list. On the left side of the screen is a subform containing people's names. The right side of the screen is loaded with information about the currently-selected person. As the user walks the list, the right side of the screen gets reloaded with info about each new name. When the user decides to change something, they click an "Edit" button that puts
2
1696
by: manning_news | last post by:
Using A2K. I've got a database with client info and each client has a subform which contains types of income and the amount they each receive. The record source of the subform is a cartesian product of the client ID and the types of income of which there is currently 16 types. So every client has 16 records. What I'd like to do is to allow the user to modify a type from any client's subform and the changes affect all clients. So if...
9
24629
by: robert d via AccessMonster.com | last post by:
I'm not sure why the following isn't working. The subform loads correctly, but no data is displayed. I'm certain that there is data and I have checked that the SQL statement does in fact return that data (checked by pasting the statement into a new Access Query in the database window). Me.FutureSubform.SourceObject = "FutureProjectionSubForm" Me.FutureSubform.Form.RecordSource = "SELECT * FROM " Me.FutureSubform.Form.Requery Is...
1
3076
by: planetthoughtful | last post by:
Hi All, I have a mainform with a subform in which I show some task summary data. On the mainform I have a number of unbound controls that reflect values relevant to each task in the subform. The unbound controls are populated in the subform's OnCurrent even from a number of different tables related to the records in tbl_tasks, which is the recordset displayed in the subform.
10
2854
by: rdemyan via AccessMonster.com | last post by:
I have a subform that displays around 10 fields. Most of the values shown result from some complex calculations. To make it easy, I have stored the results in a temporary table and then all I need to do is set the recordsource of the subform equal to the table. However, it would be very nice if the last row in the subform showed the totals of the previous rows (of course where applicable). If it were a listbox (that didn't require...
2
1736
by: John | last post by:
I have a mainform with a subform. The subform is sorted on a specific field and when I just open the subform, the sorting is OK. However, when I open the mainform, the sorting in the subform is gone. The subform has no data link to the mainform. How can I persist my sorting in the subform? Thanks in advance, john
5
3025
by: John Torres | last post by:
I am trying to link second subform base on the 1st subform. I’ve read several threads and it’s just look too complicated for me (sorry I’m a newbie). I want to link shipping information (2nd subform) to Due Date(1st Subform) – where each due date on the first subform may have several qty shipments in second subform. Access dbase/ Vista OS. Please help. Thanks. John
0
11142
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10743
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10847
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9574
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
7129
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5797
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4612
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4220
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3233
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.