|
--- 2/11/2009 ------------------------------------------------------------------------------------------
|
|
| Handling Visual Complexity
|
|
| Building a great user interface isn't simple–but the result should be. No matter how complex the task is, your users should find it easy to figure how to use your application. Peter Vogel discusses two kinds of complexity and the strategies for making things simple.
|
|
|
--- 16/11/2009 ------------------------------------------------------------------------------------------
|
|
| Query Queries
|
|
| John Viescas tackles some common problems that are faced by Access developers. Drawing on queries that keep cropping up in the Access newsgroups, John clears up some fundamental problems.
|
|
|
--- 18/11/2009 ------------------------------------------------------------------------------------------
|
|
| # SageKey - Access Installation Done Right + Discount Coupon #
|
|
| The installation is the first thing your customer sees of your application. If you want to make sure your customers have the best first impression of your Microsoft Access based software, you need an installation tool which is dedicated to this purpose.
Deploying an Access application can be daunting - especially when you don't know what software is going to be on the target machine. Of course, any user with another version of Access is going to have to sit through the reconfiguration dialog ("Please wait while Windows configures Microsoft Office Access 2007") and then they could well be faced with "Are you sure you want to run this software".
SageKey will take the guess work out of the install and subsequent running of the application. Our tools are dedicated to this cause and as such your application will appear to be standalone from Access - no reconfiguration dialog, no macro security warnings - no hassles!
You can read more about SageKey's tools at http://www.sagekey.com/installation_access.aspx
COUPON: To receive a special $100 (US) discount, simply enter SMARTACCESS as your promotion code on the order form.
|
|
|
--- 12/11/2009 ------------------------------------------------------------------------------------------
|
|
| What's in a Table?
|
|
| Stu Alderman explores the structure of your Access database and discusses the relationship between Access objects and System tables.
|
|
|
--- 11/11/2009 ------------------------------------------------------------------------------------------
|
|
| Albert Does Access 2010 on The Web
|
|
| If you are interested in how Access might appear in the new Access 2010 webservices, watch this video by Albert Kallal on YouTube http://www.youtube.com/watch?v=AU4mH0jPntI or clearer here
|
|
|
--- 18/11/2009 ------------------------------------------------------------------------------------------
|
|
| No Problems Boss !
|
|
| In this timeless editorial, Peter Vogel discusses the No Problem Problem.
|
|
|
--- 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.
|
|
|
--- 10/11/2009 ------------------------------------------------------------------------------------------
|
|
| The Sub-SubForm You've Always Wanted
|
|
| Access won't let you have a subform within a subform if the data has to be displayed in a continuous form. But necessity is the mother of invention, and Peter Heskett found a way by using senior and junior subforms. He also shares a few other tricks for handling forms.
|
|
|
--- 7/11/2009 ------------------------------------------------------------------------------------------
|
|
| Let Your Users Sort it Out
|
|
| Chris Weber develops a solution that allows users to sort the data in their forms (or subforms) that you can add to your application easily (and spend even less time maintaining). Along the way, he discusses the characteristics of a well-designed module.
|
|
|
--- 2/11/2009 ------------------------------------------------------------------------------------------
|
|
| Comparing ADO and DAO Recordsets
|
|
| Russell turns his attention to the Recordset object and shows the similarities and differences between the DAO and ADO Recordsets.
|
|
|
--- 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.
|
|
|
--- 30/10/2009 ------------------------------------------------------------------------------------------
|
|
| VBA Thoughts By Office Blogger
|
|
| Where is VBA in Office 2010. Its just the same old story which is good, nothing is dropped by the look of things.
|
|
|
--- 27/10/2009 ------------------------------------------------------------------------------------------
|
|
| Six Rules for Effective User Interface Design
|
|
| In this article, Peter returns to the problem of designing effective user interfaces for Microsoft Access. Peter provides you with six rules that you can use to avoid creating "interfaces that suck."
|
|
|
--- 27/10/2009 ------------------------------------------------------------------------------------------
|
|
| Saving Reports is a Snap
|
|
| In this article, Garry Robinson presents a routine that will allow you to save Access reports directly into Snapshot format.
|
|
|
--- 23/10/2009 ------------------------------------------------------------------------------------------
|
|
| Taming the Treeview Control
|
|
| Treeviews are a common (and powerful) tool for creating Windows User Interfaces. Unfortunately, developing with the Treeview control is neither intuitive, nor easy. Doug Den Hoed provides a module that you can reuse to quickly add rich Treeview functionality to your own applications, including a form that your users can play with to create their own Treeviews on the fly!
|
|
|
--- 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 use this program a lot.
|
|
|
--- 23/10/2009 ------------------------------------------------------------------------------------------
|
|
| Using the ADO Objects Effectively
|
|
| Knowing how the ADO objects work isn’t enough. In this article, Russell Sinclair reveals some of the secrets behind using them together.
|
|
|
--- 23/10/2009 ------------------------------------------------------------------------------------------
|
|
| Dual Control - Ensure that more than one person must approve a task
|
|
| In this article, Keith Bombard shows you how to implement dual control in Access to make critical operations more secure by ensuring that more than one person must approve a task.
|
|
|
--- 21/10/2009 ------------------------------------------------------------------------------------------
|
|
| A Good Page for Word VBA
|
|
| This page had some nice Bookmark information for a Word VBA project that I am working on
|
|
|
--- 20/10/2009 ------------------------------------------------------------------------------------------
|
|
| Subquery Notes
|
|
| Following up on a series of articles that have been featured over the past few months, Peter Vogel takes a look at a variety of issues around subqueries -- including those occasions when you shouldn't use a Join.
|
|
|
--- 18/08/2009 ------------------------------------------------------------------------------------------
|
|
| # Convert Access to SQL Server and then to .Net #
|
|
| Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query translation, Then convert to .Net forms and reports in Reporting Services
|
|
|
--- 20/10/2009 ------------------------------------------------------------------------------------------
|
|
| Graph to GIFs and Powerpoint
|
|
| Although it's not listed in the IntelliSense dropdown list, MS Graph supports an Export method that lets you save your charts to GIF format. Doug Den Hoed shows you the benefits of exporting your chart and presents an interesting twist—using Access to create an MS PowerPoint slideshow that animates your charts.
|
|
|
--- 20/10/2009 ------------------------------------------------------------------------------------------
|
|
| Zoom, Zoom, Zoom
|
|
| Chris Weber shows you how to let your users to zoom in and out of datasheet subforms.
|
|
|
--- 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. You can also find a Google Search option with a difference. The search will look at any article that I have linked to from the hundreds of blog posts of the last few years. Check the RHS of at the top of the blog for both of these features
|
|
|
--- 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.
|
|
|
--- 30/09/2008 ------------------------------------------------------------------------------------------
|
|
| # Access Protection and Security Book #
|
|
| If you are still using Access 2000, 2002, 2003 or even Access 97, have you considered my book on Access security. Read the 15 5 star reviews at Amazon.
|
|
|
--- 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.
|
