VB Functions for mm/dd/yyyy

Private Function getMonth(tmpDate As String) As Integer

    Dim tmpMonth As String

    Dim tmpMonthLoc As Integer

    tmpMonthLoc = InStr(1, tmpDate, "/")

    getMonth = Mid(tmpDate, 1, tmpMonthLoc - 1)

End Function

Private Function getDay(tmpDate As String) As Integer

    Dim tmpDay As String

    Dim tmpDayLoc As Integer

    tmpDayLoc = InStr(1, tmpDate, "/")

    getDay = Mid(tmpDate, tmpDayLoc + 1, Len(tmpDate) - 5 - tmpDayLoc)

End Function

Private Function getYear(tmpDate As String) As Integer

    getYear = Right$(tmpDate, 4)

End Function

Multi-Vitamin

I bought the Target brand Children's Gummy Multi-Vitamin.  They are delicious and $8 for 190.  I heart them.  My only struggle is not eating too many.

Rust Stain in Pool

I forgot to take the garden hose out of my pool and after about a week my pull had a orangish tint to it.  I told the pool guy and said to buy chewable Vitamin C tablets from Wal-mart and rub it on the stain.  If it works then it is a rust stain.  He was right!  I rubbed it on the stain and the first wipe it was clean as could be.  I dropped a tablets in the pool and they left 2ft clean circles.  I ended up buying 2lbs of some magic stuff to the whole pool instead of random spots.  I thought that was rather impressive.

Files still open on the Server

Disconnect sessions from a given machine

From the command prompt (Run->cmd)

NET SESSION \\ComputerName /DELETE

Comcast DVR like Tivo

The thing I don't like about the Comcast DVR is that it is not like Tivo in the fact that when you fast forward and hit play Tivo jumps back about 5 seconds and Comcast doesn't.  I came up with a workaround.  On comcast click fast forward twice then when you see the show hit the instant replay button (looks like a arrow going counter-clockwise).  Then presto you are lined up.

No need for Temporary Internet Files

We are in the days of High-speed internet.  We don't need to cache web pages.  We can almost just as quickly get a fresh copy from the internet.  Plus you don't have an issue with pages not showing the lastest data.  

So I say we change our Internet Options setting the Temporary Internet File storage to the minimum, which is normally 8Mb, and set "Check for newer versions of stored pages" to "Every time I visit the webpage".

To get to it in Internet Explorer(IE) click Tools, Internet Options, Browser History Settings.

Access "Access Denied"

Having trouble deleting files because Access Denied.  I just take the hard drive and put it in another computer and take ownership of the folder I need to get into.

Disable Simple File Sharing in Windows XP Professional

If you are using Windows XP Professional, you must disable Simple File Sharing. Open My Computer, Click Tools, Folder Options, View, at the bottom unclick Use Simple File Sharing.  By default, Windows XP Professional uses Simple File Sharing when it is not joined to a domain. For additional information about how to do this, click the following article number to view the article in the Microsoft Knowledge Base:

To take ownership of a file or a folder

How to take ownership of a file

You must have ownership of a protected file in order to access it. If another user has restricted access and you are the computer administrator, you can access the file by taking ownership. 

To take ownership of a file, follow these steps:

1. Right-click the file that you want to take ownership of, and then click Properties.
2. Click the Security tab, and then click OK on the Security message (if one appears).
3. Click Advanced, and then click the Owner tab.
4. In the Name list, click Administrator, or click the Administrators group, and then click OK. 
   
   The administrator or the administrators group now owns the file.

Found @ http://support.microsoft.com/kb/308421