Question: If I have created a view from two tables that happen to have a similar column name (e.g., name) : CREATE VIEW team AS SELECT p.name, p.age, t.name, t.city

Question: I have given the autoforward rule from Inbox Assistance to an internal ID (Say X) as well as two outside ID’s (Hotmail & usa.net). But the forwarding is not

Question: Does AutoAttachment work only with certain versions of Outlook?I have Outlook 97 and it doesn’t have Tools/Macro. :-( Answer: Yes, the VBA capabilities were added in Outlook 2000. Sorry.

Question: I have Outlook 2000 set up to talk to an Exchange Server, and have added my POP3 email account to Outlook’s profile. How can I compose a new message

Question: Can I automatically suspend the Exchange Server (i.e., programming it to shut down) so that I can take a backup? I am using ARCserver to back up the server.

Question: How can I delete calendar items that are a year old? Answer: I assume you’re looking to delete calendar items older than a year. The easiest way to do

Question: How do I pass text that was entered into a text box on a WAP page/card to an ASP page? Answer: Be sure that you are declaring and passing

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