By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,154 Members | 1,031 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,154 IT Pros & Developers. It's quick & easy.

Cannot Add Data

P: n/a
Hi, I have table1 and table2, both are linked, and a query has been
run. I created forms that use both just the tables, and then another
one using just the query. All of the information is there, but I
cannot edit any records nor can I move to a new record on the forms.
I checked to see if they were locked, and they are not.

Please help!

Apr 15 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
do you mean that you can't add/edit data in the form bound to the query,
only? or are you also having that problem in the two forms that are each
bound directly to a table?

if the query-bound form only, suggest you open the query in Datasheet View
and see if you can add/edit records there. if not, then the problem is in
the query design rather than in the form.

if the table-bound forms also cannot be edited, suggest you examine the
AllowEdits, AllowAdditions and RecordsetType properties of each form (there
is no Locked property at the form level). read up on those properties in
Access Help so you'll understand what the different settings do.

hth
<ep********@comcast.netwrote in message
news:11*********************@y80g2000hsf.googlegro ups.com...
Hi, I have table1 and table2, both are linked, and a query has been
run. I created forms that use both just the tables, and then another
one using just the query. All of the information is there, but I
cannot edit any records nor can I move to a new record on the forms.
I checked to see if they were locked, and they are not.

Please help!

Apr 15 '07 #2

P: n/a
I just looked again (btw, I am working with 2 tables, one query, one
form now). I cannot add records in the query. I am sure it is
because of the relationship in which I was unable to make enforce
inferential integrity since I could not indicate TA ID in the main
table as a primary key. In both tables, there is information for a TA
ID which neither are primary keys. I linked them so that the
information would correlate with each entry. (TA ID is a unique
record, however, the TA ID consists of numbers and letters. I tried
many differerent ways to have Access let me make that a primary key in
the main table, but it will not; i.e. formatting, unique indexes,
etc.) In both the query and the form, the information correlated with
each other just fine, I just cannot add new records.

I know I am missing something simple here. Argh! (The TA ID format
cannot be changed)

On Apr 15, 5:30 pm, "tina" <nos...@address.comwrote:
do you mean that you can't add/edit data in the form bound to the query,
only? or are you also having that problem in the two forms that are each
bound directly to a table?

if the query-bound form only, suggest you open the query in Datasheet View
and see if you can add/edit records there. if not, then the problem is in
the query design rather than in the form.

if the table-bound forms also cannot be edited, suggest you examine the
AllowEdits, AllowAdditions and RecordsetType properties of each form (there
is no Locked property at the form level). read up on those properties in
Access Help so you'll understand what the different settings do.

hth

<epearce...@comcast.netwrote in message

news:11*********************@y80g2000hsf.googlegro ups.com...
Hi, I have table1 and table2, both are linked, and a query has been
run. I created forms that use both just the tables, and then another
one using just the query. All of the information is there, but I
cannot edit any records nor can I move to a new record on the forms.
I checked to see if they were locked, and they are not.
Please help!- Hide quoted text -

- Show quoted text -

Apr 17 '07 #3

P: n/a
As you have not explained what TA ID represents, nor the type of Field, nor
anything else about it, it is not possible for us to offer suggestions as to
why you can't set it as the PK.

However, if you _include_ the PK of the Table that you want to update in
your Query, you may have better luck in updating. The Tables do not have to
be Joined on the PK.

"Linked" tables, in Access, are Tables external to your database -- when you
"connect" Tables in a Query, it is known as a "Join".

Larry Linson
Microsoft Access MVP

<ep********@comcast.netwrote in message
news:11**********************@l77g2000hsb.googlegr oups.com...
>I just looked again (btw, I am working with 2 tables, one query, one
form now). I cannot add records in the query. I am sure it is
because of the relationship in which I was unable to make enforce
inferential integrity since I could not indicate TA ID in the main
table as a primary key. In both tables, there is information for a TA
ID which neither are primary keys. I linked them so that the
information would correlate with each entry. (TA ID is a unique
record, however, the TA ID consists of numbers and letters. I tried
many differerent ways to have Access let me make that a primary key in
the main table, but it will not; i.e. formatting, unique indexes,
etc.) In both the query and the form, the information correlated with
each other just fine, I just cannot add new records.

I know I am missing something simple here. Argh! (The TA ID format
cannot be changed)

On Apr 15, 5:30 pm, "tina" <nos...@address.comwrote:
>do you mean that you can't add/edit data in the form bound to the query,
only? or are you also having that problem in the two forms that are each
bound directly to a table?

if the query-bound form only, suggest you open the query in Datasheet
View
and see if you can add/edit records there. if not, then the problem is in
the query design rather than in the form.

if the table-bound forms also cannot be edited, suggest you examine the
AllowEdits, AllowAdditions and RecordsetType properties of each form
(there
is no Locked property at the form level). read up on those properties in
Access Help so you'll understand what the different settings do.

hth

<epearce...@comcast.netwrote in message

news:11*********************@y80g2000hsf.googlegr oups.com...
Hi, I have table1 and table2, both are linked, and a query has been
run. I created forms that use both just the tables, and then another
one using just the query. All of the information is there, but I
cannot edit any records nor can I move to a new record on the forms.
I checked to see if they were locked, and they are not.
Please help!- Hide quoted text -

- Show quoted text -


Apr 17 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.