Links to Downloads - a work in progress

How to use a ZIP for Geographical Positioning Demo
New
 Geographical Positioning using ZIP Codes

This database demonstrates a technique for taking the geographic centroid of a zip code and obtaining a list of all other zips whose geographic centroid falls within a specific radius. It uses a pair of classes, a clsZip (singular) and a clsZips (plural). ClsZip holds all of the information about a single zip code, clsZips holds a collection for storing every single instance of clsZip, code for reading the data out of a tblZips table to populate instances of clsZip, and code mathematical code for determining the distance between two latitude / longitude points, the geographic centroids of the zips.

The database has a form for entering a zip code and a radius. When you enter both, the code just automatically runs which iterates through the collection of clsZip instances, comparing the lat/long of each clsZip with the lat/long of the zip code you enter on the form. A list is created of zips within the radius you specify. The list of zips is displayed on the form, along with a sum of their populations and house hold counts.

Having all of the clsZip instances cached in a collection in clsZips makes the code to find all the matches using such a brute force method trivial.

John W. Colby
Colby Consulting>
www.ColbyConsulting.com

OpenArgs Demo
New
 The description of the Class that can be added into any form:

When a form is opened, an OpenArgs string can be passed to the form which contains data for the form to use. I decided to create a class system to allow any form to generically process that information, so that any form could instantly and easily use passed in OpenArgs. The OpenArgs need to be formatted in the following manner:

VarName1=VarValue1;VarName2=VarValue2;VarName3=VarValue3;

Given variable data passed in that format, clsOpenArgs will read the OpenArgs property of the form and parse the name/value for each variable passed in, storing the name / value in a child class clsOpenArg (singular).
It then stores each clsOpenArg instance in a collection.

In my implementation, the parent class clsOpenArgs (plural) can be passed a param telling it to expect to process form properties and as such looks up the VarName in the Properties collection of the form.
If found it sets the form.SomeProperty = the var value.

As an example, given the openargs string:

AllowEdits=True;AllowAdditions=False;AllowDeletions=False;0

clsOpenArgs tries to map AllowEdits to a form property. Since it succeeds it sets the form's AllowEdits property to True (the passed in value in this case). The developer does not need to read the OpenArg and set the form property, clsOpenArgs just does it.

clsOpenArgs also has a method that allows me to pass in an argument name and returns the argument value. This would be used for passing OpenArgs that will be manipulated by the form for other requirements.

"It works GREAT, and is an example of how a framework is built up over time as I needed functionality." quote from John Colby

John W. Colby
Colby Consulting>
www.ColbyConsulting.com

Drag and Drop (all new June 2003) from List members Darren Dick, Drew Wutka and
Stuart McLaughlin. This handy list box utility control allows you to drag and drop
content from list boxes etc. from one control to another.


BackEnd Upgrader (BEU)

TheBackEndUpgrader.doc 		Bryan Carbonnell, Reuben Cummings and Andy Lacey, from an original concept by Lembit Soobik. Thanks too to Hadyn Morgan. BEU gives you, the developer, the means to create a database of BE changes, testing them in your development environment then shipping them with your code so that they get applied in the live environment without any manual intervention.


C2DbShowusers.zip Displays the users in your database back ends - John Colby


MailDB.zip This is a demo of simple outgoing email without using MAPI. The code connects directly to the smtp server using sockets. The code can be used to send to multiple recipients with multiple attachments and can be used for bulk mailing. A simple form is included to demonstrate the code usage. - David Phelan


TreeViewTest.zip Arthur Fuller's TreeView example database.


Collision Check This function checks for a collision between two appointments with startdate/time and stopdate/time. - John Colby, Anita Smith, Lembit Soobik


VBErrorHandler is a wizard that allows you to insert error handler code into existing functions and subs. It will insert the 'OnError goto' statement, plus a 'Exit function' section and then below that, an error handler. The error handler can be a simple msgbox or a completely formed case statement. There is an installation doc in the zip, plus a write-up of using it. Glen Grubb, Seth Galitzer, John Colby