[AccessD] Don't want a required entry

with out knowing more about the application etc I can't say





Message date : Mar 19 2004, 01:38 PM
>From : "Hollis,Virginia" 
To : "'Access Developers discussion and problem solving'" 
Copy to : 
Subject : RE: [AccessD] Don't want a required entry
I set the Allow Zero Length to Yes & it still requires an entry. Do I have
to do this for every table?

-----Original Message-----
From: paul.hartland at fsmail.net [mailto:paul.hartland at fsmail.net]
Sent: Friday, March 19, 2004 7:07 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Don't want a required entry


Virginia,
Allow Zero Length may be your problem, try setting this to Yes.
Paul





Message date : Mar 19 2004, 12:57 PM
>From : "Hollis,Virginia" 
To : "'accessd at databaseadvisors.com'" 
Copy to : 
Subject : [AccessD] Don't want a required entry
What makes a table require an entry? I do not have any of the fields in the
table set to Required. When I set up the tables, I used the Enforce
Referential Integrity - I removed this thinking it was the problem, but it
did not make a difference. For example, when I enter a request, I enter a
requestor, but do not want to enter the name of the buyer because the
requestor will not know who it will be assigned to. It will not let me move
to another record unless I enter the name of the buyer.

Any ideas?

Virginia
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month 
www.freeserve.com/anytime
-- 
_______________________________________________
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
Freeserve AnyTime - HALF PRICE for the first 3 months - Save £7.50 a month 
www.freeserve.com/anytime