If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cannot Insert New Records
Access 2002 - I suddenly cannot add new records into a table via a form. I
was able to add records a few days ago and don't recall changing anything on the form since then. Here's the scenario: I click the "New Record" button on the record navigator bar. A blank form appears. I begin filling in the fields and I get the little pencil icon that indicates edit mode. When I finish entering data, I click Save Record from the Records menu, but nothing happens and the edit mode pencil remains. The word "calculating" sometimes appears in the status bar (but that's normal). I also cannot use the record navigator buttons to move to another record. There's a ton of code associated with this form. If someone can help, I'd like to email the code rather than post it here. Thanks in advance! --Dorci |
#2
|
|||
|
|||
Cannot Insert New Records
Nevermind, I figured it out! I wasn't entering a REQUIRED field. Now all I
have to do is figure out why I'm not getting an error message indicating such. Anyway, thanks for listening. "Dorci" wrote: Access 2002 - I suddenly cannot add new records into a table via a form. I was able to add records a few days ago and don't recall changing anything on the form since then. Here's the scenario: I click the "New Record" button on the record navigator bar. A blank form appears. I begin filling in the fields and I get the little pencil icon that indicates edit mode. When I finish entering data, I click Save Record from the Records menu, but nothing happens and the edit mode pencil remains. The word "calculating" sometimes appears in the status bar (but that's normal). I also cannot use the record navigator buttons to move to another record. There's a ton of code associated with this form. If someone can help, I'd like to email the code rather than post it here. Thanks in advance! --Dorci |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
selecting multiple records | sps | Using Forms | 3 | August 3rd, 2004 08:22 PM |
append Query duplicating records | Alex | Running & Setting Up Queries | 1 | July 8th, 2004 01:31 PM |
Query combining multiple records from one table can't add records | Clint Marshall | Running & Setting Up Queries | 4 | July 8th, 2004 01:25 PM |
Copying new records | John | General Discussion | 0 | June 25th, 2004 04:02 PM |
How to Manipulate the group and sorting in a report? | Jorge Novoa | Using Forms | 2 | June 9th, 2004 01:12 AM |