The DatePart() function can return the number of days from the beginning of the current year, but there is no VB built-in function that returns the number of days left

Private Declare Function GetLongPathName Lib “kernel32” Alias _ “GetLongPathNameA” (ByVal lpszShortPath As String, _ ByVal lpszLongPath As String, ByVal cchBuffer As Long) As LongConst MAX_PATH = 260′ Convert a short

‘ convert a date value into a string in the format’ YY years, MM months, DD days, HH hours, MM minutes, SS.HH seconds)’ you can also opt for time short

Question: I have two columns in a table called “bak”: distance, and trig. The distance value is equal to 1/trig. When I perform the following query: update bakset distance =

Question: How can I get the number of records returned by a query without cycling through all the records and counting each one? Answer: Have you tried SELECT COUNT(*) FROM

Question: How can I get Exchange to forward e-mail to an AOL or ATT account automatically? We have traveling users who have AOL or ATT accounts and would like all

Question: I am a student. Is there a way to load a database into Oracle to run my exercises? Answer: I’m not sure I can help you because there’s more

Question: I need your assistance to solve the following: I am using an RDO connection to connect to a SQL 7.0 database, and I am using the server-side cursor technique

Question: How do I merge two values from separate fields using SQL? An example would be taking the LastName field and placing it before the FirstName field like this: “LastName,

Question: How do I do a “group by” SQL statement? I want to return all rows and columns with ** records. Here is the data sample: columnA columnB columnCAAA 2334

Question: I am having trouble getting the following type of join to work. I have three tables: Application, College_hist, and School_Info. Application has student ID numbers that identify the person

Question: I have upgraded from Outlook Express to Outlook 98. Previously I was able to leave messages to a particular e-mail recipient on the server. With Outlook 98 I no

Question: I need to know how to write SQL to ask for a date range and run the query on that range. Can you help me? Answer: I think it

Question: I have a SQL database on our production NT server and need to move the database to another NT server. I used the Database/object transfer in Enterprise Manager to

Question: I am with a large Fortune 500 company looking for a training management solution to produce CBT courses, organize, and report on skill-based courses and instructor-led courses on our

Question: I just installed SQL 7 on my server and have an Access database that contains a lot of information. How do I create a SQL database? Also, is there

Question: What is the difference between two dates, date1 and date2, when date2 is in the next record? Answer: Use this code: select datediff(laterone.date1, earlierone.date1) from table earlierone, table lateronewhere

Question: From a previous version of SQL Server 7.0 I saved only contract_Data.MDF and contract_Log.LDF. How can I insert this file in my current SQL Server 7.0? Answer: Here are

You can improve performance of your ADO applications by properly selecting the Cursor and Lock Types while opening the recordsets. Cursor Type indicates the type of the cursor the provider

You can use Clone() method of ADODB.Recordset object to create a duplicate recordset object from an existing recordset object. An important advantage of this method is that instead of creating

You can initialize variables of fundamental types by invoking their constructor: int n = int(); /* zero initialized */ char c = char(); /* ditto */ short *ps = new

As ASP programmers, we use the Request variable to retrieve information from our Web users. In a previous Web tip I showed how we could extract the values from a

Sun changed swing naming convention from com.sun.java.swing to javax.swing.This created a bit of confusion, but you can exploit it to see what versionof swing is installed in a browser, or

To compare dates in Java you have two choices:1. Create java.util.Date objects based on the dates that you’d like tocompare. use “public long getTime()” method of each date object to

There are many ways to help you manipulate your way through the VID MDI child code windows. Here are a few shortcut keys that can help. Ctrl-Up Arrow: Scroll up

The following site offers a slightly outdated version the C++ standard free of charge: ftp://ftp.research.att.com/dist/c++std/WP/CD2/. The differences between this version and the latest version of the standard are mostly editorials

XML4C is a validating XML parser written in C++. It enables an application to read and write XML data. Two shared libraries provide classes for parsing, generating, manipulating, and validating

There are many special characters that must be encoded to be viewed in HTML. Examples of these are:& (&), ” ("), < (<), and > (>)It is easy to hardcode

You can use javax.swing.JTextPane to display simple HTML page. JTextPane jTxtPane = new JTextPane();JScrollPane jScrollPane = new JScrollPane();jScrollPane.getViewport().add(jTxtPane);try { URL url = new URL(“http://www.mysite.simplepage.html” ); jTxtPane.setPage(url);} catch (Exception e) {

One can use the dbcc memusage command in both SQL Server 6.5 and 7.0 to determine which databases are using the most of the server’s memory. You can run dbcc