Access: Commands

Keywords: Access
Switch between Access app and VBA code: ALT + F11

Access: Connect to SQL

Keywords: Access
  1. Open Access and click the "Tables" tab.
  2. Right click in the white space.
  3. Click "Link Tables".
  4. In the "Files of Type" box click on "ODBC databases" (last item in list).
  5. Click the "System DSN" or "Machine Data Source" Tab at the top.
  6. Find your DSN.
  7. Double click it and Key in the Same Login and password.


Keywords: Acrobat, Distiller, edit text
For small text corrections: select Tools > Advanced Editing > Touchup Text Tool. Then select the 
text to correct, and type over it. Note that it is for "touch ups" and not for adding whole new 
lines of text.

If you receive the error "All or part of the selection has no available system fonts...", you can select the text,
click 'Properties' and change the font on the 'Text' tab.


Keywords: DataStream, Infor, asset management
An Infor product which provides users a powerful enterprise asset management solution with all of the features needed to manage critical functions such as work requests, purchasing, inventory and preventive maintenance.

DOS: Merge Files

Keywords: DOS, merge, files
type *.asp > test.txt

Paste clipboard contents...

right click on cursor and select paste (can just right click in KornShell)


Keywords: Elite, law firm

Law firms use Elite Enterprise for financial management, practice management, business development, and business intelligence.

Exchange: Relay

Keywords: email, Exchange, relay

By default Exchange 2003 doesn't allow relays from unknown machines. You'll need to change the Relay settings on the Exchange server - adding the IP address of the new server as an allowed relay machine. You can find the dialog by doing the following:
  1. Click Start, click All Programs, click Microsoft Exchange, and then click System Manager
  2. Expand Servers, expand Servername, expand Protocols, and then expand SMTP
  3. Right-click Default SMTP Virtual Server and then click Properties
  4. Click the Access tab
  5. Click the Relay button at the bottom

Filemaker: Migrate to SQL

Keywords: Filemaker, FmPro, migrate

Migrate FileMaker Pro databases to SQL, Oracle...


FmPro Migrator:


Keywords: Firebug, Firefox
Firebug integrates with Firefox to put a wealth of web development tools at your fingertips while you browse. You can edit, debug, and monitor CSS, HTML, and JavaScript live in any web page.

Google Chrome: Debug

Keywords: Google, Chrome, debug window

Java: Applet

Keywords: Java, applet
import java.applet.*;
import java.awt.*;

 * The HelloWorld class implements an applet that
 * simply displays "Hello World!".
public class HelloWorld extends Applet {
    public void paint(Graphics g) {
        String msg = "Hello World!";
        g.drawString(msg, 50, 25);

<applet code="HelloWorld.class" width="150" height="25" VIEWASTEXT>>

Java: Applet with Parameter

Keywords: Java, applet, parameter
import java.applet.*;
import java.awt.*;

 * The MsgBody class implements an applet that
 * displays a param value.
public class MsgBody extends Applet {
	String msg;

	public void init() {
		msg = getParameter("msg");

    public void paint(Graphics g) {
    	g.drawString(msg, 50, 25);

<applet code="MsgBody.class" width="150" height="25" VIEWASTEXT>
	<param name="msg" value="Howdy there!">

MAC: Querystring

Keywords: MAC, querystring


Keywords: GIS, MapGuide, Autodesk
Autodesk MapGuideĀ® 6.5 software helps you develop, manage, and distribute GIS and design applications on the Internet or your intranet, broadening your access to mission-critical geospatial and digital design data.


Keywords: Maximo, asset management

Maximo is a strategic asset and service management system that runs on a number of databases including Oracle, SQL Server and IBM DB2. It is used by a wide variety of organizations ranging from municipal and county governments, to corporations to government contractors. MRO, the provider of Maximo, was acquired by IBM in August 2006.

NDoc / VBCommenter / Sandcastle

Keywords: NDoc, VBCommenter, Sandcastle, .Net, documentation
NDoc allows you to generate code documentation from your code comments (.Net 1.x only) --

Use NDoc in combination with VBCommenter --

If you are using .Net 2.0, use Sandcastle --,

More Info:,

Office: Excel: Calc

Keywords: Office, Excel, calculate
MID($A2,1,(SEARCH(" ",A2,1)))

Office: Excel: Macro

Keywords: Office, Excel, Macro
Sub one()
    Dim original, name, streetnum, street, city, state, zip, phone, address
    Dim AddressArray
    original = ActiveCell.Value
    While Len(original) > 0
            AddressArray = Split(original, ",")
            name = AddressArray(0)
            address = AddressArray(1)
            city = AddressArray(2)
            state = AddressArray(3)
            zip = AddressArray(4)
            phone = AddressArray(5)
            ActiveCell.Value = original
            ActiveCell.Offset(0, 1).Value = name
            ActiveCell.Offset(0, 2).Value = address
            ActiveCell.Offset(0, 3).Value = city
            ActiveCell.Offset(0, 4).Value = state
            ActiveCell.Offset(0, 5).Value = zip
            ActiveCell.Offset(0, 6).Value = phone
            ActiveCell.Offset(1, 0).Activate
            original = ActiveCell.Value
End Sub

Office: Word: Disable Spellcheck

Keywords: Office, Word, disable spellcheck
Tools > Options > Spelling & Grammar tab > Uncheck "Check spelling as you type" 
and uncheck "Check grammar as you type" > Ok.

Oracle: Basics

Keywords: Oracle
-- View
Database / Schema Browser

-- Edit Proc
-- 1.
right click on proc / Load In Procedure Editor / Load Head Only

-- 2.
right click on proc / Load In Procedure Editor / Load Body Only

Oracle: Bind Variables

Keywords: Oracle, In, bind variables
SELECT employee_id, first_name, 
FROM employees 
WHERE employee_id IN (:0,:1,:2)

Oracle: Combine Fields

Keywords: Oracle, combine fields, select
SELECT prgm_id ||' - '|| prgm_description AS "Program"
FROM programs

Oracle: Cursor: Proc

Keywords: Oracle, cursor, sp, stored proc



		nTestSeqNum := nTestSeqNum + 1;

		INSERT into 12B_inv (inv_num, inv_num_ver, bill_cust_id)
		VALUES (9, 0, 'A');



Oracle: Cursor: Spec

Keywords: Oracle, cursor
	WHERE cust_id IN
	(SELECT cust_id
	FROM 12B.12B_cust_accting)
	ORDER BY cust_id;


Oracle: Dates

Keywords: Oracle, dates
SELECT to_date('20081025','yyyy/mm/dd')

Oracle: DUAL Table

Keywords: Oracle, DUAL
dual is a table which is created by oracle along with the data dictionary. It consists of exactly one column whose name is dummy and one record. The value of that record is X. As dual contains exactly one row, it is guaranteed to return exactly one row in select statements. Therefor, dual is the prefered table to select a pseudo column such as sysdate... select sysdate from dual

Oracle: NVL Function

Keywords: Oracle, NVL, NULL
-- In Oracle/PLSQL, the NVL function lets you substitute a value when a null value is encountered.
NVL( string1, replace_with )

Oracle: Return Parameter

Keywords: Oracle, return parameter




' VB.Net 2.0 Code
Public Function TIER1_VOLUMES_GET(ByVal BILL_CUST_ID As String, _
                                  ByVal BEGIN_PERIOD As Integer, _
                                  ByVal END_PERIOD As Integer) As String
	Dim BEGIN_PERIODVal As Object = OracleClient.OracleNumber.Null
	Dim END_PERIODVal As Object = OracleClient.OracleNumber.Null
	Dim BILL_CUST_IDVal As Object = OracleClient.OracleString.Null
	Dim f_sReturn As String = String.Empty

	If Not BILL_CUST_ID Is Nothing Then
	End If
	Using TempConnection As New OracleClient.OracleConnection(Me.Connection.ConnectionString)
		Dim TempCommand As New OracleClient.OracleCommand("12B_INVOICE.PO_TIER1_VOLUMES_GET", TempConnection)

		TempCommand.CommandType = CommandType.StoredProcedure

		TempCommand.Parameters.Add(New OracleClient.OracleParameter("p_BEGIN_PERIOD", BEGIN_PERIODVal))
		TempCommand.Parameters.Add(New OracleClient.OracleParameter("p_END_PERIOD", END_PERIODVal))
		TempCommand.Parameters.Add(New OracleClient.OracleParameter("p_BILL_CUST_ID", BILL_CUST_IDVal))
		TempCommand.Parameters.Add(New OracleClient.OracleParameter("p_RESULT", _
			OracleClient.OracleType.Number)).Direction = ParameterDirection.Output



		f_sReturn = TempCommand.Parameters("p_RESULT").Value.ToString
	End Using

	Return f_sReturn
End Function


Keywords: Perl
- 2 ActivePerl versions: & (Choose 

- 2 Windows Installs: AS Package & MSI (choose MSI) 

Photoshop: Circle

Keywords: Photoshop, circle
  1. Create a cirlce by using the Elliptial Marque Tool (hold shift key)
  2. edit > stroke

Photoshop: Fade

Keywords: Photoshop, fade
  1. CREATE two layers; one containing a person (no colored background), one conating back color such as orange
  2. RIGHT CLICK on Layer 1 (photo of person), SELECT Layer Options
  3. Under Opacity, change it to 50% instead of 100%

Photoshop: Fade: Gradient

Keywords: Photoshop, fade, gradient
  1. Select the layer.
  2. On left palette select gradient tool.
  3. On top left you will have Gradient Tool properties. Select "linear gradient" if it is not default.
  4. Make sure that your foreground color is set to the color to which you wish it to fade. In this case it is white.
  5. Select a point on your image, click, hold and drag your mouse in the direction OPOSITE to which it should fade.

Photoshop: Inverse

Keywords: Photoshop, inverse
image > adjust > invert


Keywords: Sharepoint
A browser-based collaboration and document management platform from Microsoft. It can be used to host web sites that access shared workspaces and documents, as well as specialized applications like wikis and blogs from a browser.

SQL Server Reporting Services

Keywords: SQL Server Reporting Services, reports

SQL Server Reporting Services is a comprehensive, server-based solution that enables the creation, management, and delivery of both traditional, paper-oriented reports and interactive, Web-based reports. An integrated part of the Microsoft Business Intelligence framework, Reporting Services combines the data management capabilities of SQL Server and Microsoft Windows Server with familiar and powerful Microsoft Office System applications to deliver real-time information to support daily operations and drive decisions.


Keywords: VB6, DLL
' Active X DLL
Public Function Test() As Boolean
	Dim x As Integer
	x = 5
	Debug.Print (x)
	Test = True
End Function

' Run in command window
Set objTest = new Class1
call objTest.Test

' Create dll
- File/Make Project1.dll
- Project/Properties/General Tab - chk Unatended execution
- Project/Properties/General Tab - chk Retained In Memory
- Project/Properties/Make Tab - chk Auto Increment Version Number
- Project/Properties/Compile Tab - clk Advanced Optimizations - chck All

' Add To SourceSafe
- Tools/Source Safe/Add Project To Source Safe

' Run with ASP 3.0
Dim objProject1 : Set objProject1 = Server.CreateObject("Project1.Class1")
f_bRet = objProject1.Test()
Set objProject1 = Nothing


Keywords: VB6, exe
' Standard EXE

Private Sub Command1_Click()
	Dim x As Integer
	x = 5

	MsgBox (x)
End Sub

VB6: Goto

Keywords: vb6, goto, error handling, on error, resume next

Enables the error-handling routine that starts at the line specified in the required line argument. The line argument is any line label or line number. If a run-time error occurs, control branches to the specified line, making the error handler active. The specified line must be in the same procedure as the On Error statement, or a compile-time error will occur.

GoTo 0
Disables enabled error handler in the current procedure and resets it to Nothing.

GoTo -1
Disables enabled exception in the current procedure and resets it to Nothing.

Resume Next
Specifies that when a run-time error occurs, control goes to the statement immediately following the statement where the error occurred, and execution continues from that point. Use this form rather than On Error GoTo when accessing objects.

On Error GoTo Handler   
    Throw New DivideByZeroException()
    If (TypeOf Err.GetException() Is DivideByZeroException) Then   
        ' Code for handling the error is entered here.   
    End If
Keywords: vbcrlf 
vbCrLf stands for "Carriage return, Line feed".
Keywords: vbcrlf 
vbCrLf stands for "Carriage return, Line feed".

VB6: Hotkeys

Keywords: VB6, hotkeys
- F5 = run
- CTRL/F9 = jump, skip when run
- SHIFT/F8 = skip function
- SHIFT/F9 = quick watch (see values)
- SHIFT/F2 = set cursor in method call, jump to method
- CTRL/SHIFT/F9 = Remove all breakpoints
- CTRL/SHIFT/F8 = Jump out of function

VB6: Register DLL

Keywords: VB6, register dll

When registering the dll's use the following command...
regsvr32 mydll.dll

(make sure you are in the directory where the dll is and needs to be registered)

regsvr32.exe /s dll name

Windows: Start Up: Remove Program

Keywords: start up, Windows, remove program
Here are the steps to remove a program from StartUp...

Go to Start > Run and type (without quotes) "msconfig" [enter]. This brings up the System Configuration Utility. Look on the Startup tab and find all entries relating to MusciMatch (Music MAtchbox). Uncheck the boxes next to the names, Apply and OK out. You don't need to restart immediately, but the next time you do you'll get a dialog saying you've used the Utility. Just tick the box that says in effect, "don't bother me about this again".

This should stop everything to do with MusicMatch Jukebox from starting with Windows and you won't get the ShellIconHiddenWindow any more.