Search results

Attachment I forgot the Attachment in original post.

I have attached a screenshot of my table relationships. I am attempting to develop a database to 1) Manage Jobs 2) Monitor Production 3) Track Inventory. I believe that the bulk of my design is correct, but I know that I have several problems.... 1. tblJobSetup - Originally, the database was...

Excellent work. I wish I could fully comprehend all the work you did, but unfortunately, my knowledge does not allow me to do so. Anyways...It is CLOSE to working perfect. The DELAYTimePerDelayID Query works perfect. However, the Mechanical query is still slightly off. The mechanical query...

Forgot to attach.

I have included all of the necessary tables/queries. Thanks in advance if you take the time to look it over.

Unfortunately, that code produced the exact same results. I am still only receiving results from ProdIDs during which mechanical delays occured. Hmmm. I have no idea what to do.

SELECT DISTINCTROW DailyProduct.ProdID, Sum(DELAYTimePerDelayID.TotalDelayTime) AS [Sum Of TotalDelayTime] FROM (DailyProduct INNER JOIN DELAYTimePerDelayID ON DailyProduct.ProdID = DELAYTimePerDelayID.ProdID) INNER JOIN (DelayReasons INNER JOIN Delays ON DelayReasons.DelayReasonID =...

I am querying the sum of delay time per job. The query successfully returns these sums, but does not return a value for a job if no delays occured. How do I make the query generate "0" for jobs which contained no delays.

SELECT [JobNum].[JobNum], [JobNum].[Customer], [JobNum].[Project_Lease] FROM JobNum ORDER BY [JobNum]; SELECT [JobSetup].[JobID], [JobSetup].[OD], [JobSetup].[Wall] FROM JobSetup WHERE (((JobSetup.JobNum)=[Forms]![DailyProduct]![JobNum_Combo]));

Combo2 list items are based on the selection made in Combo1. The list displays correct the first time a selection is made in Combo1, but does not update if a new selection is made. Combo1 = JobNum_Combo Combo2 = ODWall_Combo After Update Event Procedure..... Private Sub...

Also posted in the Forms forum....possibly a few more responses and help can be generated here. http://www.access-programmers.co.uk/forums/showthread.php?t=136556

Attached is the database objects that the time problem is dealing with. I would really appreicate it if one of you brilliant access minds could solve the issue. A Job can start and end on different days, and numerous delays can occur within that job. The delays can obviously also start and...

Assumptions: -Multiple Jobs can be peformed in one day (queiries must be able to display all jobs performed on a selected day) -Multiple Delays will occur within each job. Crucial Form Fields: -Date, ProductionStartTime, ProductionEndTime Crucial SubForm Fields (To Enter Production...

OK....One more minor problem.... I select JobNum in Box 1, and then select the Job Details from Box 2. When I attempt to save the data, I get the following error... "You must enter a value in the 'DailyProduct.JobID' Field" The JobID refers to the ID autonumber assigned to every...

You should be an Access Forum Moderator when you grow up. You know a few things. Thanks for the help.

Me.ODWallCombo.Requery "The expression After Update you entered as the event property setting produced the following error: The object doesn't contain the Automation object 'Me.'.

Row Source in 2nd ComboBox... SELECT [JobSetup].[OD], [JobSetup].[Wall] FROM JobSetup WHERE (((JobSetup.JobNum)=[Forms]![DailyProduct]![JobNumCombo])); The JobNum ComboBox works perfect. Once a JobNum is selected, the 2nd ComboBox displays the correct information, however, if a different...

Current Row Source... SELECT DISTINCT [JobSetup].[JOBNum], [JobSetup].[Customer], [JobSetup].[Project_Lease] FROM JobSetup ORDER BY [JobNum]; Only Customer and Project_Lease are showing up in the ComboBox. JobNum needs to be included also...unduplicated.

JobSetup Table contains the following columns.... JobID (Primary Key, Autonumber), JobNum, SubCode, Customer, Project_Lease, JobDetails *The database will contain many duplicate Job Numbers(all with the same Customer/Project_Lease), but the JobDetails within the JobNumbers will ALWAYS be...