vb123.com

Garry Robinson's Popular MS Access, Office and VB Resource Site

  

Home  Contact Us
Order our Software


 Smart Access 
The Magazine that Access Developers loved to read and write for is back Read More

RSS & Newsletter  
Join our XML/RSS Newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics
Read More

Get Good Help
If you need help with a database, our Professionals could be the answer
Read More

  Is Your Database Corrupt ?
If you have a corrupt database, Try our Access Recovery service

The Workbench  Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, mde compile,  shutdown database Read and Download

Access >>> SQL 
Upsize to SQL Server 2005 or 2008, easily repeated conversions, highly accurate SQL query
translation and web form conversion.
Read More

The Toolbox
Libraries of software that we regularly import into our projects. This is a newer version of the Toolshed More..

 

SharePoint
For our company file sharing and task management, we use
SharePointHosting
Datamining/Graphs
Explore your data with this versatile graphing and data mining shareware tool.  Read More

DryToast 
Backup and query your BaseCamp® projects
Read More

Garry's Blog
Find out a few other things that Garry has been writing about Microsoft Access. Read more

Like FMS Products?
Purchase them from us and get a free Workbench or Toolbox  More

Smart Access is Back
We have recently purchased exclusive rights to the Smart Access magazine

About The Editor Garry Robinson writes for a number of popular computer magazines, is now a book author and has worked on 100+ Access databases. He is based in Sydney, Australia
Contact Us ...

Search ...

or try our new site built with SharePoint Designer
 vb123.com.au
 

 

Next Tip Access Unlimited News - Edition 79
 See all newsletters

Independent news for enthusiastic Microsoft Access and Office readers

Produced by Garry Robinson from Sydney, Australia.

 
 
Aussie Readers ~ Access Development/Office Automation    Advertisement

If you need help with an Access database or are contemplating upgrading to SQL Server or Access 2007, my experienced developers can help you. Otherwise if you experience spreadsheet meltdown, we are very good at using Access to feed Excel templates. So if you need help, call (02) 9665 2871 or email me.     

http://www.vb123.com.au/professionals/                       Garry Robinson, Office Access MVP award winner.
 


 


--- 5/04/2007  ------------------------------------------------------------------------------------------
 
  Read the latest Access Unlimited newsletter online
 		  
  Greetings to you all from Sydney Australia. During the last month I have been busy.setting up a database that combines a SQL Server database with a number of million record line tables (ODBC links), two access databases and 3 linked text files. Amazingly if you respect the primary keys when setting up your interface, everything hums along at a reasonable pace. Included in the this is a Tab control that holds five sub-forms of related data. My hat goes off to Access, it is a wonderful tool for pulling data together.

Enjoy the newsletter.


Garry Robinson
Access MVP and Editor of vb123.com and vb123.blogspot.com
 		  

--- 8/07/2007  ------------------------------------------------------------------------------------------
 
  Right-Click Microsoft Access Menus ~ Excerpt from Garry's Protection Book
 		  
  Right Click menus allow Access users and developers flexible access to all the built-in menu items and, indirectly, to any objects in your database. Though this flexibility is good for a developer's productivity, it is not necessarily so good when it is available to the users of your database. In my experience, most users are interested in software that makes their job easier. Right Click menus bulging with developer options (such as the Design View and Database Window commands) probably do not assist in that aim. In addition, if users are technologically competent,they may be tempted to alter the programming objects of your database. Therefore, it is important that you learn how to use Right Click menus to setup a good user interface and to protect your database at the same time.

TIP: For Access 2007 developers and those thinking ahead, whilst the old menus and the top toolbars may have been replaced by ribbons, right click menus still persist in the user interface. So if you can add your custom right click menus before upgrading, your database will be protected in Access 2007 as well.
 		  

--- 28/06/2007  ------------------------------------------------------------------------------------------
 
  Pinpointing where a crash occurs in your VBA code
 		  
  Luke Chung from FMS writes about trapping error handling in Access vba.


 		  

--- 27/06/2007  ------------------------------------------------------------------------------------------
 
  Free Access 2007 Developer Extensions
 		  
  On this page you will find out more about the free runtime kit and developer extensions for Access 2007.
 		  

--- 25/01/2007  ------------------------------------------------------------------------------------------
 
  Repair Damaged Access Databases
 		  
  vb123.com offers an online repair system for Access databases. Included in the latest version is the option to only repair tables rather than fix the whole database. This reduces the cost of exercise. The system is setup so that your data is encrypted and in most cases, you should be able to recover a corrupt database in less than 30 minutes elapsed time.
 		  

--- 20/06/2007  ------------------------------------------------------------------------------------------
 
  Google Docs and Word File Collaberation
 		  
  Woodies watch gives a good overview about collaboration with Office Word and Google Docs
 		  

--- 1/11/2006  ------------------------------------------------------------------------------------------
 
  Read the last Access Unlimited Newsletter
 		  
  Read the last newsletter online.

 		  
     
The Workbench    Advertisement

 Find out who has your database open, start the correct version of Access, easy compacting and backups, change startup options, mde compile,  shutdown database Read and Download

Datamining/Graphs
Explore your data with this versatile graphing and data mining shareware tool. Now in Access 2007.  Read More