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

Access 2002 won't create new record

P: n/a
Environment; Win2K PC with 1Gb of RAM and plenty of HD space running Access
2002

Issue; Access presents a blank data entry form in the Forms view when the
New Record icon is used. However, it won't allow any fields to have data
entered into them. I can edit & save existing records without problem.
When I go into the Tables view, I can add records and data ok and save
without problem. I go back into the Table and I can see the data. However,
the data entry/display Form can't find the new record or the new data. No
err msgs...it just isn't there in the Form view when doing a Sort/Display or
a Search/Any Part. For added interest, I can see the new record # in the
Table view but the Form view insists there's no such record number. I did a
Compact & Repair on all tables, no change.

Suggestions, anyone?
Jul 8 '08 #1
Share this Question
Share on Google+
12 Replies


P: n/a
>it won't allow any fields to have data entered into them.

Do you mean that you can't physically enter data into a textbox?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

Jul 8 '08 #2

P: n/a
that's correct. I get a blank data entry Form, and can tab btwn the
different fields, but it won't allow me to enter anything in any of the
fields.

"Linq Adams via AccessMonster.com" <u28780@uwewrote in message
news:86dcb6119fcfe@uwe...
it won't allow any fields to have data entered into them.

Do you mean that you can't physically enter data into a textbox?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

Jul 8 '08 #3

P: n/a
tekctrl wrote:
that's correct. I get a blank data entry Form, and can tab btwn the
different fields, but it won't allow me to enter anything in any of the
fields.
You mentioned you can change data in the table but not the form. Are
you using a recordsource that is a query and not a table? Open up the
form's property sheet, then the recordsource, and run it. Can you add a
record there?
>
"Linq Adams via AccessMonster.com" <u28780@uwewrote in message
news:86dcb6119fcfe@uwe...
>>>it won't allow any fields to have data entered into them.

Do you mean that you can't physically enter data into a textbox?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com


Jul 9 '08 #4

P: n/a
Yes, the Recordsource points to the correct table.
Yes, I can add a record directly to that table.
No, the new record does not appear in the Form which points to that table
even after doing a sort and/or search. It is, however, still present in the
Table itself.

"Salad" <oi*@vinegar.comwrote in message
news:y7******************************@earthlink.co m...
tekctrl wrote:
that's correct. I get a blank data entry Form, and can tab btwn the
different fields, but it won't allow me to enter anything in any of the
fields.

You mentioned you can change data in the table but not the form. Are
you using a recordsource that is a query and not a table? Open up the
form's property sheet, then the recordsource, and run it. Can you add a
record there?

"Linq Adams via AccessMonster.com" <u28780@uwewrote in message
news:86dcb6119fcfe@uwe...
>>it won't allow any fields to have data entered into them.

Do you mean that you can't physically enter data into a textbox?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com

Jul 9 '08 #5

P: n/a
tekctrl wrote:
Yes, the Recordsource points to the correct table.
Yes, I can add a record directly to that table.
No, the new record does not appear in the Form which points to that table
even after doing a sort and/or search. It is, however, still present in the
Table itself.
Is the recordsource a table or a query?

In the form's property sheet, under data tab, is AllowAdditions or
AllowEdits set to false?

>
"Salad" <oi*@vinegar.comwrote in message
news:y7******************************@earthlink.co m...
>>tekctrl wrote:

>>>that's correct. I get a blank data entry Form, and can tab btwn the
different fields, but it won't allow me to enter anything in any of the
fields.

You mentioned you can change data in the table but not the form. Are
you using a recordsource that is a query and not a table? Open up the
form's property sheet, then the recordsource, and run it. Can you add a
record there?

>>>"Linq Adams via AccessMonster.com" <u28780@uwewrote in message
news:86dcb6119fcfe@uwe...
>it won't allow any fields to have data entered into them.

Do you mean that you can't physically enter data into a textbox?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com


Jul 9 '08 #6

P: n/a
Recordsource is a table

"Salad" <oi*@vinegar.comwrote in message
news:8M******************************@earthlink.co m...
tekctrl wrote:
Yes, the Recordsource points to the correct table.
Yes, I can add a record directly to that table.
No, the new record does not appear in the Form which points to that
table
even after doing a sort and/or search. It is, however, still present in
the
Table itself.

Is the recordsource a table or a query?

In the form's property sheet, under data tab, is AllowAdditions or
AllowEdits set to false?


"Salad" <oi*@vinegar.comwrote in message
news:y7******************************@earthlink.co m...
>tekctrl wrote:
that's correct. I get a blank data entry Form, and can tab btwn the
different fields, but it won't allow me to enter anything in any of the
fields.

You mentioned you can change data in the table but not the form. Are
you using a recordsource that is a query and not a table? Open up the
form's property sheet, then the recordsource, and run it. Can you add a
record there?
"Linq Adams via AccessMonster.com" <u28780@uwewrote in message
news:86dcb6119fcfe@uwe...
it won't allow any fields to have data entered into them.

Do you mean that you can't physically enter data into a textbox?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via http://www.accessmonster.com


Jul 9 '08 #7

P: n/a
tekctrl wrote:
Recordsource is a table
I would then get to the database window and click Forms/New/FormWizard,
select your table, and march thru the wizard's forms. Then see if it
works. If it does, you are doing something incorrect on your current
form either in code or by property settings.

The Passenger
http://www.youtube.com/watch?v=h0i6zkXSjlI
>
"Salad" <oi*@vinegar.comwrote in message
news:8M******************************@earthlink.co m...
>>tekctrl wrote:

>>>Yes, the Recordsource points to the correct table.
Yes, I can add a record directly to that table.
No, the new record does not appear in the Form which points to that

table
>>>even after doing a sort and/or search. It is, however, still present in

the
>>>Table itself.

Is the recordsource a table or a query?

In the form's property sheet, under data tab, is AllowAdditions or
AllowEdits set to false?
>>>"Salad" <oi*@vinegar.comwrote in message
news:y7******************************@earthlink .com...
tekctrl wrote:

>that's correct. I get a blank data entry Form, and can tab btwn the
>different fields, but it won't allow me to enter anything in any of the
>fields.

You mentioned you can change data in the table but not the form. Are
you using a recordsource that is a query and not a table? Open up the
form's property sheet, then the recordsource, and run it. Can you add a
record there?

>"Linq Adams via AccessMonster.com" <u28780@uwewrote in message
>news:86dcb6119fcfe@uwe...
>
>
>
>>>it won't allow any fields to have data entered into them.
>>
>>Do you mean that you can't physically enter data into a textbox?
>>
>>--
>>There's ALWAYS more than one way to skin a cat!
>>
>>Answers/posts based on Access 2000/2003
>>
>>Message posted via http://www.accessmonster.com
>>
>
>
>

Jul 9 '08 #8

P: n/a
I deleted the old Form and rebuilt it again using the wizard, no change. I
can edit & save existing records in the Form, I can open a New Record using
the Create New Record icon, and I can tab from field to field, I just can't
enter any data in the fields or save the new record.

Has anyone ever seen this kind of behavior from Access 2002?

"Salad" <oi*@vinegar.comwrote in message
news:KM******************************@earthlink.co m...
tekctrl wrote:
Recordsource is a table

I would then get to the database window and click Forms/New/FormWizard,
select your table, and march thru the wizard's forms. Then see if it
works. If it does, you are doing something incorrect on your current
form either in code or by property settings.

The Passenger
http://www.youtube.com/watch?v=h0i6zkXSjlI

"Salad" <oi*@vinegar.comwrote in message
news:8M******************************@earthlink.co m...
>tekctrl wrote:
Yes, the Recordsource points to the correct table.
Yes, I can add a record directly to that table.
No, the new record does not appear in the Form which points to that
table
>>even after doing a sort and/or search. It is, however, still present
in

the
>>Table itself.

Is the recordsource a table or a query?

In the form's property sheet, under data tab, is AllowAdditions or
AllowEdits set to false?

"Salad" <oi*@vinegar.comwrote in message
news:y7******************************@earthlink. com...
tekctrl wrote:

that's correct. I get a blank data entry Form, and can tab btwn the
different fields, but it won't allow me to enter anything in any of
the
>>>>fields.

You mentioned you can change data in the table but not the form. Are
you using a recordsource that is a query and not a table? Open up the
form's property sheet, then the recordsource, and run it. Can you add
a
>>>record there?

"Linq Adams via AccessMonster.com" <u28780@uwewrote in message
news:86dcb6119fcfe@uwe...

>>it won't allow any fields to have data entered into them.
>
>Do you mean that you can't physically enter data into a textbox?
>
>--
>There's ALWAYS more than one way to skin a cat!
>
>Answers/posts based on Access 2000/2003
>
>Message posted via http://www.accessmonster.com
>


Jul 9 '08 #9

P: n/a
tekctrl wrote:
I deleted the old Form and rebuilt it again using the wizard, no change. I
can edit & save existing records in the Form, I can open a New Record using
the Create New Record icon, and I can tab from field to field, I just can't
enter any data in the fields or save the new record.
What is the "Create New Record" icon? The inverted Triangle-*?

What happens if you create a table; Junk, and add 3 fields F1, F2, and
F3. If you build a form for it can you add records? IOW, is this
problem specific to all tables or just this one table?

One other question...are you a newbie or have you been working with
Access for awhile. Don't take this the wrong way but I have no idea if
you know what you are doing. I have no idea if you are attempting other
tests. Same with if you know what a table vs a query is. Or if you a
familiar with property sheets and pulling up a property sheet for a form
and a control.
Has anyone ever seen this kind of behavior from Access 2002?
No. It's possible you own a defective copy of Access.
>
"Salad" <oi*@vinegar.comwrote in message
news:KM******************************@earthlink.co m...
>>tekctrl wrote:

>>>Recordsource is a table

I would then get to the database window and click Forms/New/FormWizard,
select your table, and march thru the wizard's forms. Then see if it
works. If it does, you are doing something incorrect on your current
form either in code or by property settings.

The Passenger
http://www.youtube.com/watch?v=h0i6zkXSjlI

>>>"Salad" <oi*@vinegar.comwrote in message
news:8M******************************@earthlink .com...
tekctrl wrote:

>Yes, the Recordsource points to the correct table.
>Yes, I can add a record directly to that table.
>No, the new record does not appear in the Form which points to that

table
>even after doing a sort and/or search. It is, however, still present

in
>>>the
>Table itself.

Is the recordsource a table or a query?

In the form's property sheet, under data tab, is AllowAdditions or
AllowEdits set to false?


>"Salad" <oi*@vinegar.comwrote in message
>news:y7******************************@earthli nk.com...
>
>
>
>>tekctrl wrote:
>>
>>
>>
>>
>>>that's correct. I get a blank data entry Form, and can tab btwn the
>>>different fields, but it won't allow me to enter anything in any of

the
>>>>>>>fields.
>>
>>You mentioned you can change data in the table but not the form. Are
>>you using a recordsource that is a query and not a table? Open up the
>>form's property sheet, then the recordsource, and run it. Can you add

a
>>>>>>record there?
>>
>>
>>
>>
>>>"Linq Adams via AccessMonster.com" <u28780@uwewrote in message
>>>news:86dcb6119fcfe@uwe...
>>>
>>>
>>>
>>>
>>>>>it won't allow any fields to have data entered into them.
>>>>
>>>>Do you mean that you can't physically enter data into a textbox?
>>>>
>>>>--
>>>>There's ALWAYS more than one way to skin a cat!
>>>>
>>>>Answers/posts based on Access 2000/2003
>>>>
>>>>Message posted via http://www.accessmonster.com
>>>>
>>>
>>>
>>>

Jul 9 '08 #10

P: n/a
Seen something vaguely similar in AK2

Deleted a record on a form, record count went down by 1, then did a "Show
all records" and there it was back again

It deleted perfectly well from the Recordsource query.

Created a new DB and imported everything into it and problem was solved.

Phil

"tekctrl" <te*****@earthlink.netwrote in message
news:r8****************@newsfe06.lga...
>I deleted the old Form and rebuilt it again using the wizard, no change. I
can edit & save existing records in the Form, I can open a New Record
using
the Create New Record icon, and I can tab from field to field, I just
can't
enter any data in the fields or save the new record.

Has anyone ever seen this kind of behavior from Access 2002?

"Salad" <oi*@vinegar.comwrote in message
news:KM******************************@earthlink.co m...
>tekctrl wrote:
Recordsource is a table

I would then get to the database window and click Forms/New/FormWizard,
select your table, and march thru the wizard's forms. Then see if it
works. If it does, you are doing something incorrect on your current
form either in code or by property settings.

The Passenger
http://www.youtube.com/watch?v=h0i6zkXSjlI
>
"Salad" <oi*@vinegar.comwrote in message
news:8M******************************@earthlink.co m...

tekctrl wrote:
Yes, the Recordsource points to the correct table.
Yes, I can add a record directly to that table.
No, the new record does not appear in the Form which points to that

table

even after doing a sort and/or search. It is, however, still present
in
>
the

Table itself.

Is the recordsource a table or a query?

In the form's property sheet, under data tab, is AllowAdditions or
AllowEdits set to false?

"Salad" <oi*@vinegar.comwrote in message
news:y7******************************@earthlink .com...
tekctrl wrote:

>that's correct. I get a blank data entry Form, and can tab btwn the
>different fields, but it won't allow me to enter anything in any of
the
>>>>>fields.

You mentioned you can change data in the table but not the form. Are
you using a recordsource that is a query and not a table? Open up
the
form's property sheet, then the recordsource, and run it. Can you
add
a
>>>>record there?

>"Linq Adams via AccessMonster.com" <u28780@uwewrote in message
>news:86dcb6119fcfe@uwe...
>
>
>
>>>it won't allow any fields to have data entered into them.
>>
>>Do you mean that you can't physically enter data into a textbox?
>>
>>--
>>There's ALWAYS more than one way to skin a cat!
>>
>>Answers/posts based on Access 2000/2003
>>
>>Message posted via http://www.accessmonster.com
>>
>
>
>


Jul 9 '08 #11

P: n/a
The Create New Record icon that I'm using is >* in the Access toolbar.

I'm pretty much of a newbie to Access, so I don't always know what I'm
doing. However, I'm not a stranger to database concepts and functions, I
just haven't had occasion to do anything with it 'til now.

As you suggested, I created a test table and associated Form and it works
perfectly. Evidently the issue is with the Form itself and not the
underlying Tables. That's a good idea and I thank you! I think it's time
to blow away the existing Form (again) and make a new one.

"Salad" <oi*@vinegar.comwrote in message
news:J5******************************@earthlink.co m...
tekctrl wrote:
I deleted the old Form and rebuilt it again using the wizard, no change.
I
can edit & save existing records in the Form, I can open a New Record
using
the Create New Record icon, and I can tab from field to field, I just
can't
enter any data in the fields or save the new record.

What is the "Create New Record" icon? The inverted Triangle-*?

What happens if you create a table; Junk, and add 3 fields F1, F2, and
F3. If you build a form for it can you add records? IOW, is this
problem specific to all tables or just this one table?

One other question...are you a newbie or have you been working with
Access for awhile. Don't take this the wrong way but I have no idea if
you know what you are doing. I have no idea if you are attempting other
tests. Same with if you know what a table vs a query is. Or if you a
familiar with property sheets and pulling up a property sheet for a form
and a control.
Has anyone ever seen this kind of behavior from Access 2002?

No. It's possible you own a defective copy of Access.

"Salad" <oi*@vinegar.comwrote in message
news:KM******************************@earthlink.co m...
>tekctrl wrote:
Recordsource is a table

I would then get to the database window and click Forms/New/FormWizard,
select your table, and march thru the wizard's forms. Then see if it
works. If it does, you are doing something incorrect on your current
form either in code or by property settings.

The Passenger
http://www.youtube.com/watch?v=h0i6zkXSjlI
"Salad" <oi*@vinegar.comwrote in message
news:8M******************************@earthlink. com...
tekctrl wrote:

Yes, the Recordsource points to the correct table.
Yes, I can add a record directly to that table.
No, the new record does not appear in the Form which points to that

table
even after doing a sort and/or search. It is, however, still present
in
>>the
Table itself.

Is the recordsource a table or a query?

In the form's property sheet, under data tab, is AllowAdditions or
AllowEdits set to false?


"Salad" <oi*@vinegar.comwrote in message
news:y7******************************@earthlin k.com...

>tekctrl wrote:
>
>
>
>
>>that's correct. I get a blank data entry Form, and can tab btwn
the
>>>>>>different fields, but it won't allow me to enter anything in any of
the
>>>>>>fields.
>
>You mentioned you can change data in the table but not the form.
Are
>>>>>you using a recordsource that is a query and not a table? Open up
the
>>>>>form's property sheet, then the recordsource, and run it. Can you
add

a
>>>>>record there?
>
>
>
>
>>"Linq Adams via AccessMonster.com" <u28780@uwewrote in message
>>news:86dcb6119fcfe@uwe...
>>
>>
>>
>>
>>>>it won't allow any fields to have data entered into them.
>>>
>>>Do you mean that you can't physically enter data into a textbox?
>>>
>>>--
>>>There's ALWAYS more than one way to skin a cat!
>>>
>>>Answers/posts based on Access 2000/2003
>>>
>>>Message posted via http://www.accessmonster.com
>>>
>>
>>
>>

Jul 12 '08 #12

P: n/a
tekctrl wrote:
The Create New Record icon that I'm using is >* in the Access toolbar.

I'm pretty much of a newbie to Access, so I don't always know what I'm
doing. However, I'm not a stranger to database concepts and functions, I
just haven't had occasion to do anything with it 'til now.

As you suggested, I created a test table and associated Form and it works
perfectly. Evidently the issue is with the Form itself and not the
underlying Tables. That's a good idea and I thank you! I think it's time
to blow away the existing Form (again) and make a new one.
You mentioned in a prior post that you had deleted the old form and
created a new one via the wizard and it didn't work. As one other
person suggested you could create a new database and import all the
objects to it...it's possible the table is corrupted. Good luck
"Salad" <oi*@vinegar.comwrote in message
news:J5******************************@earthlink.co m...
>>tekctrl wrote:

>>>I deleted the old Form and rebuilt it again using the wizard, no change.

I
>>>can edit & save existing records in the Form, I can open a New Record

using
>>>the Create New Record icon, and I can tab from field to field, I just

can't
>>>enter any data in the fields or save the new record.

What is the "Create New Record" icon? The inverted Triangle-*?

What happens if you create a table; Junk, and add 3 fields F1, F2, and
F3. If you build a form for it can you add records? IOW, is this
problem specific to all tables or just this one table?

One other question...are you a newbie or have you been working with
Access for awhile. Don't take this the wrong way but I have no idea if
you know what you are doing. I have no idea if you are attempting other
tests. Same with if you know what a table vs a query is. Or if you a
familiar with property sheets and pulling up a property sheet for a form
and a control.

>>>Has anyone ever seen this kind of behavior from Access 2002?

No. It's possible you own a defective copy of Access.

>>>"Salad" <oi*@vinegar.comwrote in message
news:KM******************************@earthlink .com...
tekctrl wrote:

>Recordsource is a table

I would then get to the database window and click Forms/New/FormWizard,
select your table, and march thru the wizard's forms. Then see if it
works. If it does, you are doing something incorrect on your current
form either in code or by property settings.

The Passenger
http://www.youtube.com/watch?v=h0i6zkXSjlI

>"Salad" <oi*@vinegar.comwrote in message
>news:8M******************************@earthli nk.com...
>
>
>
>>tekctrl wrote:
>>
>>
>>
>>
>>>Yes, the Recordsource points to the correct table.
>>>Yes, I can add a record directly to that table.
>>>No, the new record does not appear in the Form which points to that
>
>table
>
>
>
>>>even after doing a sort and/or search. It is, however, still present

in
>the
>
>
>
>>>Table itself.
>>
>>Is the recordsource a table or a query?
>>
>>In the form's property sheet, under data tab, is AllowAdditions or
>>AllowEdits set to false?
>>
>>
>>
>>
>>
>>>"Salad" <oi*@vinegar.comwrote in message
>>>news:y7******************************@earth link.com...
>>>
>>>
>>>
>>>
>>>>tekctrl wrote:
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>that's correct. I get a blank data entry Form, and can tab btwn

the
>>>>>>>>>different fields, but it won't allow me to enter anything in any of

the
>>>>>fields.
>>>>
>>>>You mentioned you can change data in the table but not the form.

Are
>>>>>>>>you using a recordsource that is a query and not a table? Open up

the
>>>>>>>>form's property sheet, then the recordsource, and run it. Can you

add
>>>a
>>>>record there?
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>"Linq Adams via AccessMonster.com" <u28780@uwewrote in message
>>>>>news:86dcb6119fcfe@uwe...
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>>it won't allow any fields to have data entered into them.
>>>>>>
>>>>>>Do you mean that you can't physically enter data into a textbox?
>>>>>>
>>>>>>--
>>>>>>There's ALWAYS more than one way to skin a cat!
>>>>>>
>>>>>>Answers/posts based on Access 2000/2003
>>>>>>
>>>>>>Message posted via http://www.accessmonster.com
>>>>>>
>>>>>
>>>>>
>>>>>

Jul 12 '08 #13

This discussion thread is closed

Replies have been disabled for this discussion.