Access Unlimited - Edition 06

Welcome To Access Unlimited - Edition 6
See all newsletters

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

In this edition

GETTING YOUR INFORMATION INTO EXCEL
PUT YOUR DATABASE TO WORK
VB123 WINS SITE OF THE WEEK AWARD
MAKING A PROFESSIONAL LOOKING WEB SITE
HARDWARE BUGS
SEARCH FOR CD'S AND BOOKS ONLINE
GOOD READING AND USEFUL SITES

-------------------------------------------------------------
GETTING YOUR INFORMATION INTO EXCEL - THE EASY WAY

Open the table/query/form that you want to analyse
Apply any filters that you want
Click in the top left hand corner of the grid
Control C
Open Excel
Control V

For visual examples on different ways to transfer to Excel

http://www.vb123.com/toolshed/99/exceltransfer.htm

-------------------------------------------------------------
PUT YOUR DATABASE TO WORK

Online databases might be a good thing for keeping control of
your software but if you want to be found in the search
engines then they are not much use. You can get around this by
publishing a static web page for each make or model in that
database. That might give you 100 additional web pages that
could help you drag in new customers. Of course the content
of those pages is important as is the suitability to search
engines but that is a story for another day. Remember that
just because you have a great looking web site ....

While I am at it, I went around the Access web loop looking
for sites with decent help and tips etc that I could add to
a customized AltaVista search facility that I was going to add
to VB123. In summary, most of the sites that had good
programming material were not registered with AltaVista.
Why I don't know but getting your site indexed Is Important.

If you want to go directly to the Add-URL pages of the biggest
search engines, then try the list at

http://www.vb123.com/toolshed/99_fpage/fp6.htm

or check out the Access Web Ring

http://www.iversonsoftware.com/accessring.htm

-- Advertisement -----------------------------------------

***** Jenkins & Thompson *****

Do you do research? Are you involved in a health profession?
Jenkins & Thompson P/L can write a specialized Access data-
base for you. We also do analysis and data conversions.
Visit and download our free Access utilities.

http://www.healthbase.com.au

-------------------------------------------------------------
VB123 WINS VB WEB DIRECTORY

COOL SITE OF THE WEEK AWARD

http://www.vb-web-directory.com/mustseevb/vbwdcool.shtml

The Access Unlimited magazine is now online at the

"Australian Institute Of Geologists Web Site"

For all of you readers that think the economy is rosy, there
are some interesting discussions on this site about the downturn
for geologists in todays market. For our mining readers, why
not sign up for the geological events channel or try the forums
for geologists.

http://www.aig.asn.au/

-------------------------------------------------------------
MAKING A PROFESSIONAL LOOKING WEB SITE (USING FRONTPAGE)

The first 4 lessons about making a web site that looks good
have now been published. Here is a summary of those pages

Knowing your fonts is a very simple way to improve the
readability of page. Most of the big sites use a font called
Verdana whenever they publish a page with a lot of text and
even on their busy main pages in smaller format.

Width is very important on pages filled with lots of text.
If you use a newspaper analogy, do you ever see a page
filled with text from one side of the page to the other.
Using tables or FrontPage borders or even frame sets
can reduce the width and make pages more readable.

Don't forget to add your page header title and meta tags such as
keywords, description and title before you close down a page.
These are critical for search engine success.

Ed knows that a web site design can be emotional as your
favourite blend of coffee so these pages only serve as suggestions.
I have also include links to sites that know a lot more than Moi.

http://www.vb123.com/toolshed/99_fpage/fp1.htm

http://www.webmonkey.com http://www.websitegarage.com

-------------------------------------------------------------
HARDWARE BUGS

One of the local Aussie visitors asked if there was a known
fix for large Access databases getting corrupted when
transferring large files. Turns out that the corruptions were
due to Win98 adapter drivers not working with Realtek 8029
network adapters (occasional corrupt datapacket). Fix is to
update with the latest driver issued out this month.

See Article Q189778 in MSDN.

Lessons from this are
... search MSDN
... sometimes it can be a hardware problem.
... keep reviewing those backup strategies.

-----------------------------------------------------------

SEARCH FOR CD'S AND BOOKS ONLINE

The most popular page on our web site is a page that allows
you to compare prices of Compact Disks and Books at
Amazon, CDNow, CDUniverse, Borders and other big vendors.
The page is a little daggy but the search facilities are
quite useful.

http://www.gr-fx.com/cdplus http://www.gr-fx.com/booksplus

-----------------------------------------------------------

GOOD READING AND USEFUL SITES

This week we feature a cracker of a Visual Basic site
http://vb-web-directory.com/

Why not try the must see VB sites page
http://vb-web-directory.com/mustseevb/mustseevb.shtml

Or the VBA section for lots of Office/Access Links
http://vb-web-directory.com/vba/vba.shtml

And for on-line tutorials
http://www.vb-web-directory.com/tutorial/tutorial.shtml

--- OTHERS

A few useful articles and another newsletter to join.
http://www.saicomsystems.com/tiparchives.asp

More Access tools and tips
http://www.peterssoftware.com/

--- WORD AUTOMATION

After chasing down help for turning Word into an Access
reporting tool, here are a few places at the Microsoft
site of some note.

The 97 Word site. Not everyone has Word 2000 yet Bill !!!
http://www.microsoft.com/worddev/w-a&sa.htm

Overview of document management and automation with Word/Excel
http://www.microsoft.com/Worddev/Articles/movs201.htm

Incase you do have Word 2000 (the code can work with 97)
http://msdn.microsoft.com/officedev/technical/articles/word.asp

And finally a really useful Knowledge Base Article
http://support.microsoft.com/support/kb/articles/q131/5/83.asp

--- DATA SHAPING - ASP

A new feature of ADO 2.0 is the ability to work with hierarchal
data sets. The real strength of this new way of handling
recordsets is for web technologies but if you want to think
outside the circle, then this is worth a look

http://www.4guysfromrolla.com/webtech/092599-1.shtml

-----------------------------------------------------------
FREE DOWNLOAD FOR THE MONTH

Every now and again we are going to reveal the location
of different files that are available as part of
"The Toolshed" http://www.vb123.com/toolshed

These edition features the source code for the wizards

THIS LINK HAS NOW BEEN HIDDEN. YOU NEED TO PURCHASE THE TOOLSHED OR JOIN UP FOR THE NEWSLETTER TO FIND OUT THESE LINKS

The wizards featured are

Unload all tables to text wizard (useful backup tool)
Find Records wizard
Back button wizard

Needless to say you are on your own with the code inside
this database and if you want to find out more about these
modest little tools try

http://www.gr-fx.com/wizards

Stay tuned to future editions of Access Unlimited for more useful
"Toolshed" giveaways.

-----------------------------------------------------------
LAST EDITION
http://www.vb123.com/toolshed/news/issue5.htm

PREVIOUS GOOD READING LINKS
http://www.vb123.com/toolshed/news/read99.htm

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 1999-10