can't enter data

  • Thread starter Thread starter talib
  • Start date Start date
T

talib

Hello Access Nation

I have created a form for entering data. The record
source is a query that consists of two tables. When I
run the query it returns all the records in the tables.
When I attempt to enter data in the form I can't. I can
see the value in the filed that have dropdown boxes but I
can't select anything nor can I enter any data. Any and
all help is always appreciated. Happy Holidays
 
Hello Access Nation

I have created a form for entering data. The record
source is a query that consists of two tables. When I
run the query it returns all the records in the tables.
When I attempt to enter data in the form I can't. I can
see the value in the filed that have dropdown boxes but I
can't select anything nor can I enter any data. Any and
all help is always appreciated. Happy Holidays
Click to expand...

you have a read-only query

check it in the query-view if you can update it there (or look if you
can add records)

But without seeing the Query we can't help (hopefully)
If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW
 
-----Original Message-----


you have a read-only query

check it in the query-view if you can update it there (or look if you
can add records)

But without seeing the Query we can't help (hopefully)
If you expect an answer to a personal mail, add the
Click to expand...
word "manfred" to the first 10 lines in the message
MW
.
Hi Andi. I can't update in the query-view. How can I
Click to expand...
change it from a read only query? Thanks
 
change it from a read only query? Thanks
Click to expand...

you have to change the query, sometimes it helps, but without seeing
the query I or any other can't help you

Go to the SQL-View in Query-Design and show us the whole string.
If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW
 
Ok, here the string

SELECT qryUpdate.*, [qry12-21-04Milestones].*
FROM qryUpdate LEFT JOIN [qry12-21-04Milestones] ON
qryUpdate.RecordNumber = [qry12-21-
04Milestones].MRecordNo;

The following is qry12-21-04Milestones:

SELECT tblTasc.*, tblMilestones.*
FROM tblTasc LEFT JOIN tblMilestones ON
tblTasc.RecordNumber = tblMilestones.MRecordNo;

Next is qryUpdate

SELECT tblTasc.RecordNumber, tblTasc.TSystemId
FROM tblTasc;

Thanks
-----Original Message-----


you have to change the query, sometimes it helps, but without seeing
the query I or any other can't help you

Go to the SQL-View in Query-Design and show us the whole string.
If you expect an answer to a personal mail, add the
Click to expand...
word "manfred" to the first 10 lines in the message
 
Ok, here the string

SELECT tblTasc.RecordNumber, tblTasc.TSystemId, tblMilestones.*
FROM tblTasc LEFT JOIN tblMilestones ON
tblTasc.RecordNumber =tblMilestones.MRecordNo;

The following is qry12-21-04Milestones:

SELECT tblTasc.*, tblMilestones.*
FROM tblTasc LEFT JOIN tblMilestones ON
tblTasc.RecordNumber = tblMilestones.MRecordNo;

Next is qryUpdate

SELECT tblTasc.RecordNumber, tblTasc.TSystemId
FROM tblTasc;

Thanks

word "manfred" to the first 10 lines in the message
Click to expand...

If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW
 
The problem is that Access has no idea which table you plan to update. You
might find that qry12-21-04Milestones is updatable, although I have no way
of knowing for sure. However, as you add table on table on query on query
the likelihood of it being updatable grows less and less. Take a look at the
following KB article for some information on updatable queries:

http://support.microsoft.com/default.aspx?scid=kb;en-us;328828

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


talib said:
Ok, here the string

SELECT qryUpdate.*, [qry12-21-04Milestones].*
FROM qryUpdate LEFT JOIN [qry12-21-04Milestones] ON
qryUpdate.RecordNumber = [qry12-21-
04Milestones].MRecordNo;

The following is qry12-21-04Milestones:

SELECT tblTasc.*, tblMilestones.*
FROM tblTasc LEFT JOIN tblMilestones ON
tblTasc.RecordNumber = tblMilestones.MRecordNo;

Next is qryUpdate

SELECT tblTasc.RecordNumber, tblTasc.TSystemId
FROM tblTasc;

Thanks
-----Original Message-----



you have to change the query, sometimes it helps, but without seeing
the query I or any other can't help you

Go to the SQL-View in Query-Design and show us the whole string.
If you expect an answer to a personal mail, add the
Click to expand...
word "manfred" to the first 10 lines in the message
MW
.
Click to expand...
Click to expand...
 
forget this, i pressed the wrong button
If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW
 
On Wed, 22 Dec 2004 09:58:39 -0800, "talib"


lets do it step by step:
is qry12-21-04Milestones updatable?

lets do the 2 Step at the same time:
leave qryUpdate out:

SELECT tblTasc.RecordNumber, tblTasc.TSystemId,
[qry12-21-04Milestones].*
FROM tblTasc LEFT JOIN [qry12-21-04Milestones] ON
tblTasc.RecordNumber = [qry12-21-
04Milestones].MRecordNo;

which table has the "master" RecordNumber?
Ok, here the string

SELECT qryUpdate.*, [qry12-21-04Milestones].*
FROM qryUpdate LEFT JOIN [qry12-21-04Milestones] ON
qryUpdate.RecordNumber = [qry12-21-
04Milestones].MRecordNo;

The following is qry12-21-04Milestones:

SELECT tblTasc.*, tblMilestones.*
FROM tblTasc LEFT JOIN tblMilestones ON
tblTasc.RecordNumber = tblMilestones.MRecordNo;

Next is qryUpdate

SELECT tblTasc.RecordNumber, tblTasc.TSystemId
FROM tblTasc;

Thanks
Click to expand...

If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW
 
Back
Top