Thursday, September 17, 2009

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.

Read More

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

Read More

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

Read More

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

Read More

--- 24/08/2009 ------------------------------------------------------------------------------------------
Access 2003 and XML
Peter Vogel explains XML and XLST in Access 2003

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

--- 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 :)

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

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

Read More


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



T
o 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/

No comments: