|
|
--- 16/08/2009
------------------------------------------------------------------------------------------
|
|
|
|
Getting Normal
|
|
|
|
In a second article on the normal forms of a relational database, Peter Vogel discusses forms two through four and offers some advice in dealing with management.
|
|
|
|
--- 18/08/2009
------------------------------------------------------------------------------------------
|
|
|
|
The Aussie DevCon Conference Is Back
|
|
|
|
The year the Office DevCon Conference is going to be held in Brisbane at the end of October. Here is what it is all about.
Office DevCon is the largest and most popular annual community-driven conference that allows Microsoft Office developers and power users to come together in one location to hear expert speakers present on a wide range of Microsoft Office-related topics.
|
|
|
|
--- 16/08/2009
------------------------------------------------------------------------------------------
|
|
|
|
You've Got to Have Friends
|
|
|
|
One Peter Vogel's Smart Access editorials from the 1990's on what it means to be an Expert.
|
|
|
|
--- 16/08/2009
------------------------------------------------------------------------------------------
|
|
|
|
Four Ways to Merge to Word
|
|
|
|
The Merge to Word button isn’t the only way to merge Access data into Word documents. In this article, Helen Feddema demonstrates several more flexible methods, useful for creating either single or multiple Word documents and filling them with Access data.
|
|
|
|
--- 16/08/2009
------------------------------------------------------------------------------------------
|
|
|
|
MS Access Can Handle Millisecond Time Values
|
|
|
|
MS Access can retrieve and measure time with millisecond precision, but only with the help of a few well-known API calls and several user-defined functions.
|
|
|
|
--- 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. Note: The Standard MUST product will increase from $150 to $199 at the end of the month.
|
|
|
|
--- 16/08/2009
------------------------------------------------------------------------------------------
|
|
|
|
Review - FMS Total Visual Code Tools 2002-2000
|
|
|
|
If you’ve never been good about coding standards, or your good intentions are sometimes sacrificed when you’re working in crunch mode, then you owe it to yourself to check out Total Visual Code Tools 2002/2003, a great set of coding tools by FMS. Here, Danny Lesandrini walks you through an introduction.
|
|
|
|
--- 16/08/2009
------------------------------------------------------------------------------------------
|
|
|
|
Create a Syslog Sender/Receiver
|
|
|
|
Gustav Brock writes "With the Microsoft WinSock Control and a few coding tricks, you can use Access as a high-performance syslog sender, receiver, and logger."
|
|
|
|
--- 16/08/2009
------------------------------------------------------------------------------------------
|
|
|
|
Client/Server Issues and Getting Access 2000-2003 Under Control
|
|
|
|
Mike Gunderloy’s first answer addresses issues around client/server development, particularly the interactions between Access pass-through queries, SQL Server stored procedures, and Access forms. With that out of the way, Mike then shows how to tame some of the new behavior of Access 2000-2003.
|
|
|
|
--- 16/08/2009
------------------------------------------------------------------------------------------
|
|
|
|
Tip: Watch Out for AutoIndex
|
|
|
|
I keep finding unnecessary indexes in other peoples databases so here is my Auto-Index post once again.
|
|
|
|
--- 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.
|
|
|
|
--- 16/08/2009
------------------------------------------------------------------------------------------
|
|
|
|
Remote Updates of a Back-End Database
|
|
|
|
In a perfect world, the database design for your application would never change. In the real world, most applications grow and acquire new tables, new relationships, new fields, and new features. Garry Robinson and Scott McManus show you how they keep the databases for their clients up-to-date and in sync with each other.
|
|
|
|
--- 16/08/2009
------------------------------------------------------------------------------------------
|
|
|
|
Auto-Generated Update SQL
|
|
|
|
Retrieving data isn't all that you can do with generated SQL statements. Ann Ziegler shows how to create an update-and-append statement on the fly.
|
|
|
|
--- 16/08/2009
------------------------------------------------------------------------------------------
|
|
|
|
Computing the Median
|
|
|
|
You should never calculate the average value of anything without also calculating the median value. Chris Weber explains why and gives you a clean, step-by-step method for deriving the median value from any numeric series. Unlike other published methods, Chris' method uses no temporary tables or custom functions–all you need is a single query.
|
|
|
|
--- 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 have sold 100s of licences.
|
|
|
|
--- 16/08/2009
------------------------------------------------------------------------------------------
|
|
|
|
Using List Regions with Many-to-Many Relationships
|
|
|
|
Many-to-many relationships are a fact of life in real-world applications. They are, however, difficult to display in a typical Access form. The answer: list regions. Rebecca Riordan shows you how to implement this powerful tool in Access.
|
|
|
|
--- 16/08/2009
------------------------------------------------------------------------------------------
|
|
|
|
Programming Pivot Tables for Access Forms
|
|
|
|
Pivot tables represent a powerful way to convey the data in Access databases, and they empower users to perform many tasks that used to require custom programming. In this article, Rick Dobson shows how you can enable your users to manipulate data with pivot tables.
|
|
|
|
--- 16/08/2009
------------------------------------------------------------------------------------------
|
|
|
|
Doug Steele digs into VBA Reference Issues
|
|
|
|
This article explains why Access applications suddenly stop working, or work on some machines but not others.
|
|
|
|
|
|
