Question: I have opened a table as a grid object. I want to go to a desired column (say 34) and the table has 62 fields. Currently only columns 1

Question: I have a form for which I do not want to give the user navigation privileges. I want the form to pop up at the record specified by a

Question: Is there an easy and efficient way to insert an XML document into another XML template? The insertion point can be before, between, or after specified nodes. Answer: Sure.

Question: I am using a data store that has 13 columns with data in them. I want to destroy five of them. I know that there is a PB command

Question: I am calling an .FXP from a batch file, but would like to pass a variable. Am I able to do this? How would FoxPro recognize it? Answer: You

Question: How do I enlarge FoxPro’s design window? Answer: Here’s how: From the menu, choose Tools | Options. Click on the Forms page of the pageframe. You will see a

Question: I am currently building a VB application that needs to delete records in a .dbf field. The connection to the database is established through ADO by using a DSN.

The HTML Style syntax lets you apply the same style attributes to a group of tags at the same time. You don’t need to define each tag’s styles separately. The

You can use the shorthand way to read Request object variables in ASP, like this: sVariable = Request(“txtVariable”) However, you must be careful when using it this way. The Request

COM server-side objects must be as small as possible. If the server objects are small, their load time will be short and the client will experience a good response time

COM objects can be implemented either in-process or local. The former is implemented as a DLL and runs in the same process space as the client. They become a part

In SQL Server, a column’s default value can be specified as part of the Create Table statement. This default value will be set for the specified column in cases where

It’s helpful during debugging to be able to print out values as the page is executing. Although this is generally done using Response.Write statements, it can also be done with

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,