|
|
| 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 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 Toolshed 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 Microsoft Office Access MVP |