vb123.com.au                                                          

  Welcome To The Access Unlimited Newsletter - Edition 31
See all newsletters

Access Unlimited is an email newsletter that provides free tips, help and information for skilled Microsoft Access users and related software disciplines.


Produced by Garry Robinson (known below as "Ed") from Sydney, Australia.

In this edition,

FINDING SEND TO
LOOKUP TABLES - IMPROVE DATA QUALITY IN YOUR DATABASE
BACKING UP LOCAL VERSIONS OF MICROSOFT OUTLOOK
REVAMPED VB123.COM SEARCH ENGINE
OFFICE XP ACTIVATION ISSUES
GOOD READING
EXCELent $$$'s TO BE MADE


--- FINDING SEND-TO OPTIONS IN WINDOWS XP, 2000 AND USING THEM FOR ACCESS

If you are using multiple versions of Microsoft Access, you need to be able to change between versions.  The method that Ed has always used is the sendto option that you get when you right click on a file in Windows
explorer.   Whilst this is simple to setup in Windows 98, it is a lot
trickier in Windows XP and 2000.     This online article explains how you
can add to your send to options.

Click here for article

--- LOOKUP TABLES - IMPROVE DATA QUALITY IN YOUR DATABASE

By Doug Thatcher

Eliminating data errors at the point of data entry can pay big dividends in
the future.   One of biggest sources of errors that we come across is fields
that should be using a set number of entries but have been established in
the database with no control.   This detailed article describes all the
steps involved in changing an existing text box with no data entry validation into a watertight combo box using a lookup table.  Other options are explained to help reduce incorrect data entry.

Click here for article


--- GOOD READING

How to secure a corporate network.  A number of MS white papers.
Click here

Outlook programming examples Click here

Great Outlook links page Click here

ADO Programmers reference starts here  Click here

A list of ADO Data Types   Click here

Programming ADO with Python.  It's not Monty but a newer variation on Awk for Unix and other things.  Have a look and try the links at the bottom of the page. http://www.e-coli.net/pyado.html

Financial Modelling at a Mining Company Using Excel And Access Click here

The Access Workbench at Simtel
http://www.simtel.net/pub/pd/61417.html



Thanks for reading this edition

Garry Robinson

-- OUR SOFTWARE AND RESOURCES -----------------------

Reuse our software in your programs --->
http://www.vb123.com/toolbox/

Read the books that we read --->
http://www.vb123.com/books/

Explore your data visually using our popular Access data mining shareware --->
http://www.vb123.com/explore

View our web site as a searchable eBook and have access to all the downloads discussed in the articles and information pages at the popular vb123.com web site. ---> http://www.vb123.com/Toolbox/
 

So thanks for reading our popular newsletter. Feel free to make comments, copy the email to a friend or maybe even contribute to the next edition.

Garry Robinson - Software Consultant
 

Click on this button to read the previous edition of Access Unlimited 

Published  2002-03