Magazine
ELECTRIFIED ACCESS MAGAZINE

ISSUE #3                                                                     APR./MAY 1994

ABOUT ELECTRIFIED ACCESS MAGAZINE

FROM THE PUBLISHERS DESK

CONTENTS


ABOUT ELECTRIFIED ACCESS MAGAZINE

ELECTRIFIED ACCESS MAGAZINE is an "electronic" magazine.  It is a Shareware product.  It is not free.  If you enjoyed or found this issue of value, the Shareware price for this single issue is only $3.50.  Your support is necessary if you want us to continue to produce this magazine.

 SHAREWARE PAYMENT FORM


E.A.C. SHAREWARE PAYMENT FORM
E.A.M. SHAREWARE PAYMENT FORM

NAME: _______________________________

COMPANY NAME: ____________________________________

ADDRESS: ____________________________________________

CITY: __________________________

STATE: _________________________

ZIP: ____________________________

COUNTRY: ______________________

PHONE: _________________________

Where did you get issue #3? ___________________________________________

What you liked about issue #3? ________________________________________

__________________________________________________________________

__________________________________________________________________

__________________________________________________________________

What you did not like about issue #3? ____________________________________

___________________________________________________________________

___________________________________________________________________

___________________________________________________________________

Single issue Price is $3.50 per issue.

Arizona residents add 6.7 % sales tax.

Send check or money order drawn on a US Bank made payable to WELSH COMMUNICATIONS and send to the following address:

WELSH COMMUNICATIONS

16845 N. 29TH AVE. STE. 1-604

PHOENIX, AZ  85023


FROM THE PUBLISHERS DESK
FROM THE PUBLISHER'S DESK

By Don Welsh

I would like to take this opportunity to welcome all of the new readers of ELECTRIFIED ACCESS MAGAZINE. It is a Bi-Monthly electronic magazine devoted to covering the exploding MS ACCESS market. We have chosen to publish the magazine in Windows 3.1 Help format. Using this method we can provide a colorful magazine with hypertext, pop up graphics, searching and printing capabilities. The magazine features Reviews of commercial and Shareware ACCESS Add-ons, Data Base programming articles, Tips and Tricks, New ACCESS Products, Contests and more.

Are you tired of searching through many different magazines hoping to find an article or review relating to ACCESS? If you answered yes to this question then this magazine is for you!

We welcome your suggestions and comments on this magazine. We will be striving to improve the magazine with every issue. We can only accomplish that with your input.

Software Companies may send press releases and/or review copies of ACCESS related programs to the below address:

WELSH COMMUNICATIONS

16845 N. 29TH AVE. STE. 1-604

PHOENIX, AZ  85023

I can also be contacted

On Compuserve: 71224,1036

Or on America Online: WELCOMM

Publisher

Don Welsh

Associate Editor

Pam Johns

Design

Bill Hamilton

Programming

John Tredwell

Authors

Dave Johnston

Jon West

Bill Thomas

ELECTRIFIED ACCESS IS PUBLISHED SIX TIMES A YEAR AND IS COPYRIGHT (C) 1994 BY WELSH COMMUNICATIONS. ALL RIGHTS RESERVED. THIS ELECTRONIC MAGAZINE IS LICENSED "AS IS". WELSH COMMUNICATIONS MAKES NO WARRANTIES, EITHER EXPRESSED OR IMPLIED, WITH RESPECT TO THIS MAGAZINE, THE INFORMATION IT CONTAINS, ITS PERFORMANCE, QUALITY, OR FITNESS FOR ANY PARTICULAR PURPOSE. THE VIEWS EXPRESSED BY THE AUTHORS MAY OR MAY NOT BE THE SAME AS THOSE OF THE PUBLISHER OR WELSH COMMUNICATIONS.


CONTENTS

REVIEW: GRAPHIC TOOLS I

REVIEW: ACCESS BUSINESS FORMS LIBRARY

MINI-REVIEWS

ACCESS TIPS AND TRICKS

PRODUCT SHOWCASE


NEW ACCESS PRODUCTS
REVIEW: GRAPHIC TOOLS I

By

Jon West

GRAPHIC TOOLS I

LIST PRICE  $34.95

SERENGETI COMPANY

861-6TH AVE., STE. 510

SAN DIEGO, CA 92101

PHONE: 619-230-1536

Graphic Tools I is a collection of around 850 buttons that you can use in your Access applications. There is also a collection of custom Bitmap images that can be used as form backgrounds. Last but not least there are mini-applications which will add functionality and spruce up your Access applications interface.

Included in the buttons are a complete set of 3-D raised letter and numbers and a complete set of 3-D engraved letters and numbers. There are buttons in most every category that will spruce up your Access databases.

There are also instant install button panels that include source code. There are alphabet and numeric filter sets, VCR type controls and more.

Also include with GRAPHIC TOOLS I are bonus mini-applications with source code. These include a Cellular Phone, Task Timer, Post-It note field, Clipboard form, and a Slideshow manager for Splash Screens.

You will find many parts of this collection useful in improving your Access databases. My two complaints with this product is the manual needs improving and there needs to be an automatic installation program to install the files. Right now you have to install each file on the disk manually. This is quite a bit of work to expand 14 files.


REVIEW: ACCESS BUSINESS FORMS LIBRARY

By

Bill Thomas

Business Forms Library is a collection of 34 forms that are commonly used in business. Even a few personal use forms are included. Each of the forms has accompanying reports, macros, and tables. There are 5 main categories  of Forms. These are the categories and the forms in each.

ADMINISTRATIVE FORMS

Conference Room Scheduler

Customer Registration Form

Expense Form

PC Tracking Sheet

Seminar Registration

Telephone Message Form

Vendor Master File

BUSINESS FORMS

Bill of Lading

Cash Disbursements and Receipts

Check Requisition

Credit Application

Credit Reminder

Final Notice Form

Invoice

Past Due Form

Product Price List

Purchase Order

Receiving Report

Shipping Order

EMPLOYEE FORMS

Contributor Information Form

Employment Application Form

Job Listing Form

Personnel Record Form

Receipt of Resume Form

PERSONAL FORMS

Card & Gift Form

Household Inventory

Personal Name List

VideoTape Log

Wedding Planner

SALES FORMS

Commission Form

Quotation Form

Request For Quotation Form

Sales Order Form

Sales Prospect Form

You can use all of the forms as standalone mini applications or you can integrate them into your own applications. You can distribute individual forms from the library royalty free. All of the forms can be customized to your needs. These are great sample applications to get the new Access user up to speed. There are several advanced techniques that you can learn by examining these forms.

This product comes with excellent documentation. It is a spiral bound 113 page book. Every form is explained. You will learn quite a bit about Access by reading this manual and playing with the forms.

This is a highly recommended product. It will save you time if you need to create any of the types of forms included in the library. It is also a great Learning tool.

ACCESS BUSINESS FORMS LIBRARY

LIST PRICE  $79.95

CARY PRAGUE BOOKS AND SOFTWARE

60 KRAWSKI DRIVE

SOUTH WINDSOR, CT  06074

PHONE: 203-644-5891

TOLL FREE ORDERS ONLY: 800-277-3117


MINI-REVIEWS

Mini-Reviews are small  reviews of Shareware and public domain utilities, source code, reference files etc. These are great in the fact that they are good learning tools and you can stop re-inventing the wheel. They are usually smaller and do not warrant a full review in another section of this magazine.

COMPAC.ZIP

COMPACTER VERSION 2 can be used to Compact or Repair Access Databases without the need to run MSAccess.

CONTAC.ZIP

Personal/Business Contacts management database version 1.1 now contains new & improved search capabilities.  Manage all your business & personal phone calls.  Unlimited number of dated notes attached to each contact. Requires Access 1.1.

MOVIE.ZIP

This is a  database that keeps track of your home videos (movies) and you can add, edit, delete, search, and print the movie list in various ways

BUDGET.ZIP

Budgeting forms for Microsoft Access.  Full fledged monthly budgeting database.  You can define your own categories and items, and get up to date info on your budgeting.

ACCESSKB.ZIP

A huge windows help file containing Microsoft's Knowledge base for Access. The zip file is almost 1 meg in size. Contains Hints, Tips & Tricks, Questions and Answers on MS ACCESS. This is a must have file for anyone using Access!

These files are available in the Shareware libraries in the PRODUCT SHOWCASE  section of this magazine.

-OR-

Members can obtain the above files from THE ELECTRIFIED NETWORK at (602) 942-9405.


PRODUCT SHOWCASE

ACCESS SHAREWARE LIBRARY 1

ACCESS SHAREWARE LIBRARY 2

THE ELECTRIFIED NETWORK


ACCESS SHAREWARE LIBRARY 1

This library contains MS ACCESS Shareware, Freeware and Public Domain files. All of these files are specially picked with the ACCESS user and Developer in mind. You get plenty of actual Databases, Access utilities, On-line Help files, Source Code and more.  NOTE: SHAREWARE PROGRAMS MAY REQUIRE SEPARATE PAYMENT MADE DIRECTLY TO THE AUTHOR FOR CONTINUED USE.

4MEG.TXT

Suggestions for performance enhancement for machines with 4 megs of RAM.

ABCLIS.ZIP

Example database shows how to do list functions based on RecordSets (Dynasets and Snapshots).  Also shows various techniques for working with lists - lists dependent on other controls, using OnDblClick to add items to list, and more.

ACCESSKB.ZIP

A huge windows help file containing Microsoft's Knowledge base for Access. The zip file is almost 1 meg in size. Contains Hints, Tips & Tricks, Questions and Answers on MS ACCESS. This is a must have file for anyone using Access!

ACCINI.TXT

A Generic MSACCESS.INI file.

ACCPAC.ZIP

Access Database Packer - This utility is used to compact or repair your MS Access databases without having to actually run a copy of Access. This program requires VBRUN300.DLL.

ACCPAN.ZIP

This utility lets you maintain various settings in your MSACCESS.INI file, such as the SystemDB, the UtilityDB, and other add-in Wizards. You can also maintain a host of other settings, including those for the run-time module. You can "archive" sets of libraries & easily switch them in and out of action. This program requires VBRUN300.DLL.

ACCSRV.ZIP

A WinWord Template(ACC_SRVR.DOT) to Demo Microsoft Access as a DDE Server to Microsoft Word via WordBasic. The macro requests Access's supported DDE Topics and Items. The macro executes Access Macros and SQL Statements.  It also extracts Data and Fields from Tables and Queries.

ACINST.ZIP

"ACINST.zip" contains the Microsoft Access Self Study Instructor's Guide. Includes both Microsoft Word and WordPerfect formats.

ACSELF.ZIP

"ACSELF.zip" contains the Microsoft Access Self Study.  Microsoft Word and WordPerfect versions are included.

BDAYS.ZIP

BDAYS.ZIP includes the function ElapsedBDays(), which allows you to find the number of BUSINESS days between two supplied dates, as well as a form displaying its use.  This module also includes a database for listing Holidays which are to be EXCLUDED from the list of business days, allowing for a more accurate count. FREE WARE.

BOOKS.TXT

"BOOKS.txt" is an ascii file that contains information on books written for Microsoft Access that are now available or will be soon.

CALNDR.ZIP

A Free calendar form for use in your Access applications. Call the calendar function with any date and the appropriate month will be displayed. You can press a button on the day square and return the selected date to your application.

CATLOG.ZIP

An Access database which contains a list of all the files that can be found in the MSACCESS Forum. You can quickly search for files in a certain section or just browse all the files. The description information is available so that you can quickly identify the file that you are looking for.

CDLIB.ZIP

Sample data base for maintaining an audio CD library. Provides sample techniques. Freeware.

CENTER.ZIP

This example consists of extracted code from a MS sample database. There is no native way in Access to center a form for some unknown display.  The MS sample db orderentry used Windows calls to center a form. These are the just the extracted routines needed to center a form and how to use them.

CHGPRN.ZIP

This is a text file containing some sample code for changing certain printer settings.

CLPBRD.ZIP

This is an example Access database that will demonstrate an example of retrieving information from the clipboard programmatically.  It uses several Window API functions.

COMBO.ZIP

Two functions and a form demonstrating filling lists.  Works for List Boxes and Combo Boxes.  This example fills one Combo Box with table info. and another with the field info. from that table.

COUNTE.ZIP

A modified version of MS's Order Entry database Customers form showing an implementation of a record counter which mimics ACCESS's horizontal scroll bar. Allows entry of specific record numbers, just like the horizontal scroll bar, and adds a count of total records.  Macro and module included for incorporation into your application.

CUBSCO.ZIP

This database includes an example of validating a record on a form by making sure all fields have an entry. It is a sample database for keeping track of Cub Scout information.

CURREC.ZIP

This file contains information on moving the current record in a form to Word via DDE.

DB2.ZIP

How to get data from a previous record when the current record is an unsaved new record.

DBTIPS.ZIP

A Word for Windows document that gives the developer who is familiar with dBASE but new to Access information and guidance.  Some of the key differences between dBASE development and Access development are discussed here.

DDEOUT.TXT

Example of using Excel to send a macro name to Access via DDE. The macro checks a form which contains DDE links back to Excel to provide parameters to a query.

DIAL3.EXE

Self-extracting Archive. Add Phone Dialing capability to the PIM that ships with Access, or your other Access databases.  A simple routine that shows how to make the Windows API calls necessary to dial a phone.  V1.03.

DOMAIN.ZIP

This is a wizard that will guide you into creating a domain function for your query or form, (examples of domain functions are DLookUp, DSum, DAvg, etc.)

ERLIST.ZIP

This is a text file containing a list of Access Basic error messages sorted by error number.

EXESS.ZIP

An Excel macro which uses DDE to transfer some or all MS-ACCESS database records into a worksheet. MS-ACCESS is the DDE server.

FILTER.ZIP

The form frmSelect demonstrates a way to pinpoint a particular record by entering desired field values in combo boxes.  A parameterized query restricts both the form's dynaset and the values in the combos.

FIRST.ZIP

Form Design Tools, Menu Builder, Mac2Mod, and more in one .MDA.

FRMQRY.ZIP

This is an example of querying the underlying dynaset using a form and unboundields where the user can enter values for each and every field, or none at all to return all fields.  This example uses macros and queries to drive the process.

GALAXY.ZIP

A sample database that demonstrates a solution to relate multiple subforms (nesting only works 3 deep).

GRPINS.ZIP

Sample insurance prospect/client management system.  Demonstrates multiple subforms and use of queries to do most of the work.  Minimum use of macros and Access Basic code.

INSERT.ZIP

Example of how to let the user insert records in any desired order.

LABELS.ZIP

Sample database shows how to print multiple labels per record.  It also shows centering a form using code extracted from MS example (uses Win API).

LAUNCH.ZIP

This database includes an example of how you can insert new OLE objects programmatically.

LBSLCT.EXE

Self-extracting archive containing an article and also includes a database with the form and module described in the article. The article is in Word format.  A form created is one like those used in the MS Access Wizards where you select items from one list and place them into another list. The ">", ">>", "<", and "<<" buttons are used to move items from one list box to the other.

MEMBER.ZIP

Members is a sample application suitable for any organization that tracks memberships. It includes: user menu, configWizard, Tight Query, several many to many relationships and more.

MENU.ZIP

A wizard that will guide you to creating menus for your forms.

METER.ZIP

Database with a form and code to implement a progress meter which can be used to provide user's a graphical indication of a lengthy operation.  Includes sample code and docs. Free.

NOMENU.ZIP

An example database shows how to remove the System Menu and Resize icons from the Access menu bar when a form is Maximized.  Includes examples of how to modify the menu so that users can be prevented from closing the form as well as how to remove the menu bar altogether.

PBRUSH.ZIP

A sample which shows how you can store pictures outside of a database by pointing to them with a file name instead of storing their contents in a table.

PIMLIST.MDB

Two reports that are for the P.I.M. that is included in Access. Includes a macro to kick out both reports back to back.  This makes the P.I.M. a usable piece of software.

POPCLN.ZIP

A quick, small, popup calendar. Takes up very little screen real estate. Use in forms to easily set dates in controls, tables and queries.

PROMPT.EXE

Companion PROMPT.MDB database for the Microsoft Press book "Running Microsoft Access." File includes a text file describing enhancements in the database and corrections to text since book publication.

REPLAC.ZIP

.MDA file that provides a "Find and Replace" function for Queries, Forms, Reports, and Macros.

RESRCE.TXT

A text list of resources, including information on user groups and local training, journals and magazines about Microsoft Access, and books available in 1993.

SECWIZ.ZIP

A wizard for implementing security. It will add the proper permissions to the database, so it can not be modified. Although it may not apply in all situations it will give a good base to start with. A great time saver when setting up security. Version 1.0a.

SELAN.ZIP

PSEUDO-MULTI SELECTION LIST BOX Sample.

SELECT.ZIP

Shows how to do the multiselector list boxes where you want to select a number of objects.  The logical construct is simple: a couple of listboxes filled by SQL, a table,  a form and autoexec macro.

SNDX.ZIP

This user defined function computes a four-digit Soundex code for a name. Based on the popular Russell Soundex algorithm.  This algorithm was designed for last name searches, but will work with other text strings.

SPELL.ZIP

This sample includes a function which allows you to spell out numbers for printing on checks. For example 123.45 becomes One Hundred twenty-three and 45/100.  This new version includes improvements and a new demo. FREE.

SPIN.ZIP

Sample database demonstrates the use of bitmap buttons to simulate "spin buttons." This allows you to easily increment or decrement a date or number field.

SYSINF.ZIP

This is a simple collection of 4 Access Basic functions which return information about the current Windows configuration (Mode, Free Resources, Coprocessor, and Free Memory).  Calls Windows API functions.

TIMER.ZIP

A dll file that you can use to add a background timer capability to your application.

TLBAR3.ZIP

NEWUTIL.MDA is v. 3 of a replacement for UTILITY.MDA, featuring new buttons for the Access toolbars. To use the replacement library, edit the reference to UTILITY.MDA in the [Options] section of MSACCESS.INI file to NEWUTIL.MDA.

TOTLAC.ZIP

Text file describing Total Access, the Database Documentation program for MS Access. Total Access documents tables, fields, queries, forms, reports, macros, relationships and more. All output is Access Tables and over 30 reports are provided to print documentation in a variety of formats.

TRAIN.ZIP

An Access database with all known Authorized Training Centers who will be doing Access training.

UNION.ZIP

Database containing examples of a technique for faking an SQL UNION (something Access lacks). This technique uses a pure Query - no macros and no codes.

VBDDE.ZIP

From VB different DDE commands are sent to Access. Access is told to execute a SQL string passed by VB and return first, next rows, execute a macro, execute a query, return field names of table. Also, Access has an example of peeking and poking to VB.

VCR.EXE

An article that describes how to build a form that has the '<<', '<', '>' and '>>' (next prev) type buttons to navigate through a multi-page form.  This type of form is just like the ones used in Microsoft's Access Wizards but is alot easier to implement.  VCR.EXE is a self extracting archive.  It contains a readme file, the article as a Microsoft Word document, and the sample database that includes the form and code described in the article.

WAVMAC.ZIP

Access database that shows a few different ways to play and store Wav files in / through MS Access. It also has a registration routine, for those of you creating programs for distribution as Shareware.

WFUNCT.EXE

A Module that adds five functions to your ACCESS database.  Return a specific word within a string, count from either beginning or end.  Uppercase first character, or first character of every word in string. Change to lower case except for first character or first character of every word.  Access Basic code well documented.

WINEXI.ZIP

WIN EXIT V3.0. Utility that provides an iconized option menu to allow the user to quickly exit Access, Restart Windows or Reboot your Computer. If you have any unsaved work when you exit, Win Exit reminds you to save it.

WIZARD.TXT

This is a text file that lists some of the available functions that you can call from Access Basic to generate new forms, reports and controls.

WIZDOC.ZIP

Four Knowledge Base articles on writing Wizards in one text file.

REGULAR PRICE  $49.95 (Plus S/H)

SALE PRICE  $29.95 (Plus S/H)

EXPIRES 08/01/94

ORDER FORM


ACCESS LIBRARY 1 ORDER FORM

NAME: _______________________________

COMPANY NAME: ____________________________________

ADDRESS: ____________________________________________

CITY: __________________________

STATE: _________________________

ZIP: ____________________________

COUNTRY: ______________________

PHONE (OPTIONAL): ________________

The Access library comes on 5-1/4 HD or 3-1/2 HD disks.

DISK PREFERENCE:    5-1/4 [     ]      3-1/2 [     ]

PRICE:    $29.95 PLUS $5.00 Shipping ($10.00 Shipping Foreign)

Arizona residents add 6.7 % sales tax.

Send check or money order drawn on a US Bank made payable to WELSH COMMUNICATIONS and send to the following address:

WELSH COMMUNICATIONS

16845 N. 29TH AVE. STE. 1-604

PHOENIX, AZ  85023


ACCESS SHAREWARE LIBRARY 2

This library contains MS ACCESS Shareware, Freeware and Public Domain files. All of these files are specially picked with the ACCESS user and Developer in mind. You get plenty of actual Databases, Access utilities, On-line Help files, Source Code and more.  NOTE: SHAREWARE PROGRAMS MAY REQUIRE SEPARATE PAYMENT MADE DIRECTLY TO THE AUTHOR FOR CONTINUED USE.

9600BB.ZIP

This is a national list of 3500 Bulletin Boards that support at least 9600 bps, plus Board Watch magazine's top 100 BBS systems.

ACCFAQ.ZIP

This is the Frequently Asked Questions (FAQ) list for Microsoft Access -- and answers! Covers 65+ of the most common Access questions. This is the Second release, January 1994.

ACC-RU.ZIP

This is a small utility to run MS Access with a selected database.

ACEXPO.ZIP

This is version 1.3 of Access Export. It is a library that automates the process of exporting database objects from one Access database to another.  You select all forms, tables, etc that you want to export and then press the export button.  Includes reporting, and the ability to export tables with or without data. Very useful in multi-person development enviroment.

ACCNOT.ZIP

A database of comments on Access.

ADST2.ZIP

ADSTools (Access Developers' Speed Tools) 2.0 is a developer's toolbar for Microsoft Access 1.1. It puts 2 small button bars on the Access titlebar. These provide a quick way to access commands that are buried in Access's menu system. Includes buttons for toolbar, toolbox, palette, property  sheet, field list, ruler, grid, status bar, design view, form view,  datasheet view, Immediate Window and more.

ANALYS.ZIP

Instructions and code on how to print macro code using the output from the Access

database analyzer.

BAR39.ZIP

Barcode 3 of 9 symbology function for Microsoft Access v1.x using native graphics/line draw methods. Includes a report for printing Bar Codes.

BASIC.ZIP

Provides a Plug 'n Play fornt end for applications with auto attach/detect Tables and custom Security.

BUDGET.ZIP

Budgeting forms for Microsoft Access.  This is a full fledged monthly budgeting database.  You can define your own categories and items, and get up to date info on your budgeting.

COLORS.ZIP

This example database shows how to allow a database user to control color of a text box based on the value of data in a record.  You can assign colors as desired via table.

COMPAC.ZIP

COMPACTER VERSION 2 can be used to Compact or Repair Access Databases without the need to run MSAccess.

CONTAC.ZIP

Personal/Business Contacts management database version 1.1. It now contains new & improved search capabilities.  Manage all your business & personal phone calls.  Unlimited number of dated notes attached to each contact. Requires Access 1.1.

DATECA.ZIP

A simple database to calculate working days between two given dates in any current working year utilizing MS Access Date Functions and an Observed Holidays table to define Observed Holidays for the year.

DISKLA11.ZIP

This program is great for labeling your diskettes.  Easy data entry, on-the-fly previewing, and good looking labels for your diskettes. Created for Avery Labels 5196. Version 1.1

GRDBOO.EXE

This application provides grade recordkeeping, averaging, and reporting  for the elementary school teacher.  It is an easy to understand and use database. It provides quick access to current student grade averages.

HDD.ZIP

Database of Hard Drive data. Full implimentation of the previous version HDDT which contained little data. It contains over 1600 records. Included is a listing of hard drive repair facilities and Hard Drive manufacturers BBS phone numbers. All of the data is editable and the database can have new data entered.

MENUFO.ZIP

This is a sample database that provides an alternate method for menuing.

MOVIE.ZIP

This is a database that keeps track of your home videos (movies) and you can add, edit, delete, search, and print the movie list in various ways.

NAME.ZIP

Sample database to demonstrate another way to search for a value.  User can enter part of, none, or all of a first and last name; the database is queried and the matches appear in a list box; the user can select among the choices and the corresponding record will be displayed on the sub form.

NEWUTI.ZIP

This is  a revision to the MS Access library UTILITY.MDA.  The new file (NEWUTIL.MDA) will replace the standard MS Access toolbar buttons with commonly used commands.  New functionality is gained from the one-touch commands that are now available. The MS Access toolbar is now PACKED with  buttons that should speed your development !

NOTES.EXE

NOTES contains an article and a database. This article shows how to create a software version of Post-It Notes for use in Microsoft Access. NOTES.MDB contains the sample application described in the article.

OBJECT.ZIP

Object Tracker, when imported into your own database, will enable you to  'track' and keep notes and other information on all the Objects within your database.

PBQUER.ZIP

PBQuery is a module for Access allowing one of the easiest methods for a computer illiterate to make elaborate queries on ALL fields in table simply by clicking a mouse. Uses 2 listboxes with ADD and DEL buttons for selection of items to query on for a given field.  EDITBOX -LIST for string and date entries. * and date ranges.  Builds SQL Select lines can be cut & pasted into any Access filter.  Saves and builds Access queries from a users selection.

PICK.ZIP

An Access database that demonstrates one way to highlight, select, and then identify multiple records when using continuous forms.

PO.ZIP

Here is a database that shows of a way to create a meaningful PO number as opposed to just a counter field. It concatates VendorID, Mon. and Yr. order is placed and keeps count of the number of orders to that vendor for the given month.

QBF.ZIP

Custom Report Helper, with a query-by-form interface that allows users to create custom reports without using the Access query tool.  Steps users  through the process of choosing fields, setting criteria, then uses the Access  Report Wizard to layout the report. Works with NWIND.MDB database, but can easily modified to work with any .MDB.

REPLST.ZIP

Gives the user an option for firing reports instead of command buttons  with macros.

REPORT.ZIP

This form is excellent for applications that have many reports. Eliminates the need for tons of command buttons and macros.

SETPRT.ZIP

This is a database containing code and an example of how to get and set the current output device.  The sample form displays a list of all the current output devices and allows you to choose one. Then you can choose to print the form to the current, default device or to the device that you have selected.

START1.ZIP

This is a small utility program that makes it easy to switch between different Microsoft Access SYSTEM.MDA configurations. It works by setting the SystemDB setting in the MSACCESS.INI file before launching MSACCESS.EXE. This lets you easily maintain various workgroup configurations. You must have VBRUN300.DLL to use this program (INCLUDED WITH THIS LIBRARY).

USPSNE.ZIP

POSTNET Barcaods and USPS Business Reply FIM patterns into one font. These fonts have been tested by a USPS Readability Specialist and been found to meet all requirements. The USPS neither endorses nor recommends these fonts. Using these fonts in conjunction with USPS mail specifications can lower mailing costs and improve delivery.

ZIPCOD.EXE

This file contains a complete listing of US ZIP Codes in comma delimited format. Includes examples how this file might be used to automate data entry by looking up the city and state when a valid ZIP code is entered.  Also includes a stand alone program for viewing the ZIP code file and looking up entries. Updates available.

ZIPDEM.ZIP

This example databaseshows how to enter a Zip Code and have Access look up and set the appropriate city and state. For example, enter "98053" and Access fills in  "Redmond" and "WA".

Some ZIPs have been assigned to multiple cities. For example, "63121"  belongs to no fewer than 10 cities in Missouri. For these multi-city  ZIPs, a  list box appears that lets you choose a city.

REGULAR PRICE  $49.95 (Plus S/H)

SALE PRICE  $29.95 (Plus S/H)

EXPIRES 08/01/94

ORDER FORM


ACCESS LIBRARY 2 ORDER FORM

NAME: _______________________________

COMPANY NAME: ____________________________________

ADDRESS: ____________________________________________

CITY: __________________________

STATE: _________________________

ZIP: ____________________________

COUNTRY: ______________________

PHONE (OPTIONAL): ________________

The Access library comes on 5-1/4 HD or 3-1/2 HD disks.

DISK PREFERENCE:    5-1/4 [     ]      3-1/2 [     ]

PRICE:    $29.95 PLUS $5.00 Shipping ($10.00 Shipping Foreign)

Arizona residents add 6.7 % sales tax.

Send check or money order drawn on a US Bank made payable to WELSH COMMUNICATIONS and send to the following address:

WELSH COMMUNICATIONS

16845 N. 29TH AVE. STE. 1-604

PHOENIX, AZ  85023


THE ELECTRIFIED BBS
THE ELECTRIFIED NETWORK

This is an on-line resource that is great for MS Access users and developers. It is running high speed HAYES 28.8 V.FC and BOCA 14.4 V32bis modems. It is a fully graphical, mouse driven BBS or you can call in text mode with your normal term program. It has many MS Access files including utilities, forms, macros, complete applications that you can learn from and more. There are also many general Windows file sections on-line. These include Windows games, utilities, icons, fonts, graphics, WinWord files, Word Perfect files, programming etc.

CALL (602) 942-9405 WITH YOUR MODEM TODAY!


ACCESS TIPS AND TRICKS

1. Make sure you compact your Access databases periodically. When you have deleted records from your database Access marks them as deleted but does not remove them from the table. By compacting your database objects that are no longer needed are removed. This will save you disk space and speed up your database.

2. Do you like using the Enter key to move from field to field instead of the Tab key. Choose View Options and pick the keyboard category. There you can change items related to the keyboard.