|
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
|
In this newsletter |
Simplifying Complex SQL | Office 12 | Queries to impress your boss | More
RSS Feeds |
Access Unlimited is an email newsletter that provides Tips, Tricks and Techniques for skilled Microsoft Access users and people working in related software disciplines.
Produced by Garry Robinson from Sydney, Australia.
As I mentioned in the previous newsletters, I have decided to adopt XML to help distribute news content at vb123.com. In this newsletter I have converted our RSS feeds for the last month into HTML to include in this email. These links and descriptions are listed below.
6/01/2006 6:57 AM
Simplifying Complex SQL by Peter Vogel
To succeed with SQL, the most important thing you need to learn isn't new SQL
commands but a new approach. Most Access developers use a "procedure-oriented"
approach to problem solving: Do this, then do this, then do this. This approach
works well when writing VBA code. Unfortunately, SQL is not procedural but is
set-based. Many developers, when working with SQL, develop a procedural
algorithm ("If I were doing this in VBA, I would...") and then try to convert
that procedural algorithm to a set-based algorithm. This only complicates the
problem. The first step in handling complicated SQL is to simplify the way that
you think about the problems you want to solve with SQL.
Only available in January
6/01/2006 8:21 AM
What PCWorld/Yahoo Says About Office 12
When Microsoft says that the next version of Office is the most important
revision in over a decade, it's not kidding. Both new XML-based default file
formats and a major interface revamp are intended to make the market-dominating
productivity suite more flexible and accessible than ever. Veteran users may
find the changes in the new version, code-named Office 12, unsettling, but they
seemed well worth the adjustment in our tests of the first beta release.
6/01/2006 10:20 PM
Rick Dobson Seminar for SQL Server Express, Visual Basic Express, and Visual Web
Developer Express.
The seminar features 21 hours of live, interactive training spread over 3 days
or 6 evenings at any of three presentations during March and early April.
Registrants view slides and demonstrations in their browser and use a toll-free
number for two-way audio communication. The software for this seminar is FREE,
and you receive a FREE copy of a book on creating database solutions with SQL
Server 2005 Express, Visual Basic Express and Visual Web Developer Express.
Registrants have a chance to win one of 3 copies of SQL Server 2005/Visual
Studio 2005, which is worth many times more than the $275 registration fee.
|
Access Unlimited Business Subscription If you use Access Unlimited to help you with your business, support us by becoming a business subscriber. Click here to subscribe At the end of the month of January, there will be two prizes for business subscribers of the Access Unlimited Newsletter. At the moment your chances of winning are pretty good J
The first is a book by
Grover Park George which is aimed at novice Access users. As a former
educator first learning about databases, the author was often frustrated by
the lack of decent introductory books on database development. A few years
later, he decided to do something about it. The result is a book that starts
by asking the question “Why do you even want to create a database?” and
leads the new Access developer step-by-step through the first stages of
creating a working application. Rick Dobson has also offered a prize of one year’s free membership of the Database Developer Group. Read more at http://www.programmingmsaccess.com/ Note: You will receive additional content with your subscription unavailable to the free signups. |
3/01/2006 7:17 AM
Tricky Queries to Impress Your Boss
For this article, I poured over the many Access applications that I have written
to find a useful Access topic that is not generally known by programmers. The
one that I came up with was the technique of using IIF functions in Access
consolidation queries. Hopefully these query tricks will let you come up with
some new query/reporting formats that will impress your boss.
30/12/2005 9:30 PM
Latest Vb123 Newsletter
Find out the latest from Garry at vb123.com including a bumper crop of good
reading links.
6/01/2006 4:56 AM
How to build a CD Rom for products purchased from vb123.com
We have new instructions on building a CD/DVD after purchasing our products.
This will provide you with piece of mind in times of hard drive crashes etc.
29/12/2005 8:35 PM
Web Technology - Microsoft takes Google Seriously By Cranking Up MSN
The nightmare is inching closer to reality and Microsoft execs are apparently
paying attention to the decade-old alert that the Web may remove their
stranglehold on technology.
"We've had lots of competitors in their honeymoon phase," Gates said about
Google in a recent interview with CNET News.com. "But I'd say, in some ways,
this is the biggest honeymoon I've ever seen." Read more at Zdnet
27/12/2005 8:51 AM
Stop Outlook Warning Messages (published in the last newsletter)
One of the more annoying things to cope with when programming for Microsoft
Outlook is the security messages that pop up to stop the boring email spammers.
The ones that you may be familiar with are
"A program is trying to automatically trying to send e-mail messages on your
behalf. Do you want to allow this?"
or "A program is trying to automatically access email address that you have
stored in Outlook. Do you want to allow this?"
This article shows you a tool to help you solve this and also shows how to put
the code into an Access database.
23/12/2005 6:38 AM
Find Out 13 Reasons To Upgrade To Visual Studio 2005
Find out why you would upgrade to Visual Studio 2005 from VB6 or ???
† Performance and functional enhancements to ADO.NET
† Language enhancements to C#
† Language enhancements to Visual Basic
† New Windows Forms capabilities
† New Web applications capabilities
† Click-once capabilities
† New features in the Visual Studio IDE to increase developer productivity
† SQL Server 2005 enhancements
† Crystal Reports.NET enhancements
† New features in the Visual Studio debugger
† Visual Studio 2005 Tools for Microsoft Office (managed code add-ins)
† An overview of Visual Studio Team System
† The new XML editor
23/12/2005 6:32 AM
Visual Studio Tools For Office 2005
Learn what Visual Studio Tools 2005 can do for your Excel, Word, Outlook and
InfoPath world by visiting the Microsoft website. Nothing mentioned about
Access.
22/12/2005 11:25 PM
The Evolution Of Access Databases
Luke Chung from FMS writes a wonderful article on Access databases and their
place in the evolution of time. One particular point that he makes that I must
admit I have never heard of before is “Whilst Access provides a good prototyping
development for server databases, it is better as a tool to decide if a database
is going to survive or not.” This is interesting because when most database
start off, they are terribly important to the persons pushing the concept. The
reality though is that a good percentage of databases waste away after a year or
two and thus aren’t worth upgrading because they were based on a business model
that really wasn’t all the important. To summarize, using Access as your initial
database is a terrific way to decide if the database is actually worth upgrading
to a more expensive to build environment.
Note: Whilst I published this a while ago, Luke pointed me to a better version
of the same article at the FMS web site. I commend this article to anyone who
has to persuade a client that Access is worthwhile and then why that is so.
Garry
16/12/2005 9:20 AM
Buglight for Developers
Microsoft has been beating ever more loudly the least-privileged user account (LUA)
drum. While Microsoft, partners and customers acknowledge that systems are far
more secure when users aren't designated as admins, software compatibility
issues have hampered LUA's widespread adoption.
To try to remedy this disconnect, Microsoft is readying a new tool, tentatively
named "LUA Buglight," that will find code bugs that impact compatibility for
non-admin users. A pre-alpha version of the tool is being tested now, and
Microsoft hopes to make it available early next year.
15/12/2005 10:11 AM
Beginning SQL Server 2005 Express Database Applications with Visual Basic
Express and Visual Web Developer Express
Rick Dobson’s most recent book on SQL Server Express has now been published.
13/11/2005 8:56 PM
New Version of Workbench For Microsoft Access Released
VBWire Announcement - Support for MDE compiles in Access 97, 2000, 2002/XP and
2003. Tightened up the process for database decompiles to guide the user to
follow the correct procedures for a proper decompile. Built in support for the
vb123 rss/xml feed so that you can read it without an RSS reader. Better support
for resellers of the Workbench.
13/12/2005 4:33 AM
Upgrading Visual Basic 6.0 Applications to Visual Basic .NET and Visual Basic
2005
This guide provides valuable information for organizations who are considering
upgrading their Visual Basic 6.0-based applications and components to Visual
Basic .NET. It provides proven practices to reach functional equivalence with a
minimal amount of effort and cost and guidance for common advancements after the
application is running on the .NET framework.
In addition to the guidance itself, a new tool, the Visual Basic 6.0 Upgrade
Assessment Tool, is provided to give your organization assistance in identifying
common upgrade issues and estimating the cost and effort required to upgrade
your Visual Basic 6.0 code.
30/11/2005 10:51 AM
Repair Damaged Access Databases (25% Off Till end of January)
vb123.com now offers an online repair system for Access databases. Included in
the latest version is the option to only repair tables rather than fix the whole
database. This reduces the cost of exercise. The system is setup so that your
data is encrypted and in most cases, you should be able to recover a corrupt
database in less than 30 minutes elapsed time.
< WRAPPING THIS EDITION UP >
It’s been really hot down
here in Australia this month with one day being the second hottest day ever
recorded in Sydney 45C/113F. If you are reading this newsletter just before you
are going home, don’t forget to shutdown your computer to save energy and stop
the power plant from burning coal. If you happen to own a power plant, can you
please switch to cleaner coal or solar panels so that fewer pollutants are
released into the atmosphere and it doesn’t get so hot. Now I am off to the
beach for a swim
J
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. And if you can,
have a look at our software by using the Marketing section on the left hand side
of this newsletter. If you really like this newsletter, why not purchase
The Toolshed and you will get all
the other newsletters and plenty more in a developer’s knowledge base tool with
super searching facilities.
Garry Robinson - Software Consultant and Author
--- The end of this edition of Access Unlimited ---
PS Don’t forget the Workbench … http://www.vb123.com/workbench/
Click on this button
to read the previous edition of Access Unlimited
Published 2006-01