[AccessD] matching field error

Charlotte Foust cfoust at infostatsystems.com
Wed Dec 10 10:51:20 CST 2003


Unless it is specifically set to null, a numeric field usually has a
default value of zero.  If you're dealing with numeric keys, this might
be tripping you up.

Charlotte Foust

-----Original Message-----
From: pedro at plex.nl [mailto:pedro at plex.nl] 
Sent: Wednesday, December 10, 2003 3:33 AM
To: AccessD at databaseadvisors.com
Subject: RE: [AccessD] matching field error


Hello Andy,

In the help function i saw what the error means. But it made no sence to
me. You say: "Is there any way they could have zeroes or zero-length
strings rather than nulls". When a field is empty i think there is
nothing in it. How can it be that a field is empty but a zero is
present??

Pedro



 

In antwoord op:

> From: "Andy Lacey" <andy at minstersystems.co.uk>
> To: "'Access Developers discussion and problem solving'"
> Date: Wed, 10 Dec 2003 09:10:22 -0000
> Subject: RE: [AccessD] matching field error
> 
> 
> Pedro
> The implication is that the you have Relationships defined with 
> referential integrity. You are saving a record with a test id which 
> doesn't match to a key value in the tblTest table. The odd thing is 
> that this shouldn't occur if the fields are Null. Is there any way 
> they could have zeroes or zero-length strings rather tha  nulls, 
> because that would do it.
> 
> Andy Lacey
> http://www.minstersystems.co.uk
> 
> > -----Original Message-----
> > From: accessd-bounces at databaseadvisors.com
> > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> > Pedro Janssen
> > Sent: 09 December 2003 22:41
> > To: AccessD at databaseadvisors.com
> > Subject: [AccessD] matching field error
> > 
> > 
> > Hello Group,
> > 
> > i get the following error in a form, when i close it and the
> > field 'PrTestID' is empty:
> > 
> > The microsoft Jet database engine cannot find a record in
> > table 'tblTest' with key matching field(s) 'PrTestID'
> > 
> > 
> > How is this possible, because the field isn't required?
> > Al the ID fields in the form give the same error when they
> > are empty (and all aren't reqiured).
> > 
> > 
> > 
> > Pedro Janssen _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com 
> > http://databaseadvisors.com/mailman/listinfo/a> ccessd
> > Website: 
> > http://www.databaseadvisors.com
> > 
> > 
> > 
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list