Can't add data to Query/Form

R

Robbie Doo

I don't know why my query doesn't accept new data anymore. Here's the SQL:

SELECT Main_NA.ReviewNo, Main_NA.SampleMonth, Main_NA.[Case Name],
Main_NA.[Case Number], Main_NA.Districts, Main_NA.Unit, Main_NA.File,
Main_NA.Auditor, Main_NA.[Review Date], Main_NA.Term_Action_Correct,
Main_NA.[Reviewer Comment], [NA DisagLvlTbl].Agency_Comment, [NA
DisagLvlTbl].MIE_Response, [NA DisagLvlTbl].RevBy, [NA DisagLvlTbl].RevDt,
[NA DisagLvlTbl].DueDt
FROM Main_NA LEFT JOIN [NA DisagLvlTbl] ON Main_NA.ReviewNo = [NA
DisagLvlTbl].ReviewNo
ORDER BY Main_NA.ReviewNo;

If you need more info let me know. Thanx.
 
J

Jeff Boyce

The implication is that it DID use to accept new data... or was that an
earlier form of the query?

If your query includes more than one table, does Access "know" enough to
resolve which table gets updated? Check Access HELP about updateable
queries...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
R

Robbie Doo

Hi Jeff;

I guess whenever they do some kind of an update to the system some of the
features don't function properly or stop altogether.

This query used to take data now I cannot add anything. I looked everywhere,
including similar tables that feed other forms.

The only difference is the relationship here is "Indeterminate (External)"
whereas the others have "One-to-many (External)".

Jeff Boyce said:
The implication is that it DID use to accept new data... or was that an
earlier form of the query?

If your query includes more than one table, does Access "know" enough to
resolve which table gets updated? Check Access HELP about updateable
queries...

Regards

Jeff Boyce
Microsoft Office/Access MVP



Robbie Doo said:
I don't know why my query doesn't accept new data anymore. Here's the SQL:

SELECT Main_NA.ReviewNo, Main_NA.SampleMonth, Main_NA.[Case Name],
Main_NA.[Case Number], Main_NA.Districts, Main_NA.Unit, Main_NA.File,
Main_NA.Auditor, Main_NA.[Review Date], Main_NA.Term_Action_Correct,
Main_NA.[Reviewer Comment], [NA DisagLvlTbl].Agency_Comment, [NA
DisagLvlTbl].MIE_Response, [NA DisagLvlTbl].RevBy, [NA DisagLvlTbl].RevDt,
[NA DisagLvlTbl].DueDt
FROM Main_NA LEFT JOIN [NA DisagLvlTbl] ON Main_NA.ReviewNo = [NA
DisagLvlTbl].ReviewNo
ORDER BY Main_NA.ReviewNo;

If you need more info let me know. Thanx.
Click to expand...
Click to expand...
 
J

Jeff Boyce

Did you check Access HELP on "updateable query"?

Did you check Access HELP on 'Indeterminate"?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Robbie Doo said:
Hi Jeff;

I guess whenever they do some kind of an update to the system some of the
features don't function properly or stop altogether.

This query used to take data now I cannot add anything. I looked
everywhere,
including similar tables that feed other forms.

The only difference is the relationship here is "Indeterminate (External)"
whereas the others have "One-to-many (External)".

Jeff Boyce said:
The implication is that it DID use to accept new data... or was that an
earlier form of the query?

If your query includes more than one table, does Access "know" enough to
resolve which table gets updated? Check Access HELP about updateable
queries...

Regards

Jeff Boyce
Microsoft Office/Access MVP



Robbie Doo said:
I don't know why my query doesn't accept new data anymore. Here's the
SQL:

SELECT Main_NA.ReviewNo, Main_NA.SampleMonth, Main_NA.[Case Name],
Main_NA.[Case Number], Main_NA.Districts, Main_NA.Unit, Main_NA.File,
Main_NA.Auditor, Main_NA.[Review Date], Main_NA.Term_Action_Correct,
Main_NA.[Reviewer Comment], [NA DisagLvlTbl].Agency_Comment, [NA
DisagLvlTbl].MIE_Response, [NA DisagLvlTbl].RevBy, [NA
DisagLvlTbl].RevDt,
[NA DisagLvlTbl].DueDt
FROM Main_NA LEFT JOIN [NA DisagLvlTbl] ON Main_NA.ReviewNo = [NA
DisagLvlTbl].ReviewNo
ORDER BY Main_NA.ReviewNo;

If you need more info let me know. Thanx.
Click to expand...
Click to expand...
Click to expand...
 
R

Robbie Doo

Hi Jeff;

I found out that the primary key was removed from the main table. When I put
it back it worked alright.

Thank you for all the help.

Jeff Boyce said:
Did you check Access HELP on "updateable query"?

Did you check Access HELP on 'Indeterminate"?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Robbie Doo said:
Hi Jeff;

I guess whenever they do some kind of an update to the system some of the
features don't function properly or stop altogether.

This query used to take data now I cannot add anything. I looked
everywhere,
including similar tables that feed other forms.

The only difference is the relationship here is "Indeterminate (External)"
whereas the others have "One-to-many (External)".

Jeff Boyce said:
The implication is that it DID use to accept new data... or was that an
earlier form of the query?

If your query includes more than one table, does Access "know" enough to
resolve which table gets updated? Check Access HELP about updateable
queries...

Regards

Jeff Boyce
Microsoft Office/Access MVP



I don't know why my query doesn't accept new data anymore. Here's the
SQL:

SELECT Main_NA.ReviewNo, Main_NA.SampleMonth, Main_NA.[Case Name],
Main_NA.[Case Number], Main_NA.Districts, Main_NA.Unit, Main_NA.File,
Main_NA.Auditor, Main_NA.[Review Date], Main_NA.Term_Action_Correct,
Main_NA.[Reviewer Comment], [NA DisagLvlTbl].Agency_Comment, [NA
DisagLvlTbl].MIE_Response, [NA DisagLvlTbl].RevBy, [NA
DisagLvlTbl].RevDt,
[NA DisagLvlTbl].DueDt
FROM Main_NA LEFT JOIN [NA DisagLvlTbl] ON Main_NA.ReviewNo = [NA
DisagLvlTbl].ReviewNo
ORDER BY Main_NA.ReviewNo;

If you need more info let me know. Thanx.
Click to expand...
Click to expand...
Click to expand...
 
Top