Question: I am running an ISP. Many of our clients want Web hosting along with their own email addresses. When setting up Exchange on one server that is hosting multiple

Question: Our CEO has three Personal Assistants who access his Mail and Calendar Items. He does not anyone else to be able to book a meeting directly. How can he

Question: Do you know of any app or configuration within Outlook 2000 that can check a user`s Exchange mailbox without having Outlook itself open? Answer: Sorry, no. There are at

Question: How do I have deleted messages go into the bit bucket instead of the Deleted folder? Answer: You didn’t indicate what version of Outlook you’re running, but the Outlook

Question: How do I call an application made in VB from 4GL? Answer: I’m not a 4GL user, but I believe there is a “system” command that will allow you

Question: Is it normal for items to remain in my mailbox resource even after I retrieve all my messages from the server on Exchange 5.5? Answer: Your mailbox “items” include

Question: Once end users have created contacts, how do they export them to their home computers or laptops? Answer: I assume you’re looking for a simple—if inelegant—way to just “floppy

‘ Validate attributes of Phone data’ Returns True if valid, False if invalid” Also returns the phone in formatted fashion (USA format).’ Will convert alphabetics to numeric”Example:’ If IsValidPhoneField(Value:=”3034414444″, ReformattedPhone:=strNewPhone,’

‘ Validate a credit card numbers’ Returns True if valid, False if invalid” Example:’ If IsValidCreditCardNumber(Value:=”1234-123456-12345″, IsRequired:=True)Function IsValidCreditCardNumber(Value As Variant, Optional ByVal IsRequired As _ Boolean = True) As Boolean

‘***********************************************************’* Module Name: MSExcel’* Author: Steve Miller’* Date: 11/22/98’* Description: Encapsulates and eases the chore of writing to an Excel ‘ spreadsheet.’*’* IMPORTANT: requires that you have a reference to

For reporting, many times you need to figure out what date last week began and ended. Use the code below to figure that out: Dim vntBegin As variantDim vntEnd As

Ever wonder how to send email that looks like a web page? Here is how you do it. Note: You must have CDO for NT referenced for this to work.

Sending emails via code used to be cool, but now it is a necessity. Below is code to send email via CDO. If the CDO call fails, it will send

Enum psDateTypes AnyValidDate ‘Allows any valid date to be entered PastDate ‘Only allows past dates (before today) to be entered FutureDate ‘Only allows future dates (after today) to be entered

‘ Validates attributes of the SSN’ Returns True if valid, False if invalid”Example:’ If IsValidSSN(Value:=”333-44-3333″, IsRequired:=True) then …Function IsValidSSN(ByRef Value As String, Optional ByVal IsRequired As Boolean _ = True)

When creating an installation package that determines what files must be installed, use the Visual Studio 6.0 Dependency Walker Utility. This utility comes with Visual Studio and can be found

When you deal with unknown return values or variant variables whose types might be unknown, you may not know whether the value of the variable is an EMPTY string or

The array subscript operator, [], has a higher precedence than the pointer dereference operator, *. Therefore, the following snippet declares an array of 10 pointers to char, not a pointer

Question: How do I create a stored procedure that will construct and execute a query from its parameters? At the heart I’d imagine something like this, for simplicity’s sake: declare

Question: I have a database with a DateTime field of the following structure 1974-01-18T00:00:00′. How do I query it so that I can extract the dates with a particular day

Question: How do I create a text field of greater than 8,000 characters (in v7.0)? I attempted to use the “text” data type, but my code returned an error saying

Question: I’m trying to store text that’s in an RTF format using the TextRTF property of VB’s RichTextBox control. What type of field do I have to use in my

Question: I have two similar tables with monthly data: one holds current year data and the other holds prior year data. How do I combine them to create a rolling

Question: How do I convert a number that represents a date into a date field? The number’s format is CCYYMMDD. Answer: Fortunately, the format of your numeric value doesn’t need

Const INTERNET_OPEN_TYPE_PRECONFIG = 0Const INTERNET_FLAG_EXISTING_CONNECT = &H20000000Private Declare Function InternetOpen Lib “wininet.dll” Alias “InternetOpenA” _ (ByVal lpszAgent As String, ByVal dwAccessType As Long, _ ByVal lpszProxyName As String, ByVal lpszProxyBypass

Question: Can I auto start full text index? Answer: Although Enterprise Manager doesn’t provide the option, you can set this service to start automatically by using the services icon in

Question: Is there a non-platform-specific SQL way of determining what data type a given field is? Answer: That information is specific to each database. Every product stores its meta data

Question: Can I use a user-defined data type when defining a temporary table in a stored procedure? Answer: You can use user-defined data types in temporary tables, but remember one