Welcome To Tips-FX - Edition 14
See all newsletters

Tips-FX is an email newsletter that provides free tips,  help and information for skilled Microsoft Access users and related software disciplines.   In this edition we celebrate the newsletter being delivered to over a 1000 readers for the first time.  Thanks to everyone for joining up.  Keep the feedback coming so that this will continue to be a useful resource.

In this edition

COMPACT YOUR SCREEN DUMPS BEFORE EMAILING
TRACKING CHANGES TO RECORDS
ACCESS SECURITY AND PASSWORDS
VB123 HOMEPAGE REVAMPED
VB6 ADO ADD-IN RELEASED
GOOD READING AND USEFUL SITES

-------------------------------------------------------
COMPACT YOUR SCREEN DUMPS BEFORE EMAILING

Want to send someone a copy of screen dump in email. 

First hit the Print Screen button (top right of keyboard)  or
Alt Print screen for the current window
Open Word and paste the screen into a blank document.
Now on the File Menu choose Send To ... Mail Recipient
This will send out a compressed version of the bitmap.

What ever you do, do not send out an uncompressed bitmap saved using Microsoft Paint.  They are gigantic and can be compressed into a zip file of 100 the size.

-------------------------------------------------------
TRACKING CHANGES TO RECORDS

In this months featured online article, Nirmala has come up with a sensible way of keeping tracking of changes to records in a database.   I liked the idea because it was similar to an approach that I used successfully in an Informix database system about 10 years ago. The article is summarised as follows

Very often, we need to audit all changes made to a record. This is useful for sensitive data or in cases where accountability needs to be established. This approach involves

 Storing all changes made plus
 Ascertaining who made each change and when

Either way, why not read all about it at

http://www.vb123.com/toolshed/00_access/auditrecords.htm


-------------------------------------------------------
 ACCESS SECURITY AND PASSWORDS

The second feature online article this week provides an interesting insight into the world of security and passwords.  This is a pretty useful read if you have ever worried about people hacking into your code or finding out your salary in that "secured database".   Read about it at

http://www.vb123.com/toolshed/00_accvb/accesssecurity.htm

This article was brought you by

Dmitry Sumin,
Security Expert
http://www.LostPassword.com


-------------------------------------------------------
VB123 HOMEPAGE REVAMPED

The homepage has been changed to improve download times by 50%, to improve navigation and increase readability on lower resolution monitors.  Thanks to Martin Lindstrom from The Devcom conference in Sydney for his tips on speed.  Ie If a home page takes more than 18seconds on a 28k modem, you are out of the hunt.  This page used to take 22 seconds according to Frontpage 2000 and now takes 10 seconds.

www.vb123.com


-------------------------------------------------------
Online Software and Book Purchases From Amazon.Com
Try out the new electronics section at Amazon.
Click here to enter the store at places suited to
the readership of this magazine
http://www.vb123.com#software


-------------------------------------------------------
VB6 ADO ADD-IN RELEASED

Adam Cogan first told us about this add-in at Devcon Oz. Here the official release

This Add-In automates the task of mapping stored procedure parameters to ADO Command object parameters. Head to this site to download!   But beware that you need to be into SQL Server and VB and ADO to use this great new Microsoft Add-In.

http://www.vbtt.com/

-------------------------------------------------------
 Good Reading and Useful Sites

Programming your own graphics applications in visual basic.  Try this link
http://www.dev-center.com/articles/multimedia/graphics_with_vb/

What is SQL.   Here is an overview for those of you who do not know.
http://www.dev-center.com/articles/databases/structured_query_language/

VB123.com wins another award.  Lots of vb links on this page
http://www.vbgreatone.8m.com/links.htm

Access 97 Database password retrieval.
http://www.dev-center.com/code/code.asp?CodeID=55

Running your PC on a permanent connection.  Then you should consider a firewall.
http://www.zonelabs.com/

But before you consider the firewall, test your computers stealth using the tools at
http://grc.com/

Printing graphics using visual basic.
http://www.dev-center.com/articles/multimedia/printing_graphics/

Microsoft Excel Statistics Book
http://cw.prenhall.com/bookbind/pubbooks/levine/chapter1/deluxe.html


Lots of Active Server Pages Sites - Try this monster URL
http://dir.yahoo.com/Computers_and_Internet/Software/Internet/World_Wide_Web/Servers/Microsoft_Windows/Active_Server_Pages__ASP_/

Grabbing Table Columns from Other Web Pages
http://www.4guysfromrolla.com/webtech/031000-1.shtml

Worried about using FrontPage for ASP development.  Ed uses Frontpage and here is an article that argues the For case.
http://asp.superexpert.com/articles/articleredir.asp?aid=18

Creating a User-Friendly Search Engine For An Access Database
http://www.asptoday.com/default.asp?art=19990803.htm

A good resource for Internet, ASP and Databases
http://www.tcp-ip.com/

and their database knowledgebase
http://www3.tcp-ip.com/ResourceIndex/Showcat.asp?cat=ASP+Online+References%2FDatabase+Reference

A Microsoft Link for Email from ASP pages
http://msdn.microsoft.com/workshop/server/feature/morqa.asp

Links to lots of good ASP articles.
http://www.aspforums.com/directory/Development/

An Access Web Site written in German
http://www.fullaccess.de/


Microsoft Magazine
http://msdn.microsoft.com/msdnmag/

Got a Visual Basic Story that you want to submit, then try
http://vbwire.com/addnews.asp

XML In IE5 and More
http://www.wrox.com/Consumer/Store/Books/2270/2270_05_05.htm

Making An Active X Control
http://vbgreatone.8m.com/VB/lessons/control.htm

The name says it all and it's a big site  (not so much vb though)
http://www.freecode.com/

Send the address of a page to a friend
http://www.aspwatch.com/c/199930/dC8916CB74BFD11D3ADBE00A0C9E95208.asp

 Administration

PREVIOUS EDITIONS OF TIPS-FX
http://www.vb123.com/toolshed/news/toc.htm

-- OUR SOFTWARE AND RESOURCES -----------------------
Explore your data visually using our popular Access
data mining shareware
---> http://www.vb123.com/graf/

View our web site on your computer rather than the slow
old web and have access to all the software discussed in
the articles and information pages at www.vb123.com
---> http://www.gr-fx.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 Tips-FX 

Published  2000-04

Links >>>  Home | Search | Workbench | Orders | Newsletter | Access Security | Access professionals