|
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
?
Welcome To Tips-FX - Edition
10See all newsletters
tips, help and information for skilled Microsoft
Access users and related software disciplines.
ED'S FAVORITE SHAREWARE
PREPARING FOR YEAR 2000 - A FEW LATE TIPS
DUELING ACCESS 2000 AND 97
GOOD READING AND USEFUL SITES
ED'S BEST TIP FOR WINDOWS / MICROSOFT SOFTWARE.
alternative mouse button) and see what options are available.
It may not always be useful but then again you would be
surprised how many people do not take advantage of these
shortcut menus. So tell a colleague just to make sure they
know as well !
ED'S FAVORITE SHAREWARE PROGRAM
seem to use very regularly and that is a text editor. I write
this newsletter in an editor, replace strings from SQL statements
in an editor and use the editor as a buffer for doing fancy
things with visual basic code. And when it comes to massaging
large text files that have to be imported into a database,
a good editor is essential.
on a computer where I either have to use Wordpad or Notepad.
I hate to say it but they are basic tools for all sorts of
reasons. The editor I use is called UltraEdit and it can
be found at http://www.ultraedit.com/
shift columns of text and its keyboard learning sequence
(macros) is a gem. The most important feature is that it
just seems to make life easier. At $30 its a great tool.
But it is highly likely that you have your own favorite text
editor so let me know and I will pass on your comments in
the next edition. Sorry to offend anyone that uses the MS editors.
it off any longer. I still see sites that do nothing
or rely on partial backups. Here is the usual guide
Store tapes offsite.
Test your backup systems by recovering files.
on a regular basis and make sure they also end up on your
tapes. http://www.gr-fx.com/wizards has such a tool.
of Tips-FX and at vb123 dot com
http://www.vb123.com/toolshed/99_reviews/ta2000.htm
http://www.vb123.com/toolshed/99_reviews/intro.htm
http://www.vb123.com/toolshed/news/issue2.htm
http://www.vb123.com/toolshed/news/issue1.htm
DUELING ACCESS 2000 AND 97
on a PC where Office 2000 was installed. Please read the
notes in issue 2 of this newsletter if you are thinking of
upgrading and want to run both versions.
------------------------------------------
GOOD READING AND USEFUL SITES
Well make a News Years resolution to read one article
a week on technical software use and development. To help
with your resolve, here are some great articles from
MSDN and officevba that have been published lately.
http://www.msOfficePRO.com/features/2000/01/vba200001mr_f/vba200001mr_f.asp
Microsoft Office 2000 Mapping Software
http://www.msOfficePRO.com/features/2000/01/vba200001mg_f/vba200001mg_f.asp
http://www.vbashopper.com/components/vba99w40.asp
Want to compare two databases to see what the user has changed.
Try this Visual Basic software that does those comparisons.
http://msdn.microsoft.com/library/periodic/period99/11vbd/vb99k13.htm
Pattern matching in strings. Code for VBScript that shows you
how to find patterns in text and you’you will probably learn things
that will shed some light on search engines
http://msdn.microsoft.com/library/periodic/period99/09vbd/vb99i1.htm
Create Your Own Popup Button Controls in any Office Product. Or
some interesting reading for those who just don't know when to stop
improving the user interface of their application.
http://msdn.microsoft.com/library/periodic/period99/11mov/button.htm
An Article On Replication In Access 2000
http://msdn.microsoft.com/library/periodic/period99/11mov/replicat.htm
Building E-Commerce Solutions With MAPI Controls
http://msdn.microsoft.com/library/periodic/period99/11ivb/ecommerce.htm
Searching through sub folders using the File System Object (VB)
http://msdn.microsoft.com/library/periodic/period99/10ivb/recursive.htm
Speeding up ADO in VB - Worth a read for client server developers
And what about the worlds longest web page reference !!!
http://msdn.microsoft.com/library/periodic/period99/06ivb/insidevisualbasic-usingtheadogetrowsmethodforfasterdataretrieval.htm
What has improved in the Access 2000 Relationship Manager
http://msdn.microsoft.com/library/periodic/period99/12mo/revamp.htm
Frontpage 2000 has made some good improvements in HTML.
Read all about it. Ed agrees, Frontpage 2000 is worth the upgrade
as long as you don't upset your client relationships.
http://msdn.microsoft.com/library/periodic/period99/11mo/o2k99b4.htm
Find the end of the week from a date. Access programmers take note !
http://msdn.microsoft.com/library/periodic/period99/09imo/date.htm
free neatcode database as explained at
http://www.vb123.com/toolshed/99/freestuff.htm
An ASP article on importing delimited text files.
http://msdn.microsoft.com/library/periodic/period99/09asd/import.htm
And a book on Microsoft Jet online.
http://msdn.microsoft.com/isapi/msdnlib.idc?theURL=/library/books/dnjet/c1_body.htm
MSDN html page. This brings up a tree view menu.
http://www.vb123.com/toolshed/news/read99.htm
-- OUR SOFTWARE AND RESOURCES -----------------------
data mining shareware
old web and have access to all the software discussed in
the articles and information pages at www.vb123.com
or maybe even contribute to the next edition.
Click on this button
to read the previous edition of Tips-FX
Published 1999-12