If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
Date field in form was working fine, then stopped accepting da
You don't need to edit a report so your existing query will work for that.
Just leave the employee table out of your query that you need to edit. -- Duane Hookom MS Access MVP "please help" wrote in message ... Duane, You get the prize!!!!!!! Taking the employee table out of the query worked. I did do a combo box for employees in my form. However, since I have employeenumber from tbl.employee, when I open the query all info. is there except for the employee name/number. How do I now get the employee name to display with the respective information in the query so that I can create a report. That was why I originally put the employee table in the query because the information regarding the employee does not show up otherwise. "Duane Hookom" wrote: Why are you including tblemployees in this query when it doesn't seem like you have included any fields from the table. Also, is EmployeeName the primary key of tblemployees? I am biting my tongue regarding the un-normalize structure and all the calculations in the query that might better be handled in the form or report. -- Duane Hookom MS Access MVP "please help" wrote in message ... I did open the query as you suggested and the * is grayed out. Just as you said it I can't insert a new record. I did try to compact and repair the database and that did nothing. I did paste the sql from the query below and it is the table.prod.workofdate that seems to be giving me the issue. tblprod.NumberOfEPUEntriesProcessed, IIf([numberof9810epuitems]=0,0,[numberof9810epuitems]/[total epu hours]) AS [EPU Thru Put], tblprod.Total9810ESUMinutes, ([total9810esuminutes]/60) AS [Total ESU Hours], tblprod.NumberOf9810ESUItems, tblprod.NumberOfESUEntriesProcessed, IIf([numberof9810esuitems]=0,0,[numberof9810esuitems]/[total esu hours]) AS [EsU Thru Put], tblprod.TotalOfflineMinutes, ([totalofflineminutes]/60) AS [Total Offline Hours], tblprod.NumberofOfflineItems, tblprod.NumberOfOfflineRejects, tblprod.TotalNumberOfflineEntriesProcessed, IIf([numberofofflineitems]=0,0,[numberofofflineitems]/[total offline hours]) AS [Offline Thru Put], tblprod.NumberOfLookUpMinutes, ([numberoflookupminutes]/60) AS [Total Look-up Hours], IIf([numberoflookupitems]=0,0,[numberoflookupitems]/[total look-up hours]) AS [Look-ups Thru Put], tblprod.TotalCheckStrippingMinutes, ([totalcheckstrippingminutes]/60) AS [Total Check Stripping Hours], tblprod.NumberOfItemsStripped, IIf([numberofitemsstripped]=0,0,[numberofitemsstripped]/[total check stripping hours]) AS [Checkstripping Thru Put], tblprod.TotalNumberofPowerEncodeMinutes, ([totalnumberofpowerencodeminutes]/60) AS [Total Power Encode Hours], tblprod.NumberOfItemsPowerEncoded, IIf([numberofitemspowerencoded]=0,0,[numberofitemspowerencoded]/[total power encode hours]) AS [Power Encode Thru Put], tblprod.TotalMinutesCleaningMachines, ([totalminutescleaningmachines]/60) AS [Total Hours Cleaning Equipment], tblprod.TotalRescanMinutes, ([totalrescanminutes]/60) AS [Total Hours Rescanning], tblprod.NumberOfItemsRescanned, IIf([numberofitemsrescanned]=0,0,[numberofitemsrescanned]/[total hours rescanning]) AS [Rescan Thru Put], tblprod.TotalWorkStagingMinutes, ([totalworkstagingminutes]/60) AS [Total Work Staging Hours], tblprod.TrainingMinutes, ([trainingminutes]/60) AS [Total Training Hours], tblprod.OtherMinutes, ([otherminutes]/60) AS [Total Other Hours], tblprod.Comments, tblprod.GracePeriod, tblprod.TotalCourierEscortMinutes, ([totalcourierescortminutes]/60) AS [Total Courier Escort Hours], tblprod.NumberOfEscorts, IIf([numberofescorts]=0,0,[numberofescorts]/[totalcourierescortminutes]) AS [Average Minutes Per Courier Escort], ([numberofprimepassentriesprocessed]+[numberofrehandleentriesprocessed]*10) AS [Prime & Rehandle Distribution time], ([numberofEPUentriesprocessed]*1) AS [EPU Distribution time], ([numberofesuentriesprocessed]*3) AS [ESU Distribution Time], ([total3890primepassminutes]+[totalrehandleminutes]+[total9810epuminutes]+[total9810esuminutes]+[totalofflineminutes]+[numberoflookupminutes]+[totalcheckstrippingminutes]+[totalnumberofpowerencodeminutes]+[totalminutescleaningmachines]+[totalrescanminutes]+[totalworkstagingminutes]+[trainingminutes]+[otherminutes]+[graceperiod]+[totalcourierescortminutes]+[prime & rehandle distribution time]+[epu distribution time]+[esu distribution time]+[offline distribution time])/60 AS [Hours Productive], ([totalnumberofflineentriesprocessed]*4) AS [Offline Distribution Time], tblprod.NumberOfLookUpItems, tblprod.WorkOfDate FROM tblemployees INNER JOIN tblprod ON tblemployees.EmployeeName = tblprod.EmployeeName; "John Vinson" wrote: On Thu, 15 Jun 2006 11:06:02 -0700, please help wrote: I created a query with several calculations in it. I then created an input form based on that query. The primary key field is work of date. After spending hours creating the form and reports, I went to enter 2 records in the form and it worked. When I went to enter the 3rd record in the form it would not let me type any numbers in the date field. My num-lock is on, all of the properties are set for data entry, nothing has been changed. It just stopped working. Has anyone else had this issue and no how to recover from this problem. I really don't want to start over again. Please help!!!!!!!!!!!!!!!11 "please help" wrote: Please help Try Tools.. Database Utilities... Compact and Repair Database. You might have some uncollected "garbage" sitting around with all the changes you're making. If that doesn't help, please open the Query. Does it have the * "new record" row at the bottom? If not, then the query itself is not updateable. If that's the case, open it in SQL view and post the SQL text here. Indicate which field is giving you the problem. John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Form, Subform, Tab key | 2nd_Stage_User | Using Forms | 17 | August 25th, 2006 12:30 AM |
Form design difficulties | linronamy | New Users | 14 | March 10th, 2006 07:22 PM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |