The Latest

DevX - Software Development Resource

Create an Internet shortcut

Unlike regular LNK shortcut, which contain data in binary file, Internet shortcut files are just text files in this format: [InternetShortcut]URL=www.domain.com Thus it is simple to programmatically create an Internet

DevX - Software Development Resource

Add multiple child controls to a Coolbar

The Coolbar control consists of a collection of Band objects, and each Band object exposes a Child property. To move a control inside the Coolbar you just have to assign

DevX - Software Development Resource

Add size grips to a form

There are two simple ways to add the so-called size-grips to the bottom-right corner of a form. The first method is to add a StatusBar control, which includes a size-grip

DevX - Software Development Resource

PlayAVIVideoOFF – Play only the audio track of an AVI file

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

DevX - Software Development Resource

PlayAVIAudioOFF – Play an AVI file without the audio track

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

DevX - Software Development Resource

GetMCIErrorString – Get a description of an MCI error

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

DevX - Software Development Resource

Change the DataSource at runtime

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

DevX - Software Development Resource

Create a System Tray icon

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

DevX - Software Development Resource

PlayWAV – Play a WAV file

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.”

DevX - Software Development Resource

PlayAVIPictureBox – Play an AVI file in a PictureBox

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

DevX - Software Development Resource

See Who Is Blocking Your SQL Server

If you have ever monitored any blocking problems in SQL Server, you know that sp_who only shows you the spid (SQL Server’s internal Process ID) that is causing the blocking

DevX - Software Development Resource

Embed XSL in Behaviors

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

DevX - Software Development Resource

Grid Object Methods and Properties

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

DevX - Software Development Resource

Popping Up a Form

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

DevX - Software Development Resource

Insert XML Into Another XML Document

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.

DevX - Software Development Resource

Deleting Datawindow Columns

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

DevX - Software Development Resource

Passing a Variable to a Compiled Program

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

DevX - Software Development Resource

Resizing FoxPro’s Design Window

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

DevX - Software Development Resource

Deleting a Record

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.

DevX - Software Development Resource

Use Style Grouping for Leaner HTML

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

DevX - Software Development Resource

How to Pop Up Message Boxes with ASP Code

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

DevX - Software Development Resource

Take Care When Declaring Public Variables in VB

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

DevX - Software Development Resource

Using XML Documents as a Database

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,

DevX - Software Development Resource

Dual Procedure IDS

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