Validating Missing Data by Responding to Data Entry Events

Author: databasedev.co.uk | Published: 20th Jan 2006 | Visited: 289 times | Add Comment
Filed in: MS Access

Validating Missing Data by Responding to Data Entry Events: We can use various techniques for validating data being entered into our database, as seen in the Validating Data in Microsoft Access article, however sometimes our validation routines can be overly restrictive. There may be occasions where we need to be more flexible in our approach, and we may just want to warn the users of the database that data is missing when they are entering a record into the form. When we are entering the data, it is possible to respond the the data entry event, and use a Microsoft Access MsgBox function to perform different actions depending on what the database user wants to do.

Read Article

Sponsored Links

• Swing Extreme Testing - The Data Validation Test The Data Validation Test The Ok button of the SaveAsDialog should only be enabled if the name that has been entered is valid. A name can be invalid if it contains an illegal character, or if it has already been use ...

• Retrieving XML Data Retrieving XML DataTo retrieve XML data from an XMLType table, you can use a SELECT SQL statement, just as you would if you had to query a relational table. For example, to select the employee with the id set to 100 from the employees XMLType table discussed in the preceding section, you might issue ...

• Querying Data with Oracle XQuery Querying Data with Oracle XQuery Starting with Oracle Database 10g Release 2, you can take advantage of a full-featured native XQuery engine integrated with the database. With Oracle XQuery, you can accomplish various tasks involved in developing PHP/Oracle XML applications, operating on any kind of ...

• Breaking up XML into Relational Data Breaking up XML into Relational Data While the preceding example shows how to construct an XML representation over relational data, the example in this section illustrates how you can shred XML data back into relational data. This reverse operation can be useful if your application works with relati ...

• Accessing and Updating Data in ASP.NET 2.0: Using Optimistic Concurrency Because multiple users can visit the same web page concurrently, it is possible for a user visiting a data modification page to inadvertently overwrite the modifications made by another user. Consider a page with an editable GridView. If two users visit this page simultaneously from different compu ...

• Moving Toward WPF Data Binding One Step at a Time A gradual introduction to the world of WPF data bin ...

• Speed Dial for Internet - Fancy Delphi Application Contest Entry #29 in FDAC :: The Opera browser has a feature called Speed Dial which is basically a grid of your 9 (or more) favorite web sites presented using thumbnails instead o ...

• Self Validating TextBox A self populating and self validating textbox control with business object aware ...

• Create Secure Java Applications Productively, Part 1: Use Rational Application Developer and Data St... This is the first in a two-part tutorial series creating secure Java-based Web applications using Rational Application Developer, Data Studio and Rational AppScan. This first tutorial begins by showcasing how Data Studio with pureQuery can increase the efficiency of your database-driven Web developm ...

• Read committed--Why transaction can read uncommitted data Hello Tom Thanks for your time.. I have a question: I understand that by default Oracle uses read committed by statement level, normally other session can't see the modification execept the session that makes the modification itself. Read c ...

Next: Previewing a Microsoft Access report sized using acCmdZoom