vb123.com.au
Access
Unlimited News - 2008 May-October
See all newsletters
Independent news for enthusiastic Microsoft Access and Office readers
| Australian
Readers ~ Access Development/Office
Automation Advertisement If you need help with an Access database such as upgrading to 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 in Australia or email me. http://www.vb123.com.au/professionals/ Garry Robinson, Office Access MVP award winner. |
--- 3/10/2008 ------------------------------------------------------------------------------------------ |
||
|
Repair Damaged Access
Databases |
||
| vb123.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. Garry |
||
--- 3/10/2008 ------------------------------------------------------------------------------------------ |
||
|
Removing
the DBO prefix in Newly Upsized SQL Server Linked tables |
||
| Here is some
code to strip out the DBO prefix on SQL Server linked tables
|
||
--- 30/09/2008 ------------------------------------------------------------------------------------------ |
||
|
Access Protection and Security |
||
| 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. |
||
--- 13/09/2008 ------------------------------------------------------------------------------------------ |
||
|
Subtle Dialog
For Access Workbench |
||
| Switching
between Access 2003 and 2007 improved a lot with service pack 1 of
Office 2007. Even with that improvement, there have been many times when
on opening Access 2007, I wish I hadn't. The latest version of the
Workbench reduces that issue by warning when you are switching from one
Access executable to another so that you can stop. |
||
--- 14/08/2008 ------------------------------------------------------------------------------------------ |
||
|
Validation Rules |
||
| An article at
Microsoft on Access 2007 validation rules by Allen Browne. |
||
--- 5/08/2008 ------------------------------------------------------------------------------------------ |
||
|
Access Report Building |
||
| Article by
Paul Zikopoulos mentions DB2 linked tables but it provides a good
insight into the reporting wizards in Access 2007 |
||
--- 1/08/2008 ------------------------------------------------------------------------------------------ |
||
|
A
New Simple Operating System |
||
| Bumped into
this article about a new operating system from Microsoft. Never a bad
idea to rewrite your software so bring it on I say. |
||
--- 3/08/2008 ------------------------------------------------------------------------------------------ |
||
|
Maxtor One Touch 4 |
||
| Purchased a
Maxtor One Touch 4 drive recently, got a surprise the other day when it
wasn't backing up my Web folders. Well it seems that Seagate changed the
software and its not backing up much at all for anyone. |
||
--- 29/07/2008 ------------------------------------------------------------------------------------------ |
||
|
10 Reasons
Why IT Pros Hate Access (but Shouldn't) |
||
| Here is a
really good summary of the cons and pros of Microsoft Access I will be
using this article by Susan Harkins regularly for customers whose IT
department has issues with Microsoft Access. Here is a great quote from the article "If an Access database works its way up to the department or enterprise level, celebrate its triumph instead of trashing its creator. After all, if the database evolved and grew, your organization is growing, and that's good news for everyone." |
||
--- 25/07/2008 ------------------------------------------------------------------------------------------ |
||
|
Automated Backup of SQL Express |
||
| FMS describe
in simple terms how to backup your SQL server express databases.
|
||
--- 30/07/2008 ------------------------------------------------------------------------------------------ |
||
|
MaxOut Magazine |
||
| Maxout is our
newsletter that combines blog content from a number of Access MVPs and
the Microsoft Access team. It comes out once a week. Here is the latest
incarnation. Sign up at vb123.com.au/news |
||
--- 23/07/2008 ------------------------------------------------------------------------------------------ |
||
|
A
Review Of NitroPDF - A Terrific Example Of A Ribbon Interface
|
||
| Nitro PDF is a
really fun program to use and makes management of PDF files a breeze. In
my view it is the best Ribbon interface that I have used. On of the
reasons for this is that a Ribbon menu is most suited to the tasks of
working on a PDF document. |
||
--- 18/07/2008 ------------------------------------------------------------------------------------------ |
||
|
24
Winning Office 2007 Tips |
||
| Here readers
from a Canadian magazine give their tips for Office 2007 programs. My
own winning tip (yes I picked it myself) for Access 2007 is Right Click,
the menus usually give you the options that you need. |
||
--- 16/07/2008 ------------------------------------------------------------------------------------------ |
||
|
Menu Building Options In Access 2007 |
||
| You can catch
up on some techniques for building menu in Access 2007 here at this
Microsoft page. You will find more links to topics such as calculated
fields in Access 2077 in our MaxOut ezine at http://vb123.com/news over
the next few months. |
||
--- 7/07/2008 ------------------------------------------------------------------------------------------ |
||
|
Data Entry
Tips |
||
| My favourite
data entry tips are Ctrl + and Ctrl " and Ctrl : as described on this
page. |
||
--- 6/07/2008 ------------------------------------------------------------------------------------------ |
||
|
Find
Record Lookup Wizard in Access 2007 |
||
| Recently I
worked on a job where performance was woeful because there was too many
tables with no indexes and really complex sub-forms. Oddly though the
users would find records by moving through the main form record by
record. When I setup a Find Record combo box, they were ecstatic. See
some screen shots on how you setup one up and also find out some
alternative code that I like even better. |
||
--- 21/06/2008 ------------------------------------------------------------------------------------------ |
||
|
Access 2007 Encryption and Passwords ~ How to go 128 bit |
||
| Hello
Microsoft Access fans and skeptics. In this article, I am going to
describe how you can improve on what already is a very significant
security improvement in Access 2007, database encryption. If you are wondering what would be the business reason for using password encryption, a jolly good reason would be theft by a third party who wouldn't have access to the password. Probably not a bad idea for laptop based databases. Read on |
||
--- 21/06/2008 ------------------------------------------------------------------------------------------ |
||
|
We run our Access
consulting business using Basecamp from 37 Signals |
||
| We tie a lot
of our Access consultancy business together using a collaboration tool
called Basecamp from 37Signals. Read more about BaseCamp here or join up
to our new ThickToast newsletter http://www.thicktoast.com where you can
read about Garry's thoughts on BaseCamp and other online providers that
help our business. |
||
--- 3/06/2008 ------------------------------------------------------------------------------------------ |
||
|
Workbench and
Vista |
||
| Here is a page
on how to switch between versions of Access when using Windows Vista.
Help on this topic from Graham Mandeno and Allen Browne. This page just
includes techniques for Access Workbench users. |
||
--- 6/06/2008 ------------------------------------------------------------------------------------------ |
||
|
Video:
How to use sql server profiler to identify Access bottlenecks
|
||
| This video
shows you how to identify what you need to do to speed up in an Access
database that is linked to SQL Server. Click on Menu ~ Fit to screen to
see the text and menus |
||
--- 4/06/2008 ------------------------------------------------------------------------------------------ |
||
|
Organising Your Product Keys and CDs |
||
| This article
is interesting becuase it talks about how to organise all the those
programs and cds. For internet downloaded software, I always save both
the full installs in a folder with a text or html file of the
registration information in a folder called c:\WinSoft. I back this up
regularly. |
||
--- 25/05/2008 ------------------------------------------------------------------------------------------ |
||
|
Access
User Surveillance Starts Here |
||
| In this
article that has been taken from my Access security book, you will find
out how to retrieve the Computer Name, Windows User ID, and Access
Workgroup ID by using VBA code. |
||
--- 23/05/2008 ------------------------------------------------------------------------------------------ |
||
|
Microsoft to Support ODF and PDF in Service Pack of Office 07
|
||
| This article
says that Microsoft will include native support for PDF in Office 2007
service pack 2. Even with the requirement of a download for PDF,
integration into Access 2007 for save report as PDF was one of the best
things in the new product. Here is a sample vba sendto PDF command DoCmd.SendObject acSendReport, sRept, "PDFFormat(*.pdf)", sEmail, , "blaBla@blablabla.com.au", sSubject, sBody, True, "" The original Microsoft post on this is here http://www.microsoft.com/Presspass/press/2008/may08/05-21ExpandedFormatsPR.mspx?rss_fdn=Press%20Releases |
||
--- 15/05/2008 ------------------------------------------------------------------------------------------ |
||
|
Crosstab
Queries in Access |
||
| In this
article Tom Wickerath, an Access MVP from Seattle, explains how to setup
and use crosstab queries in Access. This is the last of four articles by Tom this year and rather than ask for payment for his work, we donated a small amount to the Fred Hollows Foundation, an organisation that helps poor people to regain their eyesight. https://www.hollows.org.au |
||
--- 7/05/2008 ------------------------------------------------------------------------------------------ |
||
|
Read the
last Access Unlimited Newsletter |
||
| Read the last
newsletter online. All the posts from January to April 2008 |
||
--- 31/12/2007 ------------------------------------------------------------------------------------------ |
||
|
Read the latest
Access Unlimited newsletter online |
||
| Greetings to
you all from Sydney Australia. Have a great New Year and enjoy the newsletter. Garry Robinson Access MVP and Editor of vb123.com and vb123.blogspot.com |
||
--- 28/11/2007 ------------------------------------------------------------------------------------------ |
||
|
Garry's Access blog |
||
--- 20/12/2007 ------------------------------------------------------------------------------------------ |
||
|
Weekly
Access Unlimited Email Newsletter ~ Extra Content |
||
| Here you can
get the standard MS Access content plus content from Garry's Blog all in
the same newsletter. |
||
--- 20/12/2007 ------------------------------------------------------------------------------------------ |
||
|
Weekly
Access Unlimited Email Newsletter ~ Maximum Content |
||
| If you want to
see a lot of Access content from a number of different blogs including
our Extra Content, then sign up here. |
||
| 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 |
|
Garry Robinson - Software Consultant
and Author Microsoft Office Access MVP
|
---
To
sign up for Access Unlimited or subscribe to our RSS feed, head to
http://www.vb123.com/news/
To rename, unsubscribe below and then sign up with new email address.
Our Tools and Resources
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
