Date field in form was working fine, then stopped accepting data

[Duane Hookom]

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

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.

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

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;


:

On Thu, 15 Jun 2006 11:06:02 -0700, please help

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

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]