Data Type
95 Stories
Quickly add special formats to Word with Find and Replace
Techguide Use Word's Find and Replace command to add a specially formatted word or phrase to your text instead of formatting each instance of the word or phase individually. Mary Ann Richardson lets us in on the secret to special formats.
Explore Java's static nested classes and inner classes
Techguide Get tips on how to make sense of the sometimes confusing semantics for creating instances of nested classes.
Explore static nested classes and inner classes
Techguide Starting with JDK 1.1, Java provided the ability to create nested classes. A nested class is defined inside another class. There are two types of nested classes: static nested classes and inner classes.
New Date Datatypes in SQL Server 2008
Techguide SQL Server 2008 provides new data-types for storing wider ranges of dates with more precision. Here's how you can use these new data types to your advantage.
Tags: Server platforms, Microsoft Windows, Data Type, Microsoft SQL Server, Data, Database, Storage, DATE, DATETIME2, Server
Microsoft Access 2010 new feature overview
Techguide Here are some of the new features you can expect to see in Access 2010, including a Web-ready format and an improved macro environment.
Tags: Microsoft Office, Microsoft Office, Row, Database, Cell, Field, Microsoft Corp., Data Type Gallery, Access 2010, Office Theme
Quickly delete every nth row in Excel
Techguide Susan Harkins explains how to use AutoFilter to delete specific rows in a worksheet.
Tags: Microsoft Office, Row, Column, MsgBox, Microsoft Corp., OrderID, Microsoft Word Override Word, Goto, Clear, Microsoft Excel
Spot invalid imported data with help of custom Excel function
Techguide Anytime you have to manually review worksheet data to look for errors, something can slip through. Here's a handy safety net: a user-defined function that will flag one type of invalid data.
Tags: Microsoft Office, Animation, ALT, Microsoft PowerPoint, Microsoft Excel, dialog box, Microsoft Office, Microsoft Word
Add your own table style to Word's AutoFormat Gallery
Techguide Do you find that the available table styles in Microsoft Word's AutoFormat feature are never exactly what you need? There may be one style that you use often, yet even with that style, you find yourself modifying it each time you use it.
Sun outlines future Java standards
News Sun Microsystems has outlined planned enhancements to future editions of Java for building desktop and server applications.
Tags: Java
Assemble professional documents with Word's building blocks
Techguide When you need to find an important report in a Word document in a hurry, you don't want to spend time formatting it. But this doesn't mean you have to sacrifice presentation for substance.
Tags: Microsoft Office
Performance Analyzer speeds up Access database response
Insight Poor database design can slow your Access users to a crawl. Find out how to use Access's built-in Performance Analyzer to quickly analyze a problem database and automatically repair and optimize DB objects.
Gain data storage flexibility in VB6 with dynamic arrays
Techguide Dynamic arrays make it easy to change the size of arrays in a VB6 program while it's running. See how useful this can be when you don't know ahead of time how much data the array will store.
Tags: Storage
Quick Tip: Correct Paste errors in Access before they happen
Insight Do you support clients who paste data directly into Access tables? If so, you probably often get calls from users who receive a message that Access is adding data to the Paste Errors table when they're trying to paste. When that happens, you can usually explain and resolve the problem pretty quickly by considering all the usual suspects.
Massive SQL-based Web attack decoded
News The SANS Internet Storm Center and others published details about the massive SQL-based Web attack that occurred over the weekend.
Tags: PC security, Data security, Hacking, Security Management, Spam and phishing, Viruses and worms, IDS (Intrusion Detection Systems)
Use options to change your default document folder
Techguide Each time you save a Word 2007 file, it winds up in the My Documents folder. Here's how to to change your default document folder for Word 2007 files.
Tags: Microsoft Office
