can't enter data

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
 
A

Andi Mayer

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
 
T

talib

-----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
 
A

Andi Mayer

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
 
T

talib

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
 
A

Andi Mayer

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
 
L

Lynn Trapp

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...
 
A

Andi Mayer

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
 
A

Andi Mayer

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
 
Top