|
|
--- 14/08/2009
------------------------------------------------------------------------------------------
|
|
|
|
A New Method to Disable the Mouse Scroll Wheel in A2003
|
|
|
|
In Access versions prior to v2007, when you use the mouse scroll wheel on a form, Access will always cycle through the current records in your forms dataset. This is quite an annoyance when you might not want this behavior, and Microsoft never offered a simple solution to turn this feature off (until v2007). Anyway read and download Wayne Phillips new solution.
|
|
|
|
--- 14/08/2009
------------------------------------------------------------------------------------------
|
|
|
|
Migrating Access (and Outlook Data) to SQL Server
|
|
|
|
It's an unusual Jet database that will convert smoothly to SQL Server. Rick Dobson shows how to mix your own code with the Upsizing Wizard. But in many cases it's not just Access data that you need to convert, so he shows how Access can let you move Outlook data into SQL Server.
|
|
|
|
--- 14/08/2009
------------------------------------------------------------------------------------------
|
|
|
|
Data Modelling for the Access Newcomer (part 2)
|
|
|
|
Last month, Glenn Lloyd started outlining his approach to data modeling. This month, he finishes his discussion of the rules that ensure that your database will actually work after you've built it
|
|
|
|
--- 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.
|
|
|
|
--- 31/07/2009
------------------------------------------------------------------------------------------
|
|
|
|
The Macro Designer in Access 2010
|
|
|
|
Access 2007 trotted out a whole lot of new features for the language that no true blue VBA developer ever looks at, Macros. The result in the real world. Well probably not a lot of code. Now in 2010 yet more work and the result is (well there is a reason this may be popular) and its data macros. Anyway have a look at the macro environment snapshots.
|
|
|
|
--- 27/07/2009
------------------------------------------------------------------------------------------
|
|
|
|
Rounded Buttons in Access 2003
|
|
|
|
I always wondered why some forms had rounded buttons in Access 2003 and some didn't. In fact I wished that I could make it happen. Then I stumbled on this tip by Allen Browne
To get the rounded buttons, you need:
- Use Windows Themed Controls on Forms turned on in Access 2003:
Tools | Options | Forms/Reports
- If you don't have a rounded button, search the help for "Themes"
|
|
|
|
--- 20/07/2009
------------------------------------------------------------------------------------------
|
|
|
|
Microsoft SyncToy is more like SyncTool
|
|
|
|
I downloaded SyncToy from Microsoft to make it easier to get modified pages into my Expression Web offline site. So far it looks like a pretty sophisticated file synchronizer with a straightforward user interface. Highly recommended.
|
|
|
|
--- 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.
|
|
|
|
--- 6/07/2009
------------------------------------------------------------------------------------------
|
|
|
|
Max Out Newsletter
|
|
|
|
The website that used to send out our newsletters is coming back to life. If you want to get a newsletter which draws its information from lots of MVP blogs and goes out once a week, signup for the MaxOut newsletter. Its only suited to the people who live and breathe Access programming.
|
|
|
|
--- 2/07/2009
------------------------------------------------------------------------------------------
|
|
|
|
SanDisk USB Backup Stick
|
|
|
|
Purchased a SanDisk USB data stick which has really nice backup software and a backup button on the stick. Little slow in the first pass but good after that. Get 32 or 64 gig disks. The software allows you to select folders really easily but all you SQL Server people, don't forget the SQL Server folders of your development projects.
GR
|
|
|
|
--- 30/06/2009
------------------------------------------------------------------------------------------
|
|
|
|
The Search Engine is a Great Calculator
|
|
|
|
Here is a cool thing that I never realized. Type (25*6.2)/2 into google search box. Hey presto = 77.5
Google is a calculator and Bing also does the same thing.
|
|
|
|
--- 26/06/2009
------------------------------------------------------------------------------------------
|
|
|
|
Search the Document Container in Access 2007
|
|
|
|
Grumble grumble I hear as you switch form the Access 2003 document container (forms, queries etc) to the Navigation Pane in 2007. Well you can claw back some lost time using the search objects feature explained in this FMS kbase article.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
--- 14/08/2009
------------------------------------------------------------------------------------------
|
|
|
|
A Review of Total Access Speller 2002/2003
|
|
|
|
Ever since I have been developing in Access, FMS have been writing products for it. In this article from the Smart Access vaults, Danny Lesandrini takes Total Access Speller for a test drive.
|
|
|
|
--- 1/06/2009
------------------------------------------------------------------------------------------
|
|
|
|
Twitter Twacker
|
|
|
|
Mary Chipman has released a database that will download twitter feeds
|
|
|
|
--- 20/01/2009
------------------------------------------------------------------------------------------
|
|
|
|
# We Are Now Resellers For FMS #
|
|
|
|
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.
|
|
|
|
--- 7/05/2008
------------------------------------------------------------------------------------------
|
|
|
|
Read the latest at Garry's blog
|
|
|
|
Read the last posts that Garry and Wayne have made on our blog.
|
|
|
|
--- 19/05/2009
------------------------------------------------------------------------------------------
|
|
|
|
# A New Version of The Access Workbench is available #
|
|
|
|
The new version features
1) A second backup location to allow for rapid switching of the location where the backups are sent to. This is targeted at portable drives or maybe network drive locations.
2) Support for auto-file version creation to allow you to make more quick backups of your database into a version labelled zip file.
3) The Favorites is now the primary Tab when you open the Workbench, the current Tab is no longer the primary tab.
4) Easy quick link to our News and Blog pages online.
5) Support for better switching options between Access 2003/02/00 & Access 2007 to avoid having the different versions open at the same time
|
|
|
|
--- 10/08/2009
------------------------------------------------------------------------------------------
|
|
|
|
Clipboard Links
|
|
|
|
Steve asks "Is it possible to write a string directly to the Clipboard?
To which Karl points out
How to Send Information to the Clipboard
http://support.microsoft.com/?kbid=210216
How to Retrieve Information from the Clipboard
http://support.microsoft.com/?kbid=210213
|
|
|
|
--- 23/05/2009
------------------------------------------------------------------------------------------
|
|
|
|
Armen Stein Writes about Fixed Price Projects
|
|
|
|
Armen writes that he is not a fan and its not because the developer gets burnt, its because the fixed price project sends the project in the wrong direction.
Garry
BTW. Armen is great speaker who gives his time every year to travel to Sydney to talk, go and listen to him if he is at a conference near you.
|
|
|
|
--- 21/05/2009
------------------------------------------------------------------------------------------
|
|
|
|
Build Access 2007 ribbons
|
|
|
|
In this article I discuss how you can get up to speed with Access 2007 Ribbons using a download from Gunter Avenius.
|
|
|
|
--- 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.
|
|
|
|
|
|
