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  

Cannot save record.



 
 
Thread Tools Display Modes
  #1  
Old September 6th, 2006, 03:08 AM posted to microsoft.public.access.gettingstarted
James1954
external usenet poster
 
Posts: 10
Default Cannot save record.

I have an autolook up query that automatically fills data in on a form. The
primary key is the phone number. It works fine when I it finds a matching
key. If it doesn't find a matching key and I try to save the record I get the
following message. The Microsoft Jet database engine cannot find a record in
the table name with key matching field(s) name. (Error 3101). I
understand what this is telling me, but is there a way to save a record when
the fields do not match. Is there a way of bypassing this.

Thanks
James1954

 




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 02:30 PM.


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