Private Declare Function mciSendString Lib “winmm” Alias “mciSendStringA” _ (ByVal lpstrCommand As String, ByVal lpstrReturnString As String, _ ByVal uReturnLength As Long, ByVal hwndCallback As Long) As LongPrivate Declare Function

Private Declare Function mciGetErrorString Lib “winmm” Alias _ “mciGetErrorStringA” (ByVal dwError As Long, ByVal lpstrBuffer As String, _ ByVal uLength As Long) As Long’ Get the description of a MCI

Visual Basic 6 is the first VB version that lets you programmatically change the DataSource property at runtime, for example to point to another ADO Data control or another ADO

Sometimes is useful to add an icon in the Window taskbar’s status area (a.k.a. System Tray), to gain a better interaction between the user and your application. The only API

Const SND_ASYNC = &H1Private Declare Function PlaySound Lib “winmm.dll” Alias “PlaySoundA” (ByVal _ lpszName As String, ByVal hModule As Long, ByVal dwFlags As Long) As Long’ Play a WAV file.”

Const WS_CHILD = &H40000000Private Declare Function mciSendString Lib “winmm” Alias “mciSendStringA” _ (ByVal lpstrCommand As String, ByVal lpstrReturnString As String, _ ByVal uReturnLength As Long, ByVal hwndCallback As Long) As

Browsers Targeted: Internet Explorer 5 Behaviors let you create specific functionality within custom HTML tags. XSL (Extensible Stylesheet Language) lets you transform a block of XML into some form of

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