INSERT NEW RECORD not working on query

R

Robert

hI use a command button for INSERT NEW RECORD on a form. We are up to record
203 and now, all of a sudden, we can not add any more records. I can add
records in the actual table which feeds the query which feeds the form.
But the query nor the form allow me to INSERT NEW RECORDs.
What must I do? Frustrated?!!!
 
L

Larry Daugherty

Hi Robert,

You didn't give us much to go on about which version of Access you're using,
where your application is used, how many users, etc.

When things that did work suddenly don't, it usually means that something
has changed or that some threshold has been crossed ...

In the table Tab of the Database window, select the table on which the query
and form are based. Click the AutoForm Wizard icon and step through with
the wizard designing a new data entry form. Give your new form a name.
Open it and see if you can add records. If not, post back. If you can, you
know that your problem is in your original form, possibly in the query. You
already pretty well knew that. Now you can tweak your new form, in small
increments, to look like your original form. Try adding records after every
change or two.

HTH
 
R

Robert

Hi Larry, I am using ACCESS 2002.
I used a backup copy of the DB, with a new name so data would not be messed
up, exported from my OVERTIME DATA table in to the OVERTIME DATA Table of the
backup DB, then tried to enter data in the backup db form and again we had
the same problem.

I have looked at the properties of the table and see nothing that stops the
creation of a new record. Matter of fact, I can enter new records manually
by opening the table. However, as you know, we don't want the average
application user getting back here. I then looked at the query that uses the
TABLE as its source. Opened the Query and noticed that the INSERT RECORD is
not available.
Have any ideas where the problem is?

Robert
 
D

Dirk Goldgar

Robert said:
Hi Larry, I am using ACCESS 2002.
I used a backup copy of the DB, with a new name so data would not be
messed up, exported from my OVERTIME DATA table in to the OVERTIME
DATA Table of the backup DB, then tried to enter data in the backup
db form and again we had the same problem.

I have looked at the properties of the table and see nothing that
stops the creation of a new record. Matter of fact, I can enter new
records manually by opening the table. However, as you know, we
don't want the average application user getting back here. I then
looked at the query that uses the TABLE as its source. Opened the
Query and noticed that the INSERT RECORD is not available.
Have any ideas where the problem is?
Click to expand...

I suggest you post the SQL view of the query.
 
R

Robert

Mr. Daugherty, I wrote you an email thanking you for your assistance.
Deleting the original form and re-creating via the wizard provided the fix.
However, I am still not sure what caused the problem still. I DO KNOW how to
repair it if it should every happen again, but not how to prevent it in the
first place.
Still, all in all, thank you very much.

I hope I may assist you in the future as well,
Robert Tait
 
D

Dirk Goldgar

Robert said:
Mr. Daugherty, I wrote you an email thanking you for your assistance.
Deleting the original form and re-creating via the wizard provided
the fix. However, I am still not sure what caused the problem still.
I DO KNOW how to repair it if it should every happen again, but not
how to prevent it in the first place.
Still, all in all, thank you very much.
Click to expand...

I'm puzzled. You wrote that the query was also not updatable. Did
deleting and recreating the form fix this? Was the query you refer to a
SQL statement in the form's recordsource property, so when you recreated
the form you built a new query, too?
 
Top