A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Cannot Insert New Records



 
 
Thread Tools Display Modes
  #1  
Old August 12th, 2004, 05:21 PM
Dorci
external usenet poster
 
Posts: n/a
Default 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  
Old August 12th, 2004, 06:31 PM
Dorci
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 06:49 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.