You Decide - Shall I Continue With Access 2003 Smart Access Posts or Start an Access 2007 Magazine

A few weeks ago I started an online survey to see what version(s) of Access people were using and the result from 430 responses was not quite what I was expecting. In first place with 43% was Access 2003, Access 2007 was 33%, and Access 2002/2000/97 all clocked 6-8%. Access 2010 beta clocked 7 people. Another interesting stat was that 30% of the readers were using more than one version of Access.

So what does this mean ? Well to me there is only one standout, I expected Access 2007 to be less than 20% and Access 2003 to be at least 60%, clearly I have misjudged my audience a bit. So I must ask a big question from you the readers, are you willing to pay for Access 2007 content ? If so, I will divert and apply some new resources to produce an Access 2007 monthly magazine using EDITED Smart Access content as long as you, the reader, are willing to commit to paying for the content. I could also ask other Ex-Smart Access authors to write content if you want to commit to an even better magazine. So please consider the Survey above and choose what you would like us to do (please think of this as a pledge to pay rather than just a quick tick and maybe I will pay later response).

Note: I am happy to continue to post the Access 2003/2000/97 content from the 400 Smart Access articles in its original format because it helps sell the back catalog. Also note that many of the articles are VBA and will probably run untouched in Access 2007.

Garry Robinson
Editor of vb123.com/kb - The new home of Smart Access

Access Validation With One Line of Code

Bob Heifler shows you how to use tags to verify data entry.

.Net Programming for Iphone

I don't have an iPhone and .Net enterprise programming isn't my cuppa tea but here is a discussion on a .Net platform for programming iPhones

August, 2009 Newsletter No 3

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
Here are another 10 links to articles from the Smart Access collection. There is also a survey to find out which version(s) of Access you are using in your work, surprisingly Access 2007 is leading in the early polls. Many thanks to all those people who have provided me with great inspiration by buying the Smart Access collections in the last couple of months. Enjoy the newsletter Garry Robinson Microsoft Access MVP Products SQL Upsizer Workbench Smart Access FMS Products Can we help? --- 24/08/2009 ------------------------------------------------------------------------------------------ Dynamic Checklists Users like to see the big picture, and often that includes items they've selected as well as what they haven't selected. Check boxes are interface widgets that meet these needs, but they can be cumbersome to maintain. Chris Weber shows us his technique for creating dynamically generated check box lists that don't require intervention by the developer when the possible selections change. --- 19/08/2009 ------------------------------------------------------------------------------------------ Survey - Which is the most popular version of Access What version of Access are you using ? Follow the link to see the results so far --- 24/08/2009 ------------------------------------------------------------------------------------------ SharePoint and Microsoft Access - Getting Motivated Embracing new technology is always a challenge and in every version, the Microsoft Access team throws up a new one. This article discusses how you can get SharePoint motivated.. --- 24/08/2009 ------------------------------------------------------------------------------------------ Drilling with Combo Boxes Jeff Ruffner provides a comprehensive look at how you can use your combo boxes for more than just selecting values. --- 24/08/2009 ------------------------------------------------------------------------------------------ Access 2003 and XML Peter Vogel explains XML and XLST in Access 2003 --- 19/08/2009 ------------------------------------------------------------------------------------------ Access Answers: Let me check my list... In this article, Doug Steele looks at various ways of using the List Box control including Multi-Select , moving items between lists, using non table record sources and showing all tables in a database in a list box . --- 24/08/2009 ------------------------------------------------------------------------------------------ An Access 2010 Preview Danny Lesandrini gives a neat overview of things coming our way in Access 2010. The standout for me is Table Macros, this could resolve some of the workarounds that one has to do in Access to satisfy on-the-fly calculation requests. --- 23/08/2009 ------------------------------------------------------------------------------------------ Use your combo boxes for more than just selecting values In this article, Jeff Ruffner demonstrates how to use combo boxes to create a powerful and intuitive "drill-down" user interface for displaying a hierarchical data structure and resolves some other combo box annoyances. --- 29/03/2009 ------------------------------------------------------------------------------------------ # Repair Damaged Access Databases # Everythingaccess.com offers an online repair system for Access databases. The system is setup so that your data is encrypted before it is transmitted and in most cases, you should be able to recover a corrupt database in less than 30 minutes elapsed time. --- 20/08/2009 ------------------------------------------------------------------------------------------ An Access Project, Part 1: Requirements Gathering In this article, I'm going to lay out the requirements for the system. In an Access publication, this might seem like a waste of your time, but -- as discussed in Mike Gunderloy's article, "The ABCs of Requirements Management for Access," in the November 1997 issue of Smart Access -- this document is as important as the code that's eventually produced. --- 20/08/2009 ------------------------------------------------------------------------------------------ What Every Access Developer Needs to Know about Word Sometimes, as an Access Developer you need a more powerful reporting tool than Access's internal reporting feature. Microsoft Word can give you the power that you need. Cindy Meister's article covers the topics that every Access developer needs to know about Microsoft Word. --- 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. Here is a handy tip. If you have a new Blogger (or blogspot) website, have a look at the gadgets and you will find a Google Search option with a difference. The search will look at any article that you have linked to from your blog. Talk about a fantastic way to build a knowledge base. Check the RHS of at the top of the blog for both of these features GR --- 19/08/2009 ------------------------------------------------------------------------------------------ Review: FMS Total Access Analyzer 2000 How well do you know your own Microsoft Access database applications? Over time, even simple projects collect unused objects, hidden errors, and performance bottlenecks. FMS Inc. has always been at the forefront, arming developers with analyzer tools to simplify application problem-solving and documentation. Read this product review from the Access vault but naturally you will probably be buying a newer version of the product from us :) --- 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. --- 18/08/2009 ------------------------------------------------------------------------------------------ Smart Access Biography Needed I am looking for a current bio for the 100+ people who wrote for Smart Access. If you were a writer or know someone that was, send them to this page. Garry Robinson
Product Descriptions 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
To sign up for Access Unlimited, send a blank email to tips [at] vb123.com To subscribe to our RSS feed, head to http://www.vb123.com/news/

Rate Our Website

If there is anyone who likes our new Smart Access inspired website http://www.vb123.com/kb and wants to rate or comment on the site, head to http://www.alexa.com/siteinfo/vb123.com

Garry Robinson

Doing Sub Totals In Excel Lists

I was asked to add subtotals to a list that we exported from Access using Automation the other day. This page describes one way that I could do it. To do it in Automation, I will turn on the Excel macro recorder, capture the code and then add that to my export code. Thats the theory, I wonder if I will get asked formally to do it.

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