Can't add new record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sturner333 - 24 Jul 2007 16:38 GMT

I am at a loss. I I don't know what happened but this morning
when I opened up the form I am working with, it didn't allow for new records
and would not let me update the displayed records. I am supplying data to the
form via a query with this SQL:

SELECT divisionBOM.partCost, divisionBOM.Quantity, divisionBOM.id,
divisionBOM.division, divisionBOM.PN, divisionBOM.newBusiness,
divisionBOM.percNewBusiness, divisionBOM.description, [partcost]*[quantity]
AS lineTotal, ([partcost]*[quantity])*([percnewbusiness]/100) AS lineTotal2
FROM divisionBOM
GROUP BY divisionBOM.partCost, divisionBOM.Quantity, divisionBOM.id,
divisionBOM.division, divisionBOM.PN, divisionBOM.newBusiness,
divisionBOM.percNewBusiness, divisionBOM.description;

any help would be greatly appreciated.

Reply to this Message

Carl Rapson - 24 Jul 2007 21:31 GMT

>I am at a loss. I I don't know what happened but this morning
> when I opened up the form I am working with, it didn't allow for new
[quoted text clipped - 15 lines]
>
> any help would be greatly appreciated.

Why do you have the GROUP BY clause? As far as I can see, it serves no
purpose because you aren't using any aggregate functions (SUM, COUNT, etc).
Try removing the GROUP BY clause and see if it works.

Alternately, have the properties of your database file changed (to
read-only, perhaps)?

Carl Rapson

Reply to this Message