If you are familiar with the ADO capability to create stand-alone Recordsets from the thin air, that is by adding items to their Fields collection, you’re also probably aware that

‘ Check if a value is Null. If not it returns the value, ‘ otherwise it returns the ValIfNull argument, or zero/null string’ if the second argument is omitted” This

ADO lets you create a Recordset without creating an explicit Connection object, using the following syntax: Dim rs As New ADODB.Recordsetrs.Open “Authors”, “DSN=Pubs” If you later want to create another

Everyone tells you how to import, but even MS-VB techs start coughing when you ask how to export with DAO! In fact, their own documentation clearly states that it can

Using Java, you can easily find out what Web server is installed on a remote machine. Just open a URLConnection to the remote host and parse the header for the

There are a lot of graphics packages for Web pages on the market, but sometimes you still want a homegrown solution. Using just HTML, it is possible to create simple

SafeRef() returns a reference to the context wrapper instead of a reference to the object itself. You should never pass a direct reference of an MTS object to a client

Imagine you have to write a simple stock quote application that accepts stock symbols and retrieves their current values. Using a std::string object to represent a stock symbol is inefficient

When a program opens a file, the operating system returns a corresponding file descriptor that the program refers to in order to process the file. A file descriptor is a

The standard header contains forward-declarations of the I/O classes and templates. This header is sufficient to refer to any of the I/O classes and templates but not to apply operation

Overloading the function call operator can be somewhat confusing because the overloaded operator has two pairs of parentheses. It may not be immediately obvious which of these pairs declares the

The abbreviated forms “ctor” and “dtor” (“c-tor” and “d-tor”) are widely used in C++ literature, newsgroups, magazines, and in the ANSI/ISO Standard. These terms are simply the shorter forms of

How would you like to be able to make a form automatically resize and reposition all its controls and fonts whenever you resize the form? How would you like to

Here’s an easy method for making sure your users enter only numeric data, and only one decimal point. First, place two Public procedures in a standard module. You can use

When you’re editing a series of controls, you can multiselect them either by clicking while holding down the Control button or by “lassoing” them with the mouse, then enter the

Standard VB forms don’t support a scrollable client area. Normally, when one is needed, programmers resort to convoluted solutions such as filling the client area with a picture box, placing

Question: I have to make a programm to read DATA from a Card, the first function that I must call says: Function_name(hcaller As Long,…) This hcaller is an hWnd and

Question: I am designing a three tier architecture framework. For passing data from one tier to another, I am using ADO disconnected recordsets. For Reading, Updation and Deletion, I create

Question: What’s the consensus as to whether it is better to use the ADO native driver, or use the ADO ODBC wrapper with Oracle? Answer: Microsoft now provides a native

Question: I have used several ADO data controls as well as one data environment designer in my app. This appears to “hardcode” the path to my database forcing me to

Question: What is the correct format to create a SQL string using embedded variables? I keep getting a message that says I have an “incomplete query clause”. I am trying

Question: How do I get the TextBox to display automatically at the end of text instead of at the begining of the text? Answer: Set the SelStart property of the

Question: While using the dateadd() function to add the given number to an existing year, it adds the days instead of years if we use the command in the following

Question: I am using the format function to format a date entered by the user. My machine’s short date setting is mm/dd/yyyy. My OS is NT 4.0 Format(25/05/01,”Short Date”) gives

Question: How can I create dynamic controls, such as a textbox, without a basic control in the form ? Answer: In VB6 you can add new controls to the Controls

Question: We have users who routinely double-click on the command buttons. What is the best way to ensure that the code is only fired once? Answer: One approach would be

Question: I’ve made a VB ActiveX DLL and defined a class and some methods to perform some database operations. I pass an ADO connection by reference to this class from

Question: I have the VB6 Enterprise Edition which is going to be the development tool. Is it possible to have a network installation of VB6, so that I can put

Question: How do you put different objects in a TabStrip? I can make it but once I add something to it in the preview area, it shows up on all