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 |
|
|
--- 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 |
|
|
|
Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly
accurate SQL query
|
|
|
|
Find out who has your database open, start the correct version of Access,
easy compacting and backups, change startup options, creation versions,
shutdown database.
|
|
|
|
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
|
|
|
|
Receive a free Toolbox when you purchase FMS tools like Total Access
Analyzer, Total Visual Code
|
|
|
|
If you need help with a database, our Professionals could be the answer. |
|
Produced by |
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