Back to Back Issues Page
Microsoft Access Tips, Issue #004 (September 2011)
September 27, 2011



I have just snuck in for the September issue. I am writing this Newsletter from Calgary in Canada. My husband and I are just about to embark on a trip over the Rockies which I am really looking forward to. We come over to Canada (primarily Vancouver) every 6 months or so for treatment for my husbands eyes, he has Retinitis Pigmentosa (which is tunnel vision and can result in blindness). There is a Chinese Dr in Vancouver that has had reasonable success in treating the condition with acupuncture. Currently there is no western cure. We usually do a side trip if time and money permits, so this time it is the Rockies. Should be great.

Whilst travelling I purchased a book called the ‘4 hour work week’ which I found to be a very interesting read. As per usual when I read books I take out of it what I can use, and try to implement what I can. Thus I have made a slight change to this Newsletter.

Instead of having the Newsletter contained within this email, I will instead provide you with links to the new pages I have written for my Website. These are still valuable tips, but just being delivered to you in a different format.

I am hoping this will free up some time to finish updating the VBA lessons to 2007-2010. The next issue I will have the first 5 lessons (out of 56) completed and ready for sale. I will then complete 5 more each month. If you have Microsoft Access 2003 or earlier and would like to learn VBA, then

Click here.

Microsoft Access Tips

This month's tips are primarily for users of Microsoft Access 2007/2010, and some of the problems they may have when first using this version of Microsoft Access.

Trusted Locations

Trusted Locations

To ensure your database works correctly when using Microsoft Access 2007 or Microsoft Access 2010, then make sure you include the path to your database in your Trusted Location.

Security Warning

Security Warning

You have opened a database with Microsoft Access 2007 or later and it does not seem to work and you have the following Security Warning 'Certain content in the database has been disabled' this tip will show you what to do, alternatively click on the Trusted Locations link in the previous tip.

Missing Macro Actions (Show all actions)

Missing Macro Actions

If you have opened a database with Microsoft Access 2007 or later and it does not seem to have a Macro action, that you feel sure should be there, then it is probably hidden as Microsoft Access considers it to be unsafe. This tip will show you how you can access all those hidden Macro Actions.

That is it for this month, I will be back with some more tips in October.


Back to Back Issues Page