Oracle

• Returning an ADO recordset from PL/SQL using REF CURSORS - This document provides a step by step guide on how to return a recordset to your VB or ASP code using a REF CURSOR in an oracle stored procedure.
  Download MS Word Document (34k)

• AdVance2000: Technical Overview - a technical document explaining how to create Document Archive (search and retrieval) System using Oracle and VB.
  Download PDF Document (552k)

• ^NEW! CSV to SQL - a small VB application that I used to convert a load of flat file exports (pipe-delimited) from Access to Oracle compatible SQL INSERTS statements.
  Download Project code and example files - Zip (92k)

Office Automation

• Extract Text from an Office Document: I developed these functions as part of a document imaging project. The user can attach an office document to be uploaded. These functions were used to extract text from the documents so that they could be searched. (This code even supports MS Access Databases!)
  View the code

• Merge Multiple Word Documents: This code will take a list of selected word documents and merge them to create one new word document (keeping the original orientation of each document selected). This was created (as part of a project) for our administration department who needed to make new documents from a selection of pre-made templates.
  View the code

• Outlook 98/2000 Appointment Shifter: This outlook form can be sent as an email to your user base. It will allow them to enter a date range and the number of hours to shift their appointments (e.g. move all appointments between 1/3/00 and 31/3/00 one hour forward). This form did actually serve a purpose! It will probably be of no use to anyone else, except ro provide a look at outlook 98/2000 programming.
  Download the form (Zipped 5k)

• ^POP! Use Word As a Reporting Tool from VB: This code was developed so that Word could be used to create reports that needed a definate layout (and because I don't like Crystal Reports). It works by creating templates using variables within the word document. The code looks for specific variables in the template and replaces them with data.
  External Link (FreeVBCode.com)

Miscellaneous

• ^POP!Populate a FlexGrid from a recordset: This subroutine shows you how to easily and quickly populate a FlexGrid (SP4) using the data from a recordset. The example is taken from a Access project, but could be used in VB.
  Download Word Doc (zipped 4k)

• ^POP!TIF to PDF: This code is unsupported (and undocumented!) by Adobe, but works a treat. It will convert a TIF (or any file that acrobat supports) and convert it to PDF. You must have the full Adobe Acrobat product installed (I was using Acrobat 4).
  View the code

• Training Database: This is a little Microsoft Access application (updated Sep 2000) I quickly wrote for the training department where I work. It allows you to keep track of employees' training records. I never bothered to remove company logos etc. from this version. I figured you could do that yourself. :-)
  Download the database (Zipped 237k)