Thursday, December 31, 2009

Doug Steele's Page Is Complete

Doug's Smart Access authors page is now pretty well complete with 25 Access articles setup at http://www.vb123.com/pages/kb/Doug_Steele.aspx. Topics include list and combo boxes, dsn's, message boxes, lots of date handling articles. Most important are the names that he choose for the articles like "These are a few of my favourite things", "Excelling automatically" and "I've Got Plenty of Nothing, and Did Someone Say Holiday"

Tuesday, December 29, 2009

Some Welcome Rain

Just 3 days after I sent out my Xmas cards with a picture of my Brother-In-Laws very dry farm, rain swept in from a cyclone and many areas of NSW and Queensland suffering years of drought are rejoicing in the perfect Xmas present. I saw one place where the big river was dry for 2 years and it rose to a depth of 4 metres in a few hours.

Saturday, December 26, 2009

The next version of Access is going to feature Web hosting features and to help with this will be the Web Compatibility helper.  It even has it own product manager.  Read more on the web compatibility tester

Monday, November 30, 2009

Test new screen resolutions in the Workbench


One of the simplest and more useful options in the Workbench is the Screen Resolution tester. One click and it shows you the correct size of screen. Then you position your Access system on the top and test how it works at that resolution.


Wednesday, November 25, 2009

November Newsletter - 20 more articles posted to vb123.com


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

This month I traveled to OfficeDevCon in Brisbane to see and hear more about the tools that I work with day and day out and I liked what I saw in Access 2010. What really stood out in the Access 2010 talks is the amount of lolly ($$$) Microsoft is putting into Access. Firstly there is going to be Access Services that runs in the Web (read SharePoint) and it looks pretty compelling. Will it take off? History shows that most New Features through last decade flopped but if this one is big with SharePoint centric IT departments, it could be a winner. Another thing in 2010s favour is that it is 2nd Generation so IT departments cannot hold off for another release.

What does look compelling in A2010 are data macros. These are macros that perform actions when data is added and changed. Imagine what 100% guaranteed calculated fields will do for making your application "quicker to write". Along those lines, Macro's themselves have been overhauled to ensure they are viable as the programming environment for Web based Access. If you have a PC lying around that you can install it on, the public Office beta is out now.

That aside, what I really enjoyed about the conference was meeting people including Armen Stein, Rob Cooper and Luke Chung who traveled long distances from the US to be with us. I hope you Aussies and New Zealanders readers can make it to the next conference in 2010.

What follows are lots more links to articles from the Smart Access collection and if you look around the site, you will find over 150 articles and editorials are online now..

Enjoy the newsletter

Garry Robinson
Microsoft Access MVP


Products


SQL Upsizer

Workbench

Smart Access

FMS Products

Can we help?





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

Read More



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

Read More



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

Read More



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

Read More



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

Read More



--- 18/11/2009 ------------------------------------------------------------------------------------------


No Problems Boss !


In this timeless editorial, Peter Vogel discusses the No Problem Problem.

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.

Read More



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

Read More



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

Read More



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

Read More



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

Read More



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

Read More



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

Read More



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

Read More



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

Read More



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

Read More



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

Read More



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

Read More



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

Read More



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

Read More



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

Read More



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

Read More



--- 20/10/2009 ------------------------------------------------------------------------------------------


Zoom, Zoom, Zoom


Chris Weber shows you how to let your users to zoom in and out of datasheet subforms.

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


Read More



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

Read More



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

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

Wednesday, November 18, 2009

Inspirational Effort

Paralympian Kurt Fearnley crawls Papua New Guinea's Kokoda Track ten days after winning New York wheelchair marathon. Wow !!

Thursday, November 12, 2009

Renaming a Bunch of Tables

I am working on a conversion database that requires linking to lots of tables in lots of databases with exactly the same tables. I then need to rename the linked tables to remove the Suffix of 1 (that appears on all linked tables that are the same) and give the new linked tables a new prefix . Here is the code to do that


Private Sub cboLive_Click()

Dim tbl As DAO.TableDef

For Each tbl In CurrentDb.TableDefs
If Right$(tbl.Name, 1) = "1" Then
tbl.Name = "MyPrefix_" & Left$(tbl.Name, Len(tbl.Name) - 1)
End If
Next

End Sub


Here is a similar post for removing DBO prefix for SQL linking.

How Do You Link To / Attach to An Access Query

The only way that I have found to link to a Query in another Access database is using a Query and Changing the path to the database as shown in the following photos. Check out an article that I wrote on Remote Queries a while back






















Wednesday, November 11, 2009

SageKey

Are there any Access users with SageKey experience? If so send me an email using

access [at] gr-fx.com and tell me what you think about the software.

http://www.sagekey.com/installation_access.aspx

Monday, October 26, 2009

The 50% Up is a Lot Less the 50% Down Rule

My last post on stock markets I promise.

Protect your self against a plunging stock market by selling a bit now. Why, because there is a good statistical/historical probability that the market may plunge again soon.
http://ozsilverlining.blogspot.com/

Friday, October 23, 2009

Office DevCon 2009

Well, only a week to go until Office DevCon 2009. Attached please find the Official Conference Schedule.

You can also download if from
http://www.officedevcon.com.au/2009/download/2009schedule.pdf .

Don't forget to let your friends and colleagues know about the conference, and urge them to register at http://www.officedevcon.com.au/2009/register.htm before it's too late.

Graham R Seach
Office DevCon Administrator
Access MVP

Wednesday, October 21, 2009

Upgrading to Windows 7 from Vista

First thing is to search for
"Windows 7 Upgrade Advisor"

and try it.

Then its BACKUP time............ and then you can do the upgrade (if you are game)

The upgrade process took about 2 hours from inserting the DVD on my laptop.

After the upgrade, just about everything worked, for Access developers, the ability to switch between Access versions fell back into the old UAC trap discussed here.
http://www.vb123.com/workbench/help/switching.htm

Once you have made the jump, virtual PC is place to run those old Apps
http://www.microsoft.com/windows/virtual-pc/






Tuesday, October 20, 2009

Access Unlimited Newsletter October





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

In the last edition of this magazine, I asked the readers if you would be interested in paying for Smart Access 2007 converted content. In summary 50% of you said you would rather that we continue posting existing 2003 content and as there was not enough people willing at this stage to fork out cash for 2007 content, we will continue as is.


Here are lots more links to articles from the Smart Access collection and if you look around the site, you will find over 100 articles and editorials are online now..

Enjoy the newsletter

Garry Robinson
Microsoft Access MVP


Products


SQL Upsizer

Workbench

Smart Access

FMS Products

Can we help?





--- 15/10/2009 ------------------------------------------------------------------------------------------


The AutoExec Macro explained


Access has a starting mechanism called the AutoExec macro. This macro has been around since Access 2 and is still an important foundation for protecting your database. When your database opens, Access first processes the startup options and then looks for and runs the AutoExec macro.

Read More



--- 15/10/2009 ------------------------------------------------------------------------------------------


You Can Do That with Datasheets?


Everyone who uses datasheets knows they're powerful, but very few people know all of the things you can do with them. Michael Kaplan pulls out a handful of tricks from the unlocked Access 97 wizards that can help you really get the best of these useful items.

Read More



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

Read More



--- 14/10/2009 ------------------------------------------------------------------------------------------


An ADO Tutorial: What is ADO?


In this article, Russell Sinclair provides a primer on what you need to know about ADO: what it is, why you should care, ADO's relation to OLE DB, and a tour of the major objects in ADO.

Read More



--- 9/10/2009 ------------------------------------------------------------------------------------------


# The Aussie DevCon Conference Is ON #


The year the Office DevCon Conference is going to be held in Brisbane at the end of October. Here is the session link.

http://www.officedevcon.com.au/2009/sessions.htm

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.

Note that Rob Cooper, the Test Lead on the Access team at Microsoft will talking about Access 2010 and Luke Chung and Armen Stein are also making the trip to Oz from the USA.

Read More



--- 8/10/2009 ------------------------------------------------------------------------------------------


Access Answers: Tricks With Combo Boxes


Doug Steele show you how to manipulate a ComboBox to display multiple fields and how to synchronize one Combo box with another.

Read More












--- 7/10/2009 ------------------------------------------------------------------------------------------


SQL without Joins


If you always join tables you put in a query, then you aren’t taking advantage of one of the fundamental features of SQL. Not only that, Peter writes, but you’re also missing an opportunity to see how SQL really works.

Read More



--- 20/09/2009 ------------------------------------------------------------------------------------------


Alternative Access Buttons


With Access, the rule for buttons seems to be "You can have any color button you want, as long as it's Battleship Grey." But you don't have to be that limited: You can expand your buttons' range in color, texture, and functionality, provided that you're prepared to bend the rules a little. Paul Millennas shows you how.

Read More



--- 20/09/2009 ------------------------------------------------------------------------------------------


Everything About AutoNumbers


AutoNumber and identity fields have some benefits—and some costs. In this article, Russell Sinclair covers just about everything you can do to manage AutoNumbers in ADO, ADOX, and DAO. Since most AutoNumber fields are used as primary keys, this is the information you need to manage your tables.

Read More



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

Read More



--- 20/09/2009 ------------------------------------------------------------------------------------------


Access to Excel Automation tricks


Doug Steele looks at several techniques to use Automation from within Access to interact with Excel. By the time he's done, Doug has exported every table in his Access database to separate sheets in an Excel workbook

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.

Read More



--- 20/09/2009 ------------------------------------------------------------------------------------------


Managing Access from .Net


You can automate your Access application from a .NET program–but you'd better watch out. If you're not careful, Access will unexpectedly become unavailable, for instance. More importantly, you need to be able to get rid of Access when you don't want it anymore. Peter Vogel shows how to handle both of these problems.

Read More



--- 20/09/2009 ------------------------------------------------------------------------------------------


Undo in Sub Forms and a General Error Handle Function


Russell Sinclair looks at implementing undo in form-subform applications and then goes on to demonstrate some reusable error-handling code.

Read More



--- 20/09/2009 ------------------------------------------------------------------------------------------


The Easy Approach to Code Reuse


The hard part of code reuse has always been finding that elusive snippet of code that's buried somewhere among hundreds of modules in different databases. This article introduces an easy-to-use library add-in that allows you to quickly access your favorite procedures, plus a look at using the Windows clipboard.

Read More



--- 20/09/2009 ------------------------------------------------------------------------------------------


Product Review: Access 2003 Conversion Toolkit


Danny explains (along with comments from Jon Sigler, Group Program Manager for Microsoft Access) why, if you plan to make your living delivering Microsoft Access applications, you owe it to yourself to consider the Conversion Toolkit's place in your practice.

Read More



--- 20/09/2009 ------------------------------------------------------------------------------------------


Using Access for Email Alterts


How to create Microsoft Access email is a common request. I received the following question a while back and it presented a great opportunity to show how useful Microsoft Access recordsets can be. Microsoft Access recordsets allow you to move through a set of records and use the data contained in them to perform such tasks as emailing, running reports or queries, analyzing data, etc.

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




Results of Our Access 2007 Content Poll













Here are the results of our poll about what sort of content we should work on. Conclusion, keep going with Access 2003 for now.






A data-grid control, a list-view and a tree-view control... all in one

Following from my recent post (A new method for disabling the Mouse Scroll Wheel in Access forms), I've received a lot of e-mail asking what is coming from this new DLL-less machine-code technique that I've developed. (If you haven't yet had a look at the source code, it's definitely worth a look!)

In the user comments I teased that something much larger was in the works. I've now revealed what is coming:

Think "flexible data grid control" and you aren't far wrong.

Using the native machine code technique shown in this article ultimately means that you get a new control without needing any third party DLL.

Key Features;

Supports tree views and list views natively.
Supports live grouping and sorting.
Supports HTML cells (including hyperlinks)
Supports in-built cell controls such as buttons, check boxes, combo boxes.
Supports many different data sources (including SQL/Recordset, optimized internal lists/trees, "on-demand" using VBA callback, and more)
Supports unlimited conditional formatting throughout using a built-in expression compiler for optimal performance.
Supports complex expressions in conditional formatting and for cell sources.
Supports conditional formatting for all available cell properties (not just simple Bold/Underline options like Access).
Supports auto-fit cell widths and/or item heights.
Supports variable item heights.
Supports images / pictures with a variety of transparency options (even for bitmaps).
Supports several gradient options for background fills (for cells and master control).
Supports changing the opacity of fills, allowing for a modern "bleed-through" effect.
Supports rounded corners for items and groups.
Supports the concept of bindings and expressions for all conditional formatting options. For example you can easily bind the background fill color to a field in your datasource, if you wanted to.
Supports conditional formatting inheritence (conditional formatting can be set on each display column and can inherit from a "master" defaults class)
Supports drag 'n' drop.
Supports multi-select.

Sounds interesting? If you would like to be a part of the beta team, please e-mail me now. Beta is starting very soon!

beta@everythingaccess.com

I can only offer a limited number of people to participate in the beta, so please let me know ASAP if you are interested.

Wayne Phillips


As mentioned above, if you are interested in helping beta testing this product with us, please register your interest with me ASAP.

Thanks!

Thursday, October 15, 2009

Null Post on Microsoft Access Blog

One of the very earliest tips from the Smart Access newsletters is featured on the Microsoft team blog The topic is simpler code on testing for Nulls

Tuesday, September 29, 2009

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

Saturday, September 26, 2009

Wednesday, September 23, 2009

.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

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/