Question: Which is the fastest way to open a recordset (ADO) to add new records: SqlString=”select * from authors where id

Under Windows NT you can programmatically display the Connect To Printer dialog using one simple API function: ‘ This works only under Windows NT and 2000Private Declare Function ConnectToPrinterDlg Lib

Private Type RECT Left As Long Top As Long Right As Long Bottom As LongEnd TypePrivate Declare Function GetClientRect Lib “user32” (ByVal hWnd As Long, _ lpRect As RECT) As

Private Declare Function SetCursorPos Lib “user32” (ByVal X As Long, _ ByVal Y As Long) As LongPrivate Declare Function GetWindowRect Lib “user32” (ByVal hWnd As Long, _ lpRect As RECT)

Private Type POINTAPI X As Long Y As LongEnd TypePrivate Declare Function SetCursorPos Lib “user32” (ByVal X As Long, _ ByVal Y As Long) As LongPrivate Declare Function ClientToScreen Lib

If your VB application is meant to be called from within a Ms-Dos batch file, you must be able to return Dos an error code. This can be accomplished using

Private Type POINTAPI X As Long Y As LongEnd TypePrivate Declare Function GetCursorPos Lib “user32” (lpPoint As POINTAPI) As LongPrivate Declare Function WindowFromPoint Lib “user32” (ByVal xPoint As Long, _

Private Type POINTAPI X As Long Y As LongEnd TypePrivate Declare Function GetCursorPos Lib “user32” (lpPoint As POINTAPI) As LongPrivate Declare Function ScreenToClient Lib “user32” (ByVal hWnd As Long, _

Private Type POINTAPI X As Long Y As LongEnd TypePrivate Type MSG hwnd As Long message As Long wParam As Long lParam As Long time As Long pt As POINTAPIEnd

In Windows 95 and 98, when the screen saver is currently active (and the screen is blanked) the Ctrl-Alt-Del key combination doesn’t work, in order to force the user to

Question: I have downloaded an ActiveX DLL (A third Party ActiveX component) for uploading files to my server. The problem is I can not register the DLL in my Web

When designing an internet application that must provide results in a grid, many developers will use small (1 pixel by 1 pixel) images in order to create a grid effect

Populate a flexgrid control with specified columns and filtered rows by drawing the control and calling this routine: Dim strWhere As StringstrWhere = ” WHERE PeopleAddressesID=4502″Call PopulateFlexGrid(Me.MSFGrid, “tblPeopleAddresses”, strWhere,”PeopleAddressesID”, “BuildingName”,

During development, it is often necessary to have blocks of code for debugpurposes. If the debug code is lengthy, commenting anduncommenting it can be tedious. But if you put either

This is a very simple but time-saving and powerful tip to build a dynamicSQL query (in SQL Server 7.0) that updates a particular column value present in all tables. And

Question: I have some complex engine control software that has to run under MS-DOS 6.2, but it needs to transfer data to SQL Server 7. What’s the best way to

Question: I have a table that stores test answers. It looks something like this: Student Date_taken Q1 Q2 Q3 … Q78 If each question (Q%) is true/false (ENUM(”,’T’,’F’)), how do

Question: I tried a DTS export of a table to an Excel file. The data types of all the columns in the table are varchar. When it exports to the

If you have a recordset already created and want to filter it by some criteria, you can use the Filter property of the recordset to do it. Just change the

You can use the dot operator (.) in XSL transformation stylesheets to refer to, effectively, “whatever element was just identified.” Let’s say you had this template in a stylesheet: Say

If you’re getting a bunch of data for an ASP page, you can retrieve all the data through a single stored procedure and through a single call. Here’s what your

Moving your ASP code to compiled components is always a good idea. Compiled components enable fast execution, along with easy development, debugging, and testing. For example, creating a record set

Question: Is it possible to display the address of the previous Web site as a string so that I can use it elsewhere? Answer: If the user got to your

Question: I have noticed that all rounding to x decimals scripts uses the following format: tenToPower = Math.pow(10, nDecimals);newNumber = String((Math.round(nNumber * tenToPower) / tenToPower)); However, that doesn’t work with

Question: I have tried to reorganize Informix chunks on my disks. So I stopped the Informix and started to copy chunks to a new location with a cplv command (AIX).

You can use savepoints in rolling back portions of transactions to predefined locations. A T-SQL savepoint defines a location to which a transaction can return if part of the transaction

Programming with style sheets is never an easy task if you want to write browser-neutral HTML code. This is because the DOM (Document Object Model) of the Internet Explorer and

The LookupTable object is marked as ThreadingModel=Both and doesn

I have a bunch of files on the server that I wanted to be able to select, for example, to delete them or to give them special treatment. Thus, I