When you create a borderless form in VB (BorderStyle = 0) and make it visible to the taskbar (ShowInTaskbar = True), only the form’s caption shows and the form’s icon

Here are a couple useful Registry edits to enhance your day-to-day Visual Basic development. Save these Registry lines to a text file with a REG extension, and then double-click on

You might have noticed that if you click on a TabStrip tab, then move the mouse pointer until it’s no longer over the TabStrip without releasing the mouse button, the

Use this small API from the shlwapi (Shell Windowing API) DLL that ships with Internet Explorer (IE) to help you convert file size in bytes into proper strings such as

You can easily share files such as standard code, form, and class modules (BAS, FRM, and CLS files, respectively) between VB and VBA by using the appropriate menu commands. Within

Question: How can I register a DLL that I created with Visual Basic 6 on a remote Windows NT 4.0 server? Answer: You will need to install the DLL on

Question: I created a Web page that uses ASP to access a database on the server and return data to a client browser. While the data is accessed the client

Question: I have a column in SQL Server created like this: “vchrFirstName varchar (50) NULL” However, this code does not produce anything, including any errors, when the record is NULL:

Question: How can I prevent sending the contents of a form field containing single quotes to the server? Single quotes should be converted to double quotes in a way that

Two VBScript built in features are disabled when you are using VBScript on the server with ASP. Because ASP scripts are executed on the server, the VBScript statements, InputBox and

Question: How do you pass parameters from an HTML page using either Java or Visual Basic to an ASP page? Answer: You do not need Java or VB to pass

Question: Why do I get an “unterminated string constant” error message in this code? Answer: You can’t let your strings wrap onto multiple lines without using a continuation character. The

Remember that the .asp files require extra processing at the server end. Therefore, you should not blindly convert all of the HTML pages in your application into ASP pages when

Question: I have a Web page that uses a form to submit information to an ASP page. Once the data is submitted, the page is reloaded. At this point, if

Question: We have a form that uses an ASP file to post results in Access 97. It works fine on my computer using Microsoft Personal Web Server, but will not

Question: How can I publish information from a database to a Web page? Answer: Microsoft’s Active Server Pages (ASP) makes it a snap to publish information from a database onto

Question: What do you suggest using as far as WebClasses versus Active Server Pages (ASP) is concerned? It appears that WebClasses do everything ASP can do, and are faster. Answer:

HTML META command can be used to instruct the browser to wait specified seconds and then load the web page. This is the code, which can be used to accomplish

You should always try to take advantage of the features in SQL Server to automatically maintain the integrity of data. The CREATE TABLE statement supports data integrity. You can specify

While designing the database for your application, you should always create user defined data types for columns across the database. User-defined data types ensure consistency of column definitions across the

Here is a simple way to make your COM object noncreatable. You can change the attributes of an ATL-based COM object so that the automation client cannot directly create the

Question: How do you set a Visual FoxPro class or array as the value of a property of another VFP class? It appears that if you add a property to

Question: What does “BLOB” stand for? What is a BLOB datatype? Answer: BLOB is a binary large object. Binary files hold stuff like pictures and audio files that get stored

Question: Is there a way to change the background color of certain table cells in Netscape? I know Internet Explorer gives you that capability, but I can’t seem to figure

Question: In what order are the clauses executed when resolving an SQL SELECT statement? Does a DBMS first examine the FROM clause to create an intermediate result, or does it

When you are placing controls on a form at design time and wish to edit one of its properties, the quickest way to switch to the Property window is pressing

Often your user interface includes fields whose contents mutually depends on other fields. A typical example is when you deal with conversions from one measurement unit to another. Let’s say

A few API calls require that you pass one or more LARGE_INTEGER arguments. These are 64-bit integer values, defined as follows: Type LARGE_INTEGER lowpart As Long ‘ lower 32-bit value

In many cases you may want to call an API function, but you aren’t sure whether the Windows version the application is running on supports that particular function.The easiest way

There are many different ways to delete all the items in a collection, but some of them are much faster than the others. Let’s start with a collection that holds