Question: How do I set up a shared calendar, or at least public access to other people’s private calendar, in a network that uses Outlook 2000 and Windows NT server

Question: When I pass a string containing an embedded apostrophe in a query to SQL Server, it sees the apostrophe as an end-of-string marker. Example: “Select * from Members Where

Question: Can I pass ADO objects like Command and Recordset to an ActiveX DLL (acting as a middle layer) so that it automatically fills the data in them and I

Question: I am aware of the recommended approach to developing three-tier systems?for example, presentation layer to business objects to data objects. Say I have a system that has a data

Unlike regular forms, forms don’t expose the MinButton and MaxButton properties and these buttons are always displayed. You can suppress these buttons using the following code: Private Declare Function SetWindowLong

The CommonDialog control doesn’t provide any direct way to decide where a common dialog appears on the screen. In all cases, in fact, the control tries to display the common

The most intuitive way to append a string to the current contents of a TextBox is through the & string operator, as in: Text1.Text = Text1.Text & “more text” However,

As explained in another tip in this TipBank, users can peek at the contents of password-protected TextBox controls with a simple Spy-like program, or even with a VB program plus

Visual Basic lacks of the capability to display a short description of the menu command being highlighted with the mouse or the keyboard, a feature that all professional applications should

When the user clicks on an iconized (minimized) form in the taskbar, Windows sends that form a WM_QUERYOPEN message, and inspects the value returned to the operating system. If this

You’ve taken the trouble to write a Java applet, so you naturally want everyone to see it. Unfortunately, there are some viewers that still don’t have a Java-capable browser or

The JPasswordField included in Swing exhibits a strange behavior?it moves the caret to the right as far as the width of the character you already typed. The problem is that

You should always prefer to cache commonly used select lists in the Application object. In a typical Web application, you make a database server trip to get to the list.

Browsers Targeted: Internet Explorer 4+ You can retrieve any component of a date (either as a string, a hash-delimited date expression, or a date object) with the DatePart() function in

Question: Why do certain things like tables and frames work fine with Internet Explorer but not with Netscape? Answer: There are many differences in the way the two major browsers

Question: How can I retrieve a file’s properties? Either using an API call or a VB Control (i.e. version information)? Answer: To retrieve the file properties displayed on the property

Question: We have several applications developed in VB. What are the best alternatives for making these applications Web-enabled, and what are the advantages and problems associated with them. Answer: If

Browsers Targeted: Internet Explorer 4+ The SrcElement DOM object is generated any time that an event is called, and it contains the element that called the event in the first

If you’re looking for a “house style” of naming convention, you can adopt the one used in Standard C++. It uses all lowercase letters for identifiers, and underscores as word

Can you tell what the following declaration means? void (*p[10]) (void (*)() ); Only few programmers can tell that p is an “array of 10 pointers to a function returning

The C99 standard defines a new version of the function sprintf(), namely snprintf(), with the following prototype: int snprintf(char * restrict s, size_t n, const char * restrict format, …);

Every compiler has a tokenizer, which is a component that parses a source file into distinct tokens (keywords, operators, identifiers etc.). One of the tokenizer’s rules is called “maximal munch”,

One of the new features in the recently approved C standard C99, is the restrict pointer qualifier. This qualifier can be applied to a data pointer to indicate that, during

You can view a list of the processes currently running on your server by executing the sp_who system stored procedure. You can also view a list of active processes by

Browsers Targeted: Internet Explorer 4+ If you want to find out the number of days, weeks, months, etc. between two dates, you can take advantage of the VBScript 5.0 DateDiff()

Question: Can I pass a date with the query string? Will the slashes cause a problem in this example? testing.asp?date=03/01/00 Answer: Yes they will. You will need to “encode” the

Browsers Targeted: Internet Explorer 5 Tree structures appear quite often over the ‘Net, and they are becoming especially prominent in the face of the emergence of XML. Fortunately, tree structures

The following example program prints out both the total and free memory sizes, allocates a chunk of memory, and then prints the memory sizes again. If the initial size of