Developer Downloads:

The following downloads are intended for personal and educational use.  If you intend to use one of the downloads for commercial purposes all we ask is that you  please give credit where credit is due and reference J Street Technology.

* Disclaimer: J Street Technology offers these downloads as is and does not assume any liability for bugs or problems with any of the code.  In addition, we do not provide technical support for these downloads.

  The Best of Both Worlds - Access MDBs and SQL Server

These are the slides that Armen presented to the Pacific Northwest Access Developers Group. This presentation gives an overview of how to use Microsoft MDBs to link to SQL Server databases efficiently. That way, you can get the power of SQL Server, while retaining all the techniques and code you have learned for Access MDBs! PowerPoint 2000, 36k.

  Data Dictionary Report Utility

Can't get the built-in Access database documentation tools to give you the simple report you want? Here's the answer. This utility documents all the tables and fields in your database, linked or local, including field descriptions! Access 2000, 44k.

  Converting Flat Files into a Relational Access Database

This is the PowerPoint slideshow that Armen Stein, President of J Street, presented to the KEGS Access SIG. It shows how to tackle the problem of converting old "flat" data (from Excel, text or wherever) to your relational Access tables. Includes a sample database showing the techniques mentioned in the slides. PowerPoint 2000, Access 2000, 820K.

  Access Security Basics

These are the PowerPoint slides that Armen Stein, President of J Street, presented to the Pacific Northwest Access User Group. It describes various ways that you can secure an Access database, with some common mistakes that developers often make and tips to avoid them. PowerPoint 95 or later, 534K.

  Report Selection Techniques

Example of a pop-up report selection criteria form. This technique is great for allowing the user to choose which records will appear on a report, without using parameter queries! Other report techniques are shown also.  Access 2000 database and PowerPoint slideshow, 372k.

  Cool Tools

A sampler of labor-saving code and cool usability enhancements. Includes QuickDate, a "Quicken-style" method of using keys to increment date fields by day, week, month and year, and some handy name and address concatenation functions. Comes with a form demonstrating most of the tools - look in the code for more! Access 2000, 48k.

  User Interface Guidelines

Also known as "Beauty Is Only Skin Deep, But It Gets You Asked To Dance!". It's our approach to designing consistent, professional-looking forms. Word, 64K.

  A Better Record Finder

A quick and easy way of allowing users to find a record on a continuous form. Much easier for your users than the dreaded "binoculars"! And easy for you to code - just add a few lines of VBA to your form. Access 2000, 73K.

  Customizable Reports

This is a great way to provide custom reports to your users without spending a lot of development time. Allows selection and ordering of report sections, with the ability to save the layouts for others to use. Includes an article in Word and a sample database, 388k.