Split Form is Read-only - How do I change this? 2

[JOEYB99]

I am using Access 2007.

This is the continuation of a posting in the Queries forum called "Using DLOOKUP in a Query".

I have a query that runs properly and now I want to set it up as a Split Form and allow the user to make changes to the data. I used the 'Split Form' wizard(?) in access 2007 while I high-lighted the query and it automatically created a new split form.

But it is read-only. It will not allow changes. Please help.

Any input would be greatly appreciated.

 

[PHV]

What is the SQL code of the RecordSource of the form ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[JOEYB99]

Hi PHV, how are you? Thanks for offering your help...again!


I need to explain a mistake I made in my post. One table is linked, the Rate Master, while the other is internally created. I'm thinking this is my problem and am wondering about changing the linked table to an import table.



SELECT tblTimeMaterialPayrollWorkFile.[Formatted Cost Code], tblTimeMaterialPayrollWorkFile.[Ticket Date (YYYY-MM-DD)], tblTimeMaterialPayrollWorkFile.[Employee Name], tblTimeMaterialPayrollWorkFile.[Employee Class], tblTimeMaterialPayrollWorkFile.[Employee Type], tblTimeMaterialPayrollWorkFile.[Regular Hours], tblTimeMaterialPayrollWorkFile.[Overtime Hours], tblTimeMaterialPayrollWorkFile.[Other Hours], tblTimeMaterialPayrollWorkFile.[Sequence Number], tblTimeMaterialRateMaster.[Regular Rate of Pay] AS [REG Rate], tblTimeMaterialRateMaster.[Overtime Rate of Pay] AS [OVT Rate], tblTimeMaterialRateMaster.[Other Rate of Pay] AS [OTH Rate], ([Regular Hours]*[REG Rate])+([Overtime Hours]*[OVT Rate])+([Other Hours]*[OTH Rate]) AS Extension

FROM tblTimeMaterialPayrollWorkFile INNER JOIN tblTimeMaterialRateMaster ON (tblTimeMaterialPayrollWorkFile.[Job Number] = tblTimeMaterialRateMaster.[Job Number]) AND (tblTimeMaterialPayrollWorkFile.[Employee Class] = tblTimeMaterialRateMaster.[Employee Class]) AND (tblTimeMaterialPayrollWorkFile.[Employee Type] = tblTimeMaterialRateMaster.[Employee Type])

WHERE (((tblTimeMaterialPayrollWorkFile.[Ticket Date (YYYY-MM-DD)]) Between [tblTimeMaterialRateMaster].[Start Date] And [tblTimeMaterialRateMaster].[End Date]));

 

[PHV]

You have a calculated field (Extension) in your query and thus it's not updatable.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[JOEYB99]

Thanks PHV but it is still not working.

I changed the tables to be both imported tables. I removed the calculated field from the query and re-saved it.

Then I deleted the split form and rec-created it from the modified query.

The new split form still tells me that it is not updateable. What is wrong?

 

[PHV]

Add the primary key of each table in your query.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[JOEYB99]

Thanks PHV.

I tries it but no change. The query/form is still not updateable.

Anything else?

 

[missinglinq]

When you say

...it is read-only. It will not allow changes...

are you talking about both components of the Form, i.e. the Datasheet portion and the Single View portion, or just the Datasheet portion?

If both, you might have a look at Allen Browne's

[link

http://allenbrowne.com/ser-61.html

]Why is my query read-only?[/url]

The Missinglinq

Richmond, Virginia

The Devil's in the Details!

 

[JOEYB99]

Thanks Missinglinq, I will definitely check out Allen's web-site.

I have decided to try another approach on this matter.