Fault Log

Aug 22, 2005

I am creating a database to log faults with a system. I have created a form which allows the user to enter the details of the fault. But I also want to be able to display information about the location of the fault on the same form when a selection is made in the combo box.

For example I have created a combo box which allows the user to select the location of the fault eg. location1 and its address. I then want the text boxes on the form to display information such a telephone number of the location selected in the combo box. This information is taken from a seperate table.

Any help would be great. Thanks

View Replies


ADVERTISEMENT

Need Zero To Show Up In Column If No Fault Totals Exist

Aug 14, 2007

My problem is if there is no FaultTotals nothing shows up. I would still like for the Four Columns to show data and have a 0 in the FaultTotals.

How can I accomplish this?


In a nutshell I am totaling all Cosmetic Faults based on the SystemGroup CTWT and a Date Range. If there are
no Cosmetic CTWT Faults for the DateRange I want a zero. The query works great as long as there is at least
One FaultTotal for the Date Range.


SELECT "1-3" AS Truck, "Cosmetic" AS Category, WorkUnitsFaultsMainTBL.SystemGroup, Count(*) AS FaultTotals
FROM WorkUnitsFaultsMainTBL
WHERE (((WorkUnitsFaultsMainTBL.FaultCategory)="Cosmetic") AND ((WorkUnitsFaultsMainTBL.TodaysDate)
Between [Forms]![Queries_ReportsFRM]![StartDateTxt] And [Forms]![Queries_ReportsFRM]![EndDateTxt]) AND ((WorkUnitsFaultsMainTBL.BuildID) In ("E010","C809","F001","C810","F187","A910","M173","M174")))
GROUP BY WorkUnitsFaultsMainTBL.SystemGroup
HAVING (((WorkUnitsFaultsMainTBL.SystemGroup)="CtWT"))
ORDER BY Count(*) DESC;

View 3 Replies View Related

Intermittent Form Link Criteria Fault

Dec 1, 2006

:mad: and tearing out my hair with this one...
Someone out there please help:

I have a form that should open, linking to the date on another form (that is changeable using a Calendar Control), and display records for that date.

My underlying data is available for a variety of dates but some of the dates (and therefore the records) will not appear when this form opens.

They will all show if the form is opened without the filter. Or they will show in a report.
So I know that the coding is correct.
This intermittent-type thing is really bugging me.

Have even tried re-typing some of the dates in the table in case the format has somhow got changed.

Nothing is working.

View 14 Replies View Related

Then Click One From Listbox Show Fault Info In Textbox

Aug 29, 2006

hi, i have list box and the source coming form Query. i want when i click on
one in list box want it will show [faults] field in textbox from query
the field [faults] is a memo can someone help me
__________________
David

View 3 Replies View Related







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