Validating data entry

validating data entry-48

function Validate Form(ctrl) //-------------------------------------------------------------------------- //This function verifies if the start date is prior to end date.

//-------------------------------------------------------------------------- function check Entered Dates(stdateval,endateval) //-------------------------------------------------------------------------- //This function validates the date for MM/DD/YYYY format.

This blog is started in 2007 and today has 450 articles and tutorials on using excel, making better charts.

This excerpt from "Microsoft Office Access 2007 Forms, Reports, and Queries" introduces several techniques that serve to either make data entry less of a chore, or to reduce or eliminate data entry errors (or both).

First thing to do would be setting up data validation rules in a cell so that your users can specify the type of data they are entering. they can choose card or paypal or other as payment mode and depending on that, enter further details. Just save the file and send it to your customer, vendor or boss.