Question: I have a form with a rather large text area inputting over 4000 characters of data into an Access database. I tried to upload it all at once, and

Question: How do you set the maximized state of a window within code? Answer: The Java AWT does not provide an interface for maximizing a window.The Swing JInternalFrame supports a

Question: Is there a way for me to kill, destroy, release, or otherwise cancel a form that has hung, without quitting the current instance of Visual FoxPro? I’ve tried practically

Question: How do I temporarily disable foreign keys in a table, insert more rows, and then enable them again? In particular, I need to know about syntax and what the

If you are developing COM components which run under MTS (Microsoft Transaction Server) then you may want to replicate one machine’s catalog to another machine. Here is a command line

If you want to improve performance of your application then you should always try to use strict type variables. You can use strict type (or strongly typed) variables by referencing

SQL Server 7.0 allows the tempdb system database to expand automatically as needed, rather than failing with an out-of-space error. If a reporting application needs a lot of space in

In order to run this tech tip you need following things:(a) VB5 or VB6(b) Reference to Type Lib information object component (TLIBINF32.dll). This function takes in the name of the

If a run-time statement error (such as a constraint violation) occurs in a batch, the default behavior in SQL Server is to roll back only the statement that generated the

The Windows shell provides a simple way to detect whether a given folder is shared or not. You must call the SHGetFileInfo() API function and analyze the way it fills

Not all programs may run on all the Windows platforms. Often programs require at least a certain version of Windows. In most cases, this is due to the lack of

If you ever needed to programmatically enable your users to search for files, you certainly found useful the possibility of reusing the system Find dialog integrated in the Start menu

Even if we’re living in a 32-bit world, and closer and closer to the 64-bit day, 16-bit programs are still running out there. Knowing whether a given EXE is 32-bit

NOTE that this tip requires Windows 98, Windows 2000, Windows 95/NT 4.0 + Active Desktop.If your application must do a lot of work with Office documents, then chances are that

In most cases, you can use CoCreateInstance and forget about CoGetClassObject.Function CoGetClassObject returns the pointer to the desired component’s classfactory and not the component itself. The desired component is created

Unicode characters use more storage space than characters in a regular SQLServer character set use. A regular SQL Server character set is a single-byte set that supports up to 256

Error messages should be passed on to users so that they are always aware of the problems they have encountered and will perform the requested actions. Although you cannot use

By default, all static variables, structs and arrays are automatically initialized to binary zeros before program’s outset. Likewise, static objects are initialized to binary zeros before their constructor is activated.

Although the string class is very convenient for most string manipulation operations, it may be necessary sometimes to copy the contents of a string to a different container, e.g., in

If you don’t want users to navigate to another URL when they click on a HTML link in an anchor tag, you need to create a Null HTML link in

Sometimes it’s useful to trap the right click over controls such as CommandButton. Unfortunately, the Click event only fires for left button clicks. The MouseDown and MouseUp events fire for

Prior to VB5, when you wanted to make a form appear on top of another form, you either made it modal or used an MDIForm with children. If you wanted

To prevent losing the ability to maintain binary compatibility with compiled object code, take the first compiled build and move it into a separate directory, then tell VB to maintain

The typical method of validating multiple expressions is to string together a series of If statements separated with an equal number of And statements. Shorten that process by passing one

If you need to get a Web page visitor’s IP address in your ASP script, it

Variables and objects defined within a namespace have static storage type. As such, namespace members are by default initialized to binary zeros before program’s outset. Likewise, namespace members are destroyed

In JavaScript, it is easy to ask the user to confirm an action by using JavaScript Confirm () function. Say you have a function NavigateToWebAddress() (which needs confirmation from the

You can allocate a multi-dimensional array dynamically, as in this example: int*pp[10]; //an array of ten pointers for (int j=0; j

To print the entire document from JavaScript, use parent.print() in the code. For example, this code snippet can be used to print the entire document on click event.

A pure function should never be invoked. However, a buggy program or a buggy compiler can sometimes call a pure virtual function. In general, when a pure virtual function is