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 » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Error message when adding a new record



 
 
Thread Tools Display Modes
  #1  
Old May 5th, 2010, 04:19 PM posted to microsoft.public.access.gettingstarted
forest8
external usenet poster
 
Posts: 196
Default Error message when adding a new record

Hi

This is the situation:

In my database, my user has added a record for a new student. When she
pressed save, the following message appeared:

“The record cannot be deleted or changed because table ‘T_Community
Contacts’ includes related records” OK or Help were the only options.

My user checked the Community contacts tab and there was nothing in it.


After that, everything she clicked on brought up that message. When she
tried to close the program, it popped up again. She clicked ok and got the
following message:

“You can’t save this record at this time Microsoft Office Access may have
encountered an error while trying to save a record.

If you close this object now, the data changes you made will be lost.

Do you want to close the database object anyway?”

Yes No


She clicked yes, closed and reopened it. None of the new names were there,
but changes to existing records had been saved.

What does this error mean and how do I fix it?

Thank you in advanced for your help.
  #2  
Old May 5th, 2010, 04:44 PM posted to microsoft.public.access.gettingstarted
Dorian
external usenet poster
 
Posts: 542
Default Error message when adding a new record

The message means exactly what it says. You must have a table relationship
defined and the changes you made to the record must have conflicted with the
defined relationship.
Check what table relationships are defined for those 2 tables.
You will need either to change the relationship or to add some code to your
form to check for that condition and put out a more meaningful message.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"forest8" wrote:

Hi

This is the situation:

In my database, my user has added a record for a new student. When she
pressed save, the following message appeared:

“The record cannot be deleted or changed because table ‘T_Community
Contacts’ includes related records” OK or Help were the only options.

My user checked the Community contacts tab and there was nothing in it.


After that, everything she clicked on brought up that message. When she
tried to close the program, it popped up again. She clicked ok and got the
following message:

“You can’t save this record at this time Microsoft Office Access may have
encountered an error while trying to save a record.

If you close this object now, the data changes you made will be lost.

Do you want to close the database object anyway?”

Yes No


She clicked yes, closed and reopened it. None of the new names were there,
but changes to existing records had been saved.

What does this error mean and how do I fix it?

Thank you in advanced for your help.

  #3  
Old May 5th, 2010, 04:44 PM posted to microsoft.public.access.gettingstarted
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Error message when adding a new record

You have setup some sort of relationship between the student record table and
‘T_Community Contacts’. The entry of a new student record is not satisfying
that relationship.

--
Build a little, test a little.


"forest8" wrote:

Hi

This is the situation:

In my database, my user has added a record for a new student. When she
pressed save, the following message appeared:

“The record cannot be deleted or changed because table ‘T_Community
Contacts’ includes related records” OK or Help were the only options.

My user checked the Community contacts tab and there was nothing in it.


After that, everything she clicked on brought up that message. When she
tried to close the program, it popped up again. She clicked ok and got the
following message:

“You can’t save this record at this time Microsoft Office Access may have
encountered an error while trying to save a record.

If you close this object now, the data changes you made will be lost.

Do you want to close the database object anyway?”

Yes No


She clicked yes, closed and reopened it. None of the new names were there,
but changes to existing records had been saved.

What does this error mean and how do I fix it?

Thank you in advanced for your help.

 




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


All times are GMT +1. The time now is 10:42 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.