Server? I want to make it so each new record has to be accepted before the data is added to each field in the new record. Is making it a required field enough? Or do you have to do batch transaction processing (which requires SQL Server?) I appreciate any help from you databasers out there. Thank you.
2007-01-10 10:30:04 · 2 answers · asked by careyabbott 1 in Computers & Internet ➔ Programming & Design
You can set the REQUIRED property of EACH FIELD OBJECT in the TABLE DESIGN window to TRUE. If you do that, no record can be saved without being completely filled out first.
2007-01-10 10:52:03 · answer #1 · answered by Richard H 7 · 0⤊ 0⤋
You can use as many required fields as necessary to constitute a whole record, or if you're comfortable with Visual Basic, you can put code in the BeforeUpdate event to validate data and if not valid, you can cancel the save.
2007-01-10 10:46:45 · answer #2 · answered by MamaBean 3 · 0⤊ 0⤋