Thursday, September 03, 2009

Access Unlimited Newsletter - August No. 2


The Access Unlimited Newsletter Featuring Smart Access content from the vb123.com knowledgebase and our regular Toolbox information.

Produced by Garry Robinson, Microsoft Access MVP.

Signup or leave newsletter | Contact Us | Need programming help?


Hello Access and Office Professionals and anyone else who wants to listen

The other night I sent out links to many of the pages that I have enjoyed over the last few months and as the steak knife advertisement goes "There's more !" Because there was so many, I held back many of the pages that I have posted in the new Smart Access inspired website. Enjoy the links.

Garry Robinson
Microsoft Access MVP


Products


SQL Upsizer

Workbench

Smart Access

FMS Products

Can we help?





--- 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.

Read More



--- 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.

Read More



--- 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.

Read More



--- 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.


Read More



--- 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.

Read More



--- 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.

Read More



--- 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.

Read More



--- 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."


Read More



--- 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.

Read More



--- 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.

Read More



--- 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.

Read More



--- 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.

Read More



--- 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.

Read More



--- 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.

Read More



--- 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.

Read More



--- 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.

Read More



--- 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.

Read More



--- 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.

Read More






SQL Upsizer

Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query translation and web form conversion using Andy's MUST Access tool.




Workbench

Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, creation versions, shutdown database.




Smart Access

In the editions that we are selling now, there was 300 articles/2000 pages written by over 100 of best Access professionals in the world under the guidance of editor Peter Vogel. Now you can purchase those magazines and accompanying downloads* and use them to improve your understanding of the best rapid development tool in the world, Microsoft Access.




FMS Products

Receive a free Toolbox when you purchase FMS tools like Total Access Analyzer, Total Visual Code Tools and Total Access Emailer from us.




Can we help?

If you need help with a database, our Professionals could be the answer.


Produced by GR-FX Pty Limited | Sydney, Phone: 02 9665 2871 | Email: access at gr-fx.com



No comments: