The new FlatScrollbar controls expose the ability to selectively disable their arrows. This is useful, for example, when the thumb indicator is at its minimum or maximum: Private Sub FlatScrollBar1_Change()

Most VB controls don’t let you determine whether they should display a scrollbar or not. For example, a VB ListBox control displays a vertical scrollbar only when the number of

The VB CommandButton control supports neither the ForeColor nor the BackColor properties. If you want to create colorful buttons without resorting to 3rd party controls, you can use an OptionButton

By default, VB’s CheckBox controls automatically toggle their Value property when the user clicks on them. This is usually the desired behavior, but at times you may want to be

The ComboBox control doesn’t expose any property that lets you to control the width of its list area, but this can be easily accomplished by sending it the CB_SETDROPPEDWIDTH message,

Unlike the TextBox control, the ComboBox control doesn’t expose any MaxLength property, so you have no means of limiting the numbers of characters typed by the end user in the

Contrary to common belief, Debug.Print statements are not always removed from an executable. This behavior can be demonstrated easily. Open a new project, place a single CommandButton on the default

It’s possible to streamline some calculation procedures in Excel and add calculation capabilities that don’t exist in Word. Unfortunately, most textbooks on VB for Office 97 are focused on nonmathematical

Because server/client round-trips are inherently inefficient, you should try to eliminate the need for excessive round-trips. When you design a class or a user-defined interface, you should never expose three

In C, algorithms that rely on pointers such as bsearch() and lfind() return a null pointer to indicate that the sought after element wasn’t found. Unlike a pointer, a reference

Enhancements to the lock manager in SQL Server 6.5 provide row-level concurrency for INSERT operations. Properly implemented rowlock increases the speed of multi-user INSERT operations. Insert rowlock (IRL) is OFF

Similar to GzipServlet, this tip uses header information for tuningoutput of our servlets; this one allows you to check the header ‘Accept-Language’. If your user has set some language preferences

You can mark an ASP page with a transaction support property, just as you can do with a registered MTS component. An ASP scripting object thus can serve either as

Question: I’m having a problem writing a SELECT statement that will compares a date stored in a table against the current time. This is for a calendar on a Web

Question: I am using Exchange Server 5.5 and Outlook 97 on about 30 workstations. I use a public folder to store shared contact info. On all but two of the

Question: In Microsoft Access you can use a query as the source for a select in a second query. Additionally, you can use two queries as the source by utilizing

Question: I have a Visual Basic project about a video store, for which I have to produce a report that includes the following: Top 10 movies last month Number of

Question: I have a Web page that lets the user query my database and return results in groups of 50 records. I know how to do the first SQL statement

Question: How do you list available tables and their schemas from an SQL query? Answer: There is an owner in the database called INFORMATION_SCHEMA who has a bunch of objects

Question: How do I convert a character string into a time field? Data is being read in as 12:10 and I need to calculate response times based on this field.

Question: If I just want to see some data from a table, is there some SQL syntax to prevent 2 million rows from coming back without adding conditions on the

Question: Could you please give me a simple explanation to what stacks are? How do they work and what are their related features? Answer: Stacks are temporary resting places for

Question: I have a table below: Name idJohn 40Mary 50Peter 15John 40Peter 15John 40 How can I query to get who appeared most of the times in the table? (In

Question: I can’t remember the reason for the efficiency of the SQL query. I thought that the results of the query are sent to a “client,” as opposed to the

Question: I am writing a Visual Basic app that is all about a database created in Access 97 with about 500 records. I want to be able to filter things,

Question: Is there a “best” way to design VB/ASP apps to deal with SQL (7.0) security? For example, in a WAN environment and a Web application where the app needs

Question: Microsoft naming conventions for Visual Basic (Hungarian notation) is well documented and widely used. Is there a similar/well-known standard for variables used in SQL Server stored procedures? Answer: Not

Question: The Enterprise Manager (or whatever it’s called now) shows all the systems tables when you navigate down to the tables in a database. How do you hide the system

Question: I have a statement to submit a form: This JavaScript will validate entries in different textboxes placed on the form: FormCheck(this.form, ”, ”) When the user clicks the enter

Question: I recently bought a book that includes the XML specification as well as some commentary. Much to my surprise, I found that after authoring an XML document, the browser