|
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 Aussie
|
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,
A New
Format For Access Unlimited
Excel Chart Programming
Postcard from Mongolia
Reader Feedback
Win A Copy Of Some Of Our Software
Good Reading
A New Format For Access Unlimited
To celebrate the New Year, I though it was time to bring Access Unlimited out in a new format. For this edition I have converted the way that we send out the newsletter to use HTML email directly from MS Word 2002. I have done this to (hopefully) make the newsletter easier to read, to reduce issues with super long hyperlinks, because I think most people will have HTML format email readers now and because I need to learn something new.
I hope you like the format and I would like your feedback as it will provide interesting information for all the readers of this newsletter.
Garry Robinson
PS. The first lesson I learnt is that if you want to include hyperlinks in your html emails, you need to install Office XP Service Packs 1 and 2. Download here
Excel Chart Programming
Michael Kofler from Apress Publishing provides a sample chapter on programming Excel Charts that should be of interest to many AU readers.
Charts constitute the central feature of many Excel applications. This chapter gives a brief overview of the charts supported by Excel and also shows how you can create and print out your own charts under program control. A lengthy example an the subject of automatic data processing and analyzing (using charts) demonstrates various programming techniques. A further topic of this chapter is drawing objects (Shapes), available since Excel 97.
http://www.apress.com/book/supplementDownload.html?bID=43&sID=252
“This book is still one of
the most important books on my shelves.” Ed.
Read more and purchase the book from
http://www.vb123.com/books/
Postcard
from Mongolia
One of the projects that we have been assisting with during the last 6 months is
situated in the Gobi desert, 10 hours drive from Ulaanbataar, the capital of
Mongolia. During Scott’s last visit to site, the temperature was -50
somethings. From that trip, he brought back some digital shots which give you
an idea of the accommodation the exploration team find most suited to this very
harshest of climates.
The exploration camp site
The typical accommodation
at the camp
The
official Oyu Tolgoi exploration project photo gallery
Reader
Feedback
Folder
Lists
In edition 36 of Access Unlimited, I referred to a tip to show how to list all files in a folder using MS Dos. The readers put together many alternatives which I have detailed tt the following page. Thanks for your input everyone.
http://www.vb123.com/toolshed/links/folderListings.htm
The Popup Keyboard
In edition 36 of Access Unlimited I wrote about the popup keyboard in Windows XP.
If you are running Windows XP, you will find a cool little program called the On Screen keyboard. This will allow you to type with your mouse and return the instructions to the last program that had the focus.
C:\WINDOWS\system32\osk.exe
Gustav informs me that this is also available in Windows 2000.
WINDOWS XP IP ADDRESS
If your network connection icon is in the system tray (near the clock in the taskbar), right click on it and click the Status command. Click on the Support tab. You'll see your IP address and other information. If you want even more information, click on the Details button.
Click Start, click Run and type cmd in the Open text box. In the command prompt window, type: ipconfig /all You will see detailed information about your network connections, including your IP address.
Win A Copy Of Some Of Our Software
To win a copy of some of our software, copy the following web page to your web site and keep all the links on the page. Once the page is on your web site, register the page at Google. Prizes will be announced in this newsletter and it doesn’t matter how popular your web site is.
http://www.gr-fx.com/vb123Prize.htm
A great page of Access tips
of all types
http://www.trainingandeducation.com/tipsaccess.htm
Advanced DAO programming.
http://www.fmsinc.com/tpapers/dao/
How To Shut Down A Database
Remotely
http://support.microsoft.com/default.aspx?scid=kb;EN-US;304408
The Uncorruption page for MS
Access
http://www.vb123.com/toolshed/02_access/uncorruptdb.htm
Retrieving lists of error
numbers
Click here for the Google groups link
New Knowledge Base Articles
From Microsoft. Go to
http://www.kbalertz.com/technology.aspx?tec=6
If you like this newsletter, why not try
Access Developer News by Mike
Gunderloy
http://www.larkware.com
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.
WRAPPING THIS EDITION UP
Hope you had a good Xmas and all the best for the New Year.
Ed. Garry Robinson
--- The end of this edition of Access Unlimited ---
Click on this button
to read the previous edition of Access Unlimited
Published 2003-01