Question: I created a program to help our sales department to keep track of their sale quotes. It uses a MDB database and I used the ADO components to gather

Question: When opening an ADO connection, how do I specify that it use the SQL Server OLEDB provider with a DSN? Answer: Here’s the connection string you should use. Be

Question: How would I get a different picture to pop up every 3 seconds in a different position? Answer: It’s pretty simple, actually: Make a form with an image/picturebox control

Question: I have an Access 97 database with an OLE Type field containing bitmaps loaded with the LoadPicture() function. This works fine and the images turn up as “Bitmap Image”

Question: I am an extreme newbie with VB. How do I change the caption of a label to the value of a textbox? Answer: Substitute the name of the Label

Question: I have been using Visual Basic to manipulate databases for some time now and I consider myself skilled at it. The next challenge presented is to establish a connection

Question: When a control has focus, is there some way to determine which control had focus just before it? Answer: Nope, there isn’t any way to do that. But, I

Question: After I compile my DLL in VB and run the component through IIS, I cannot recompile the DLL and I get a file locking error. I am using VB6

Question: I get the folling error message when I try to run my code: Compile Error: Procedure declaration does not match description of event or procedure having the same name.

Question: I have a listbox with some names loaded from a recordset, I have also associated the memberID with its associated name as in the following: lstMember.ItemData(lstMember.NewIndex)= rsMembers![MemberId]. I want

Question: Is there any way I can make a JFrame look like JInternalFrame? It looks bad at runtime when you change the look-and-feel, but the mainframe doesn’t change. Answer: This

Question: Is it possible to have an array of character arrays? What about anarray of multidimensional character arrays? Answer: Java arrays are first-class objects. They can be referenced byObject reference

Question: I am trying to get remote access to my e-mail account. Although I can dial in the domain successfully, when I start Outlook, I receive this error message: “Network

Question: I am running Exchange 5.5 with about 60 mailboxes. When I try to access the e-mail tab of a newly created mailbox I get the following error: an error

Question: Is it possible to rotate a column 90 degrees in a PowerBuilder (5.0.04) datawindow so that the data print up and down instead of the usual left to right?

One of the simplest and most effective uses of the ObjPtr function is to provide a key for quickly locating an object in a Collection. Let’s suppose you have a

You can retrieve and change the blink rate of the flashing caret inside TextBox controls through a couple of simple API functions: Private Declare Function SetCaretBlinkTime Lib “user32” (ByVal wMSeconds

The ConfigurePort API function lets you programmatically bring up the system dialog box for configuring a COM or LPT port. The function returns a non-zero value if successful (that is,

It might surprise you to learn that Friend procedures are sensibly faster than Public ones. You can prove this yourself by creating an ActiveX EXE project with one Private class

VB6 functions can return an array. Unlike regular functions that return scalar values or objects, however, you can’t use the name of the function as a local variable where to

As explained in the Mistake Bank you need all three flavors of Property procedures to correctly implement a Variant property that can take either an object or a non-object value.

The ListView control that comes with VB6 lets you select an entire row by setting its FullRowSelect property to True. If you are working with VB5 or you’re using VB6

Creating a read-only property or a write-only property isn’t difficult, as you probably know: just omit the Property Let (or Set, if dealing with objects) or the Property Get procedure,

The Open statement also supports special device names such as COM1 or LPT2. You can build on this feature and use the Open command to test whether a given serial

VB gives you no control on the size of the text caret. At times it can be necessary to change its size, however, for example when you want to signal

You can use the Navigator object to retrieve information about the browser that is executing your code. Using this object, you can decide to execute different code for different browsers.

The Active Server Pages Session object provides a quick way to password-protect your pages and force users to log in. The trick is to set a Session variable once the

Some users have spent frustrating hours trying to add a data connection to a Visual InterDev 6 project but only get the error, “No such interface supported.” This is often

Many of the C Runtime Library functions are in fact macros in disguise. < stdlib.h> routines, memset(), strcpy() and others are often implemented as macros that perform some low-level system

You cannot forward declare a nested class. For this reason, the following code will not compile: // assuming class B is nested in class A int main() { class A::B;