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

To rename a file, use the standard function rename() (declared in ). This function takes two arguments of type const char *, the first of which is the old name

The standard function remove() deletes a file. It takes one argument of type const char * which is the name of the file to be deleted. You can provide a

Question: How can I make a function to return and display the maximum number in the following array: int my_array[]={10,3,35,101,65,100}; Answer: First, sort the array. Then display the last element

Question: I understand that most of the time, new and malloc may use the same allocation routines, but does that necessarily mean new calls malloc? I am asking because I

Question: I have data in a Vector and need to sort it before displaying iton the screen; how do I do this? Answer: The Java 2 Collections Framework provides a

Question: What is the advantage of declaring a variable as a superclass referenceand then pointing that variable to an instance of a subclass? Theway I see it, I can achieve

Question: Can RMIC make stubs for inner classes? When I tryrmic packagename.OuterClassName$InnerClassName, it doesn’t work. Answer: Yes, RMIC can make stubs for inner classes. However, you must use thefully qualified

Question: Is there a way to access the call stack debugging information from the code? I would like to print the call stack inside a function, each time it is

This repair and compact also backs up the Access MDB. Function ValidateMdb(MDB As String) As Boolean This function repairs, compacts, and backs up a database fileand deletes stray LDB (locking

Oracle 8i introduces the concept of temp tables. This feature long since enjoyed by SQL Server developers enables data to be visible on a Session orTransaction basis. To create an