Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Keep track of worksheet changes with Excel's shared worksheet feature
- However, you need to beware …This all sounds great in this age of accountability and auditability, however the user needs to be very careful – all is not as it appears. Once tracking is enabled, no charts, images, controls (such as handy drop-downs), hyperlinks or pivot tables can be...
- Tags: sarah.seddon@..., compliance, spreadsheet, change control, version control, hardware, Microsoft Excel
- Discussion threads 2006-09-13
- Implementing Validation Rules Using Aspects
- This paper provides an overview of AOP-based data validation implementation in a sample loan processing application. The paper will look at validation rules for data fields with different validation requirements, which is common in most real-world applications. Annotations-based aspects using AspectJ are used to dynamically weave validation rules into existing...
- Tags: Validation Rule
- White papers 2005-11-08
- XP ACCESS - dates
- in a data/time field setup for shortdate with an input mask - if I type 13/05/05 ACCESS returns 05/05/2013- obviously there is no 13th month - I thought that by using the Date/Time function - ACCESS would automatically verify for date accuracy - what do I need to do now,...
- Tags: Ckbtwy, Microsoft Windows XP, software
- Discussion threads 2005-01-12
- Ensure accurate data entry in Excel by using Data Validation to create drop-down lists
- You don't have to know how to program in Visual Basic to create drop-down lists and validate entries in an Excel spreadsheet. The Data Validation feature makes it easy to eliminate data entry errors.You could write a book about all the ways you can use Excel’s Data Validation feature. Like...
- Tags: PRODUCTIVITY, Microsoft Excel, Jeff Davis, Data Validation, data entry, cell, validation rule
- Technical articles 2000-04-27
Additional Resources
- Add data validation to an Access form
- All is not lost if you didn't set data validation for a field during table design. See how you can add data validation to an Access form in four simple steps. Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel,...
- Tags: Microsoft Access, Microsoft Office, Mary Ann Richardson, Gender field, Microsoft Office Suite Access Tips Newsletter, TechRepublic Inc., Field, Data Validation, Databases, Office Suites, Software, Enterprise Software, Data Management
- Technical articles 2005-03-22
- Excel 97 - Copying controls to multiple locations
- I am working on a new form in Excel 97. I am including a drop down box that has 4 items. I would like to have the control in approx. 180 rows. I would like to be able to copy the control to all 180 rows at the same time....
- Tags: Microsoft Excel, Microsoft Office, Data Validation
- Discussion threads 2005-12-30
- simple question
- hai,in struts form validation,we do two ways.1.writing the code in ActionForm class2.or using the validator-rule.xml and validation.xml file.give the simple eg.Ok, what is the question?sorry, are you asking anything or giving solution..?
- Tags: velubalu_in@...
- Discussion threads 2005-03-17
- Use Access table validation rules to protect data integrity
- When the validity of data in one field depends on what's entered in another field, you'll want to build a validation rule. Here's a step-by-step look at the process. by Mary Ann Richardson
- Tags: Microsoft Access, Field, Microsoft Office, Databases, Office Suites, Software, Enterprise Software, Data Management, Mary Ann Richardson
- Blog posts 2008-07-22
- Database Validation - MS Access
- Hi there, im building a database in access at the moment, im having difficulty with validation rules they are mandatory for this DB ive made an "appointment" table, within it there is a field called "Appointment_Date/Time", what i need is a rule that will allow a date from in 9am...
- Tags: Instant messaging, Databases, Microsoft Corp., stonemethod@..., database, Microsoft Access
- Discussion threads 2007-06-04
- WebWork Validation
- OpenSymphony's WebWork is a web application framework designed to keep productivity high and the code simple. It has gained popularity for several reasons, including its integration with Spring, a powerful tag library, and OGNL support. Its powerful validation framework is borrowed from another OpenSymphony project, XWork. This paper will explore...
- Tags: Sun Microsystems Inc., Web Application, Framework, OpenSymphony
- White papers 2006-01-19
- XML Validation and XPath Evaluation in J2SE 5.0
- Some of the exciting new features of the Java 2 Platform, Standard Edition (J2SE) 5.0 release, code-named Tiger, are the added XML validation package at javax.xml.validation and the XPath libraries at javax.xml.xpath. Before the Tiger release, the Java API for XML Processing JAXP SAXParser or DocumentBuilder classes were the primary...
- Tags: J2SE, XPath, XML, Java, Software/Web Development, Web Development, Programming Languages, Software Development
- White papers 2005-09-08
- Question on Frontpage form field validation
- In Frontpage 2000, when designing a form, we can have several fields, such as Textbox; and for each field, in form field property, we can set up a validation rule, for example, data value greater than 100. Now I hope to validate the data value of field "p1" equal to...
- Tags: validation, Microsoft FrontPage, Value at Risk, data value, hunter_jn_cn@..., software
- Q&A 2004-10-20
- Thawte commits to High Assurance/Extended Validation/Enhanced Validation SSL
- High Assurance/Extended Validation/Enhanced Validation SSL will deliver an acknowledged industry standard for the highest level of online identity assurance processes for SSL certificate issuance. This will be reflected in most popular internet browsers, such as Microsoft's Internet Explorer 7, which launched in 2006.
- Tags: Thawte, SSL, Ssl/Tls, Authentication/Encryption, Network Security, Security, Networking
- White papers
- Excel Data Validation
- I have been trying to set up Excel cell data validation with drop down lists from VBA Behind an Access application. I can do it with reference to a simple named or otherwise range defining a list, but not with a validation formula containing functions like OFFSET.I have also tried...
- Tags: Microsoft Office, David.Jackson@..., Microsoft Excel
- Discussion threads 2007-04-23
- The Art of Code Validation
- Art is a negotiation between the artist's imagination, talent, and medium. The art of code validation requires objective program assessment and willingness to make changes. Validation is of paramount importance in the pharmaceutical, biotech, and medical devices industries. The person creates what he or she thinks is the best work,...
- Tags: Art, SAS Institute, Person, Validation
- White papers 2007-05-14
- Outlook deleted rule still working
- I have a user that had created a rule and it worked fine. Then she deleted it but discovered the "rule" was still acting like it was in place. She says this has happened before with other rules. She had to reinstate the rule in order to...
- Tags: p_cheatum@..., Microsoft Outlook
- Discussion threads 2007-11-15
- Perform standard and custom validations with the ASP.NET 2.0 Framework
- With the ASP.NET 2.0 Framework, developers can use validation controls to prevent users from entering the wrong type of data when a form is submitted to the web server. For example, you can use validation controls to prevent a user from submitting the value "apple" for a birth date field....
- Tags: Chapter, Sams Publishing, Microsoft ASP.NET, Microsoft ASP.NET 2.0, Validation Control, .Net, Middleware, Software Development, Software/Web Development, Enterprise Software, Software
- Book chapters 2006-07-20
- Prob in creating dropdown in excel
- while creating drop down in a workbook,when i tried to link it with another workbook via data->validation,it shows :"u may not use references to other worksheets or workbooks for data validation rules."I m using Office 2003.The answer is right there. You may not use references to other worksheets of work...
- Tags: Microsoft Office
- Q&A 2005-02-27
- Validation of date format in MS Excel
- i want to give a validation of date format in MS Excel.my date format is mm/dd/yyyy.if sombody enters a different format,it will show error message.i tried with Data-->validation-->but if i give a date like 12345(with out '/'),it is automatically converting it to date.i don't want this .how can i do...
- Tags: Prince.Jose@..., excel date validation, project management, programming, off-topic, Microsoft Corp., Microsoft Excel
- Discussion threads 2007-01-14
- Using the "80-20 rule" to help set priorities
- I use the 80-20 rule all the timeI use the 80-20 rule extensively, and have done for years. The version of the rule that applies to us is that 80% of the result takes 20% of the effort. The final 20% of the result will require 80% of the effort.Following...
- Tags: PRODUCTIVITY, williaa6@...
- Discussion threads 2007-09-25
- << Previous
- page 1 of 1
- Next >>
