Here is a function to format phone numbers. I picked it up from here: http://www.freevbcode.com/ShowCode.asp?ID=1968 ‘Takes any entered phone number and returns it in ###-#### format‘or (###) ###-#### Public Function FormatPhoneNumber(ByVal sNumToBeFormatted As _ String) As String Dim iNumberLength As Integer ‘Used for the Phone Number length ‘Trim any leading and trailing spaces sNumToBeFormatted = […]
matt
Ways to Still Use IE6
Some users of IE7 have difficulty logging in to various portal websites with IE7. Here are a couple of options to continue to use IE6. 1. Here is a link that installs an IE6 emulator. It functions for exactly one session and then reverts to IE7. http://go.microsoft.com/fwlink/?LinkID=70356 It was found it on nVidia’a partner website. They […]
IE7 Tabbed Browsing
Another comment about IE7 – I use SHIFT when clicking a hyper link to open a new window a lot. At times I get up to 20 open windows. To open a new TABBED window I now hold down the CTRL key when clicking a hyper link. The CTRL-TAB keys work like ALT-TAB to cycle through […]
FTP Not supported in IE7
I’ve been using IE7 for a couple of days now. I just ran into a feature I used in IE6 that isn’t in IE7. In IE6 I’ve created hyperlinks that will open up an FTP site and automatically log me in. The current version of IE7 does not support FTP. That’s one way to be […]
How to run client side javascript on a server control
Here is some code to run a javascript function on the client side when a value changes in a drop down box. In this case I have a list of dates populating a drop down box. When the date changes the value of a DIV section changes to a corresponding end date. In the appSetting […]
How to send an email by authenticating with any mail server
If you want to send an email from an application that might not be on a server that allows relaying you can use the System.Net.NetworkCredential. Just add your account login and password and your email will route through the remote server. Dim sTo As String = “someone@someemail.com“ Dim sFrom As String = “me@myemail.com“ Dim […]
Network Speed Test
How fast is your Internet connection? Here’s mine from my server’s co-location facility: Run a speed test yourself and let me know your results.
Restore Database and Database User
When restoring an SQL Server 2005 database from a different database instance the database login will be orphaned. Use this SQL script to fix the orphaned login. sp_change_users_login ‘Auto_Fix’, ‘user’, NULL, ‘password’ Actual syntax:sp_change_users_login [ @Action = ] ‘action’ [ , [ @UserNamePattern = ] ‘user’ ] [ , [ @LoginName = ] ‘login’ […]
PHP 5 on Windows 2003 Server (IIS)
Here are my notes on setting up PHP 5.1.6 on a Windows 2003 server (SBS). Must have “c:/php/” in system PATH environment variables (must reboot server when changing). In IIS under Web Service Extentions must have c:\php\php5isapi.dll Enabled. In IIS under the default web site (and particular web site to use PHP), configure the Application extention […]
Background color change with roll over
Use this code to cause a row’s background color to change with a mouse over: <tr style=”background-color: #F4F9FF;” onmouseover=”this.style.backgroundColor=’#C1D0E4′;” onmouseout=”this.style.backgroundColor=’#F4F9FF’;”> This works in IE and FireFox. Here is an example: http://www.thehousedesigners.com/adkit/