Question: Is there a painless way of converting a Novell 4.1 server to N.T. 4 without just performing a total rebuild? There are no applications running from the server but

Question: I was wondering if there is a list available somewhere of all the commands with their syntax for OLE? I want to manipulate Word and Excel from inside Powerbuilder

Question: How do I access more than one database (e.g., Oracle and Access) via a Powerbuilder application? I currently have ODBC drivers for both databases, but cannot access the required

Question: How do I schedule to run my Exe automatically?When I schedule it, the exe does not run. Answer: First, for Command Scheduler to work consistently, the Schedule service must

Question: How can I count how long an application is used? Answer: You can use two time variables for this. Use the first variable to record the start time, then

Question: Do you have any examples of calling MS Word Visual Basic to open, modify, print and close a document (i.e., calling macros, inserting tables)? Answer: Here is an example

Question: I have a question about running NT Server 4.0 with Service Pack 4. On start-up, I’m getting an error in my event log: Source: Server Control Manager, EventID 7023,

String comparison doesn’t work for variables. In fact, only variables referencing the same string will work. The String class has an intern method, which lets you compare two variables. This

SQL Server 7.0 allows field and table names to contain spaces or other characters that violate valid identifier rules. These table or field names should be enclosed in “[” “]”

The Visual InterDev environment can save you a lot of typing if you use the Complete Word command while writing script. Just type the first couple of letters of a

The Procedure Attributes dialog includes a Procedure ID combo box, that lets you associate a particular ID to a given member of the class. You usually use this combo to

It is very simple to retrieve the correct currency symbol, using just plain VBA statements: currSymbol = Trim$(Replace(FormatCurrency(0,0), “0”, “”)) If you can also determine if the symbol precedes or

ActiveX components written in VB can contain both SingleUse and MultiUse classes at the same time. It usually isn’t a good idea to use both types of classes in the

Here’s the correct declaration of the CopyMemory API function, which is so useful whenever you want to move a block of bytes between two memory locations: Declare Sub CopyMemory Lib

Many developers incorrectly assume that a printer is always installed on their customers’ machines, and therefore omit to check that this is actually the case. The following function, deceiptively trivial,

The Picture box control does not directly expose any property that returns information on the bitmap currently loaded. You can retrieve this information by calling the GetObject API function, passing

Private Declare Function PrinterProperties Lib “winspool.drv” (ByVal hwnd As _ Long, ByVal hPrinter As Long) As LongPrivate Declare Function OpenPrinter Lib “winspool.drv” Alias “OpenPrinterA” _ (ByVal pPrinterName As String, phPrinter

There are a few tricks that you can do with LCase$ and UCase$ functions. I doubt you will be using this tip in all your applications, but here they are

‘ Retrieve a file’s path” Note: trailing backslashes are never included in the resultFunction GetFilePath(FileName As String) As String Dim i As Long For i = Len(FileName) To 1 Step

‘ Return the extension of a file nameFunction GetFileExtension(ByVal FileName As String) As String Dim i As Long For i = Len(FileName) To 1 Step -1 Select Case Mid$(FileName, i,

The standard way to move a captionless form is to execute some tricky code from within the MouseDown event procedure. More advanced VB developers can reach the same result by

‘ Make a complete file name by assemblying its individual parts’ if Extension isn’t omitted, it overwrites any extension held in BaseNameFunction MakeFileName(Drive As String, Path As String, BaseName As

‘ Retrieve a file’s base name’ if the second argument is true, the result include the file’s pathFunction GetFileBaseName(FileName As String, Optional ByVal IncludePath As _ Boolean) As String Dim

One of Internet Explorer 5.0’s new features is AutoComplete. If turned on by the user (it’s off by default) it helps users fill in the frequently used fields–like username, first

Swing’s JComboBox can be used to present a drop-down list, perhaps of status reports from a process, requiring minimal screen space until the user wishes to see the details. But

When architecting a client-server or n-tier application, you should decide on a particular locking technique and accordingly the transaction isolation level and concurrency control strategy for database transactions. This decision

The words argument and parameter are often used interchangeably in the literature, although the C++ Standard makes a clear distinction between the two. An argument is one of the following:

If you turn the mouse pointer into an hourglass (and back to normal) in a routine with error handling, don’t forget to turn the mouse pointer back to normal in

If there is no user-declared constructor in a class, and the class does not contain const or reference data members, the implementation implicitly declares a default constructor for it. An

Beginners often run into permissions problems as soon as they try to write data to a database driven Web site using Access and Internet Information Server (IIS). A common error