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

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

Welcome to the latest Access Unlimited Newsletter with lots of new Smart Access posts plus a proposal to upgrade the Smart Access content to 2007/2010 if that's what you want. If this happened, this would be the only Paid for Access magazine on the planet, now wouldn't that be something !

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 conclusion, 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 because this requires a bigger commitment from us? If so, I will divert and apply some new resources to produce an Access 2007 monthly magazine using EDITED Smart Access content and new downloads. In Addition, I could also ask other ex-Smart Access authors to write new 2007/2010 content  if you want to commit to an even better magazine. So please 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).

Fill in the survey here >>> http://vb123.blogspot.com/

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. Testing this in Access 2007 is what takes the time as well as adjusting pictures and text to match the new Ribbon/Document Container Interface.

Here are more links to articles from the Smart Access collection.

Enjoy the newsletter

Garry Robinson
Microsoft Access MVP

Products

SQL Upsizer

Workbench

Smart Access

FMS Products

Can we help?

	--- 30/09/2009  ------------------------------------------------------------------------------------------
	Creating a Great Report
	David Irvine looks at the part that reports play in developing your application. In addition to discussing the issues around development, this article looks at the most effective way to build your reports and some useful (though overlooked) properties.
	--- 20/09/2009  ------------------------------------------------------------------------------------------
	Nulls or Zero Length Strings
	Paul Litwin has a couple of efficient tips for managing nulls and zero length strings.
	Creating Paired Listbox Controls, Part 1
	Presenting a pair of Listbox controls to the user and allowing the user to move an item from one to the other is a popular and effective user interface technique. Microsoft Access doesn't provide any intrinsic controls for performing this, but as Rebecca Riordan demonstrates this month, it's easy to create linked Listbox controls and base them on a single table, two tables, or even data created at runtime.
	--- 27/08/2009  ------------------------------------------------------------------------------------------
	Do you want information about your machine?
	Doug Steele looks at how to tap into the wealth of information available through Windows Management Instrumentation (WMI) including Disk Drives, amount of memory, processors.
	--- 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.
	--- 26/08/2009  ------------------------------------------------------------------------------------------
	Analyze Your Data in Space
	Microsoft Access isn’t known as a tool for displaying spatial or mapping information. But, with a few special tricks, some crosstab queries, and MSGraph, you can transform coordinates into useful maps. Garry Robinson demonstrates techniques that can be used for statistics, graphs, and extending your crosstab queries, regardless of how you want to lay out your data.
	--- 26/08/2009  ------------------------------------------------------------------------------------------
	Client-Server Utilities - Stored Procedure tricks
	If you’re using SQL Server as your back-end database, you’ll get your best performance by using stored procedures. Here, Michael McManus showcases some standard routines to make using those tools a little easier.
	--- 25/08/2009  ------------------------------------------------------------------------------------------
	Forms, Sorting Reports, and Dating Errors
	Andy Baron addresses a variety of issues, including several tips related to forms, a look at how to dynamically sort reports, information on an undocumented feature of Access, and a discussion of how VBA handles certain date/time calculations.
	--- 24/08/2009  ------------------------------------------------------------------------------------------
	Things You Didn't Know You Could Do With Reports
	If you think that reports are boring, Chris Weber and Frank Sutherland are going to show you just how wrong you can be. Topics discussed include Reports on separate pages, showing group headers more clearly, memos reporting issues, overlapping sub-reports and report performance. That should get you excited.
	--- 24/08/2009  ------------------------------------------------------------------------------------------
	Turn your table into a VBA Class
	SMOG is an Access add-in which makes the VBA used in Microsoft (Office) Access more object-oriented and works in versions of Access 2000 onwards. Its main function is the replacement of collections by objects through automatic generation of VBA code to create objects, which are then stored in Standard Modules. Read more about Alan Cossey's new tool
	--- 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.
	--- 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.

Just in case you forgot to respond, tell us if you would like to pay for a 2007 Newsletter here/

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/

To unsubscribe, send an email to notips [@ } gr-fx.com