‘ Shuffle the elements of an array of any type’ (it doesn’t work with arrays of objects or UDT)Sub ArrayShuffle(arr As Variant) Dim index As Long Dim newIndex As Long

‘ Return the sum of the values in an array of any type’ (for string arrays, it concatenates all its elements)” FIRST and LAST indicate which portion of the array’

‘ The average of an array of any type” FIRST and LAST indicate which portion of the array’ should be considered; they default to the first’ and last element, respectively’

‘ The standard deviation of an array of any type” if the second argument is True or omitted,’ it evaluates the standard deviation of a sample,’ if it is False

Question: How can I interact with a running version of Internet Explorer or Netscape? When I say interact, I mean handling or monitoring browser events such as right click or

Question: We are using Visual Basic to develop our new applications and will be converting our old applications from COBOL to Visual Basic in the near future. We want to

Question: How do I sort columns with their corresponding rows of information and then add data? I would like to use the data in a Web page. Answer: If you

Question: I want a simple way to get a report from a SQL server database to HTML. Then I want the report to print, nicely formatted. How do I do

Question: How does the browser history work? Is it possible to take out a link in the history? For example, I have a page with a redirect. The redirect works

Question: Some users access the Microsoft Access 97 database through a Web user interface and others directly to the MDB file. Will it speed Web access if I create a

Question: I have two different styles on my page: “content” and “small”. To avoid the “onmouseover…” lines within the tags, I defined the A:Hover line. Now if a user moves

You can optimize the performance of your “JavaScript” code by properlyarranging the conditions in the “if” statement. If you have severalconditions to be tested together, and you know that one

Use the following as a guideline through the maze of JDBC drivers. Type1 Also known as JDBC-ODBC bridge which provides JDBC access to most ODBC drivers. The primary drawback of

Suppose you need to create a tree of directories, all at once, in code. For example, you could create the tree C:1stDir2ndDir3rdDir4thDir with one call simply by feeding that path,

A cast is a conversion of data type on a variable. Casts can occur when you explicitly request them as in: Frame f = new Frame; Object o = ((Object)Frame);

One of the nice things about VB is the ability to redefine most of the built-in commands. For example, you can extend the functionality of the Trim family of commands.

Question: How can I get the system time using HTML and JavaScript? Answer: I’m assuming that by “system time,” you mean the time on the client machine. You can access

Question: I have a menu frame that has a popup menu with many options and four buttons below it. How can I change the buttons’ destination links depending on the

Packing resources (classes, sound files, images) in a JAR file is good way of reducing download time and decreasing distribution size. This tip shows you how to load images off

Here’s a cool way to swap strings: Declare Sub CopyMemory Lib “kernel32” Alias _ “RtlMoveMemory” (Destination As Any, _ Source As Any, ByVal Length As Long)Sub SwapString(String1 As String, String2

When using the WebBrowser control in VB, you might want to present information without having that data accessible to the end user. In this case, you can simply insert the

Question: Is there a technical or logical difference between using an ANSI style join and specifying the join using the WHERE clause? Is there a general preference to either method,

Question: I have set up an Exchange mailbox in Outlook 2000, but I am missing some folders. I can only see the Deleted Items, Inbox, Outbox, and Sent Items folders.

Question: I have the following fields: productid, category. A product can be in many categories, and a category can have many products. For example, product1 can be under category1 and

Question: I have a main table where there are three fields: UserID, Postal code main, Postal code sub. I have a second table where there are two fields: Postal code,

Question: I have a Visual FoxPro 5.0 application that I installed to run as a service on an NT server. Everything works fine except for when the user attempts to

Question: In a site that has multiple servers (some top-of-the-line, others border-line) is it better to use PSTs (personal file folders)? In other words, does it enable Exchange to perform

Question: I’m currently working on a data warehousing application using SQL Server 7. The problem I have is that I have to import 610,000 records of mainframe data per day