|
vb123.com |
|
|
Home Contact Us Order our Software RSS &
Newsletter
Get Good Help
The
Workbench
Find out who has your database open, start the
correct version of Access, easy compacting and backups, change startup
options, mde compile, shutdown database
Read and
Download Garry's Blog
About The Editor
Garry Robinson
writes for a number of popular computer magazines, is now a book author
and has worked on 100+ Access databases. He is based in Sydney,
Australia or try our new site built with
SharePoint Designer |
Is Your Database Corrupt ?
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
--- BACKING UP LOCAL VERSIONS OF MICROSOFT OUTLOOK
By Scott McManus
When it comes time to format your hard drive, move to a new computer or If you just want to back up all of your Outlook functionality, then you need to follow these critical steps.
Click here for article
--- REVAMPED VB123.COM SEARCH ENGINE
The search engine has been revamped (faster loading) and googalized at
http://www.vb123.com/search/
Improvements include better searches as a lot of marketing material pages has been removed from the index. You will now find the search link for vb123.com at the bottom of most pages on the web site. Alternatively, you can go straight to Google and search vb123.com with this path
http://www.google.com/search?as_sitesearch=www.vb123.com
Also you might note that Google now have a special Microsoft search page
http://www.google.com/microsoft.html
--- OFFICE XP ACTIVATION ISSUES
Last month I wrote about a problem with Office XP saying that my
computer hardware has significantly changed and that I need to activate
the product. This was resolved by upgrading to service pack 1 of Office
XP. http://www.microsoft.com/officexp/downloads/
The next significant problem was a number of registry problems to do
with Access 2000 and Windows XP. Upgrading to Office 2000 Service Pack
1a solved this.
A Reader Wrote on this topic
Why not just stick with win 2000 ??? Its much more stable than
9x/ME/NT - now I go a week or two without rebooting, before it was 1-2
days, even with NT and SP-5
Ed: I have one of those little Sony Vaio laptops that weigh 2 lbs
(1 kg). Its only supported upgrade path was via Win XP. Since the
upgrade, Win XP Home goes really nicely into stand by mode and back.
Sure beats shutting down and booting up again. It should be as
stable as Win2000 as it runs the same code (with a few things hidden).
I thought long and hard about Win 2000 but I am always busy (till last
week) and never have the time to rebuild my programming / portable
network machine.
Handy Win XP Tip: Hit the Windows key and L at the same time
to logoff
your session. Then you can put the machine in stand by mode and
have the session protected by a password.
--- 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/graf/
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/toolshed/
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