I cannot enter data into a query in access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim Halpin (BV) - 20 Nov 2005 21:32 GMT

I have set up a query linked to a number of tables. The query has fields
which are the links to the other tables. In some records, not all, i want
somes field to be blank so have used the IsNull function to allow this, but
when i have done this it seems to lock the query and i am unable to enter any
data into the query. Any suggestions, if you need any more if please let me
know

Thanks

Reply to this Message

Duane Hookom - 20 Nov 2005 21:37 GMT

All tables should be linked from primary key fields to foreign key fields.

I don't have a clue how you are using the IsNull function to allow
something. Perhaps you should reply with your SQL view as well as define
which are primary and foreign key fields.

Signature

Duane Hookom
MS Access MVP
--

>I have set up a query linked to a number of tables. The query has fields
> which are the links to the other tables. In some records, not all, i want
[quoted text clipped - 7 lines]
>
> Thanks

Reply to this Message

Chris2 - 20 Nov 2005 23:59 GMT

> I have set up a query linked to a number of tables. The query has fields
> which are the links to the other tables. In some records, not all, i want
[quoted text clipped - 4 lines]
>
> Thanks

Tim Halpin (BV),

Although meant for an sqlserver newsgroup, the
following link is still applicable for MS Access:
http://www.aspfaq.com/etiquette.asp?id=5006, and
is excellent when it comes to detailing how to
provide the information that will best enable
others to answer your questions.

Sincerely,

Chris O.

Reply to this Message

Pat Hartman(MVP) - 21 Nov 2005 05:21 GMT

Sounds like you have used an expression to create a column. Expressions
cannot be updated. The other columns of the query should still be updatable
unless there is some other problem such as the use of an aggregate function
such as Max() or Sum().

>I have set up a query linked to a number of tables. The query has fields
> which are the links to the other tables. In some records, not all, i want
[quoted text clipped - 7 lines]
>
> Thanks

Reply to this Message