Prevent Blank Records

[Kevin]

The database I created deals heavily on queries based on its table
information. If I have blank fields in my table it throws so of my
queries off.

How can I force a form I have to make sure that all data is present
before creating a new form?

 

[Kevin]

Let me rephrase that...

How can I force a form I have to make sure that all data is present
before creating a new record?

 

[dbahooker]

on beforeInsert or something if everything is null then cancel = true

or you can just add a couple fields that do not allow nulls; that is
how most people fix this

-Aaron

 

[Rick Brandt]

Let me rephrase that...

How can I force a form I have to make sure that all data is present
before creating a new record?

The best way is to make the fields "Required = Yes" in the design of the table.
If any required fields are left empty the table will not allow the record to be
saved.

 

[Larry Linson]

The best way is to make the fields "Required = Yes" in the design of the
table. If any required fields are left empty the table will not allow the
record to be saved.

But, from a usability point of view, consider whether you really want to
frustrate the user who has _almost_ all the information. You might want to
do a check in BeforeUpdate, and save the partial record to an "incomplete"
table, so the user can later retrieve the data that has already been
entered, or compensate with Criteria in Queries to ignore incomplete
Records.

Larry Linson
Microsoft Access MVP

 

[JK]

And,

In case of a text field:
"Allow Zero Length=No"

Regards/JK

 

[dbahooker]

ROFL

larry that sounds overly complex; maybe if MDB had TRIGGERS then you
wouldn't have to build such elaborate schemas

-Aaron