Next Tip Access Unlimited News - Edition 80
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) 9340 7789 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 developed a simple workflow document management system just like you would expect from SharePoint Server, only at a fraction of the cost. I love it when I can write Access software that would take a team of specialists to write in other environments. If only the world knew what they were missing out on :-(

Enjoy the newsletter or should I say, enjoy the Blog links.


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

 
 

--- 15/08/2007  ------------------------------------------------------------------------------------------
 
  Garry's Access blog
 
 
  Find how to highlight text in a text, read a good article on SharePoint and Access 2007, find VBA code that will inform your users when they make a change to a record and read some tricky VBA that will make a hidden Tab in a Tab control visible. All this and more in Garry's Access Blog.
 
 

--- 31/07/2007  ------------------------------------------------------------------------------------------
 
  Access Team Blog
 
 
  The developers at Microsoft maintain this site, worth a look in case I forget to relink to it :)
 
 

--- 24/07/2007  ------------------------------------------------------------------------------------------
 
  BLOATed Access Databases
 
 
  Tom Wickerath, Access MVP came up with this wonderful list of Access kbase articles on topics that discuss bloating (expansion) of Access databases. Of particular interest is http://support.microsoft.com/kb/295245/en-us
which discusses problems with the OpenQuery method that can be resolved by Execute method.

 
 

--- 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. It has just been released for the second time after a small hiccup in the install kit.
 
 

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

--- 21/07/2007  ------------------------------------------------------------------------------------------
 
  Accurate and Efficient Data Entry Forms
 
 
  I love these free book chapter postings, here is one on Access 2007 forms. Interesting are the notes on the Collecting Form Data via Email section on page four of the article.
 
 

--- 20/07/2007  ------------------------------------------------------------------------------------------
 
  hlp Files on Vista
 
 
  If you deploy an application or database that uses the .hlp file for documentation, it may not work under Windows Vista. The guys from FMS discuss that here and point to the download at Microsoft to make those files work.
 
 

--- 18/07/2007  ------------------------------------------------------------------------------------------
 
  Tony's Toews New Blog
 
 
  Tony Toews, a fellow Access MVPer tells you all about Autonumber seeding and other things Access in his blog. You may wish to visit this page from time to time.
 
 

--- 10/07/2007  ------------------------------------------------------------------------------------------
 
  Comparisons between Access 2003 and Access 2007
 
 
  Oliver Stohr, a fellow Access MVP has setup a website devoted to comparisons between Access 2003 and Access 2007. Its worth a look if you are considering upgrading. My humble summary of upgrading is "If your users like the new interface for Word, Outlook and Excel, then the new Access will not be a problem to them". I personally like the new Outlook interface and Word and Excel are fine but I don't use them all that much (I just program them).
 
 

--- 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
                    
 
 
So thanks for reading our popular newsletter. Feel free to make comments, copy the email to a friend or maybe even contribute to the next edition. If you really like this newsletter, why not purchase The Toolbox and you will get all the other newsletters and plenty more in a developer’s knowledge base tool with super searching facilities.
 

Garry Robinson - Software Consultant and Author
Editor of vb123.com

Microsoft Office Access MVP

 

Our Tools and Resources

  • RSS & Newsletter Here
    Join our newsfeed or sign up for our informative newsletter on Office Automation, Access and VB topics

  • Smart Access is online 
    The best magazine written about Microsoft Access is now being transferred to the web. There are 400 articles written by a 100 authors in the collection. 

    See the Smart Access 2010 specials here

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

  • Read about the Toolbox
    Sample downloads, library resource kit and searchable help file comprising most of the information at vb123.com.au plus hidden downloads etc.

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

 

 

vb123 Professionals


Get Good Help Here

If you need help with a database or Office programming, our Professionals could be the answer because we have worked on many similar solutions



Frontpage Conversions
We have converted vb123.com to Expression Web, contact us if we can help you move to the latest Microsoft web tool.


About The Editor ~ Contact Us
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

Access 2003 Security

MS Access Security

Read More here