In general, the Expires property of the Response object can be used to “expire” the Web page. This prevents a browser or proxy server from caching the page. However, a

You can declare a variable as a public variable to make it available to all the procedures throughout the entire module. However, this not only makes the variable available to

Question: Would it be practical to use an XML document, or more accurately documents, as a database, and if so, how would you recommend doing this? I would use XML,

The Format Painter button in Microsoft FrontPage 2000 is really handy for copying a style from one area of text and applying it to another. The only problem is that

When using VB to create a new ActiveX control with a Caption or Text property, you can set the corresponding Procedure ID to cause the Property Browser to update the

Some developers suggest putting DoEvents in loops to keep your application responsive. This is never a good idea. If the loop is short, you don

Sometimes you have to move information from a flat file (mainframe or ASCII text file) to a database. Usually, this flat file is a set of records, and the delimiter

I read a great advanced tip on how to create a GUID in “Generate Unique String IDs” [“101 Tech Tips for VB Developers,” Supplement to VBPJ, August 1999]. However, you

Here 

If you do a lot of floating-point division operations in VB, you can optimize these operations by multiplying by the reciprocal value. For example, instead of performing this calculation: X/Y

You might have wished you could right-click on a VB file and open it in Notepad, or copy a snippet of code for another app you

I often open up many windows in a VB project when I

When I use variables that need to be saved to the Registry or to an INI file, I sometimes forget to place the API call after the variables in a

I program all reusable components into DLLs or OCXs. To provide a consistent error-handling technique across all my projects, I use the Raise method of the Err object in all

ShellExecute is one of the most flexible Win32 APIs. Using ShellExecute, you can pass any filename, and if the file

You can allow users to resize a control?just like in VB design mode?with a mouse, using two simple API calls. You can resize the control?top-left, top, top-right, left, right, bottom-left,

When you create generic functions, remember that many functions are a two-way street. For example, many general utility modules contain both LoWord and HiWord functions. However, to compose a Long,

I 

This is an update to [

Question: I’m using a function named Browseforfolders() that uses the following code: Private Declare Function SHBrowseForFolder Lib “shell32.dll” _Alias “SHBrowseForFolderA” (lpBrowseInfo As BROWSEINFO) As Long and the declaration of this

Question: How do I run a SQL stored procedure from within Visual Basic? Answer: The easiest way is to use the Execute method of either the Database object (DAO) or

Question: I have two varibles, one containing the name of another varible, and one containing a string. How can can I set the varible that’s name is contained in the

Question: I have a database of strings of hex numbers and I want to convert them to decimal. There doesn’t seem to be a function for it, but can you

Question: I want to Transfer records from one Database table to other Database table but through VB. I can’t write a query such as I can for SQL Server: Insert

Question: I am building an SQL statement to Insert and Update records. If the user enters a double quote mark in the text box the SQL statement treats this as

Question: I have a struct: struct mystruct{ DWORD dw_Id;}*pMystruct; In the following function I want to pass the address of ‘dw_Id’ which is a member of mystruct. How do I

Question: When using Queryinterface in COM, why is the interface pointer cast to void** andwhy is it passed as a pointer to a pointer (double indirection)? Answer: This is because

Question: If I use malloc locally in a function do I have to use free as well? Won’t someother piece of the application eventually chew up the memory I mallocd,

Question: I’ve writen a program that simulates a heat circulation, and one of its functions performs an optimization processwhich uses a lot of dynamic memory. Myquestion is, can I use

Question: Is there an equivalent of the CallByName function that returns a list of proprety and method names for an object? Answer: No, there isn’t. If you need that, you