|
---
2/03/2010
------------------------------------------------------------------------------------------
|
|
|
Outlook Linked Tables and a Flutter On The
Stock Market
|
|
| |
Last year I
spent a lot of time losing money on shares and making a little. To help in
that pursuit I wrote an Access databases to read the share emails
|
|
|
---
17/02/2010
------------------------------------------------------------------------------------------
|
|
|
Do More for Less - Transferring Logic
Through Your App
|
|
| |
You're probably
doing too much work–you should be taking advantage of your DBMS's
facilities to get more done in less time. Andrew Wrigley discusses how the
principles of declarative design, cascading, and overriding let you have
Jet, SQL Server do more work for you.
|
|
|
---
18/08/2009
------------------------------------------------------------------------------------------
|
|
|
# Convert Access to SQL Server #
|
|
| |
Upsize to SQL
Server 2005 or 2008, easily repeated conversions, highly accurate SQL
query translation and web form conversion.
|
|
|
---
10/02/2010
------------------------------------------------------------------------------------------
|
|
|
Displaying Hierarchical Data in a TreeView
|
|
| |
Thanks to the
way that Windows Explorer handles folders and subfolders, your users are
used to being able to work with hierarchical data using a TreeView
control. Glenn Lloyd shows how to incorporate a TreeView control into your
application.
|
|
|
---
3/02/2010
------------------------------------------------------------------------------------------
|
|
|
Case Study: Researching Data by Peter Vogel
|
|
| |
Peter takes on a
research study database. In addition to showing how you can apply your
skill with SQL to solve a problem that might have required several hours
of VBA code, Peter also demonstrates some SQL tricks of the trade.
|
|
|
---
21/01/2010
------------------------------------------------------------------------------------------
|
|
|
All The Access MVP's and Their Sites and/or
The Way They Contribute To The Access Community
|
|
| |
The Official
Access blog has a comprehensive listing of most of the Access MVPs and
what they do to gain their rewards. Having met quite a lot of these
people, they are not only helpful but they are great fun as well. I look
forward to seeing most of them again in Seattle in February at the yearly
MVP summit.
|
|
|
---
20/01/2009
------------------------------------------------------------------------------------------
|
|
|
# VB123 is a Reseller of FMS Total Access
Tools #
|
|
| |
Purchase FMS
Software from us and you will find yourself with the latest version of our
software for almost nothing. If you head to our FMS page, you will find
the option to read about and purchase FMS Visual Code Tools, Total Access
Analyzer, Total Access Emailer and Total Access Detective. Also if you
purchase FMS Software, you can qualify for free copies of our popular
Access Workbench or Toolbox Resource kit.
|
|
|
---
17/01/2010
------------------------------------------------------------------------------------------
|
|
|
Soundex: "Close" Only Counts in Horseshoes
by Doug Steele
|
|
| |
Doug Steele
looks at a couple of techniques to help determine when text entries are
"close enough" to be considered the same.
|
|
|
---
14/01/2010
------------------------------------------------------------------------------------------
|
|
|
Querying a Customer Survey Table
|
|
| |
Some customers
have agreed to participate in a survey and others haven't and I need to
give both numbers as a percentage of the total number of customers,
grouped by city.
|
|
|
---
13/01/2010
------------------------------------------------------------------------------------------
|
|
|
Access 2010 deprecated features and
components
|
|
| |
In case you
don't read the Access blog, here are some things that will not be in
Access 2010.
Snapshot reports
DAP pages not supported at all
The Calendar Control OCX that used to be shipped with the product.
Support for Access 2, Lotus and Paradox imports and a few other old
formats are not supported.
|
|
|
---
12/01/2010
------------------------------------------------------------------------------------------
|
|
|
Easy as Pie
|
|
| |
Chris Weber
provides you with a generic method to control the data for pie charts that
are actually readable.
|
|
|
---
19/05/2009
------------------------------------------------------------------------------------------
|
|
|
# The Access Workbench #
|
|
| |
Find out who has
your database open, start the correct version of Access, easy compacting
and backups, change startup options, create version zip files, shutdown
database all in a simple interface. We use this program a lot.
|
|
|
---
12/01/2010
------------------------------------------------------------------------------------------
|
|
|
New Workbench Help Pages
|
|
| |
Our Workbench
tool has seen gradual progression over the last year. See the ShortCuts
page http://www.vb123.com/workbench/help/shortcut.htm and the Switching
Access Executables page http://www.vb123.com/workbench/help/switch.htm to
find out more
|
|
|
---
6/01/2010
------------------------------------------------------------------------------------------
|
|
|
Logging Access Startup Details and Version
Control
|
|
| |
Often, in order
to get the best performance from your application (or determine what's
going wrong with it), you have to know what your application is really
doing. That's the role of logging: providing a trail of what was going on
with your application. Garry Robinson shows you how to keep track of some
key information about your Access database.
|
|
|
---
5/01/2010
------------------------------------------------------------------------------------------
|
|
|
DAO verses ADO - A Historical Perspective
|
|
| |
There’s been a
lot of talk these days about how obsolete DAO is and how all code should
be ported to use ADO and ADOx as soon as you can manage. Michael and
Karleen, however, discuss several areas where ADO falls short and where
you’re still going to need DAO. Note: This article was called Don’t Stick
the Fork in, They’re Not Done Yet"
|
|
|
---
18/08/2009
------------------------------------------------------------------------------------------
|
|
|
# Convert Access to SQL Server and then to
.Net #
|
|
| |
Upsize to SQL
Server 2005 or 2008, easily repeated conversions, highly accurate SQL
query translation, Then convert to .Net forms and reports in Reporting
Services
|
|
|
---
2/01/2010
------------------------------------------------------------------------------------------
|
|
|
The Trouble With Normal
|
|
| |
Peter provides
the essential background on normalization. In this article, Peter looks at
first normal form and provides a different perspective on primary keys.
More importantly, here's why you should care about first normal form.
|
|
|
---
30/12/2009
------------------------------------------------------------------------------------------
|
|
|
Msgbox Bonus Features
|
|
| |
This month, Doug
Steele looks at some ways to enhance the common MessageBox.
|
|
|
---
29/12/2009
------------------------------------------------------------------------------------------
|
|
|
Just-In-Time Queries
|
|
| |
In this article,
Frank Kegley illustrates a technique where a query is constructed, used,
and destroyed via Visual Basic for Applications code that executes during
the lifetime of the form or report that uses it.
|
|
|
---
29/12/2009
------------------------------------------------------------------------------------------
|
|
|
File Open Dialog Options
|
|
| |
If you use the
File Open dialog and install your application on multiple computers,
you'll eventually find an ugly surprise waiting for you on Windows
XP/Vista. Peter Vogel looks at the two solutions available to you.
|
|
|
---
19/08/2009
------------------------------------------------------------------------------------------
|
|
|
# Read the latest at Garry's blog #
|
|
| |
Read the last
posts that Garry and Wayne have made on our blog. The blog now has a new
layout so you can see posts that are heading into the next newsletter
before it is posted. You can also find a Google Search option with a
difference. The search will look at any article that I have linked to from
the hundreds of blog posts of the last few years. Check the RHS of at the
top of the blog for both of these features
|
|
|
---
14/08/2009
------------------------------------------------------------------------------------------
|
|
|
# Workbench Help Is Online #
|
|
| |
Following on
from the massive http://www.vb123.com/kb Smart Access project, we are now
rolling out online help for The Access Workbench.
|
|
|
---
30/09/2008
------------------------------------------------------------------------------------------
|
|
|
# Access Protection and Security Book #
|
|
| |
If you are still
using Access 2000, 2002, 2003 or even Access 97, have you considered my
book on Access security. Read the 15 5 star reviews at Amazon.
|
March 2010
See all newsletters