|
vb123.com |
|
|
Home Contact Us Order our Software RSS &
Newsletter
Get Good Help
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 Garry's Blog
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 or try our new site built with
SharePoint Designer |
Is Your Database Corrupt ?
Access
Unlimited News - Edition 77
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 |
||
| In this
newsletter, you will find a few links to my blog. What is a blog you may
ask, well in my view it is a vertical website that consists of postings
(or ravings of a mad person) from newest at the top to oldest at the
bottom. What makes them interesting from my point of view is that you
guys can make comments on the postings and it features a built in RSS
feed. On a related topic, during the week I was pondering the term Wiki when I read in a newspaper article that every company should use them. After a bit of research it turns out that they are based on the giant Wikipedia online encyclopedia. To me they sound like a tool for people who want to collate and organize information but don't want to spend a lifetime learning a web creation tool. There is never enough time in a day to learn everything ... Enjoy the newsletter. Garry Robinson Access MVP and Editor of vb123.com |
||
--- 4/05/2007 ------------------------------------------------------------------------------------------ |
||
|
Sending an
SMS using Skype |
||
| Following on
from discussions on SMS in the last newsletter, Mark and I will show you
a simple way to send an SMS using Access VBA and Skype. |
||
--- 2/05/2007 ------------------------------------------------------------------------------------------ |
||
|
Consistent Filtering In Access 2007
and Excel |
||
| In Access
2007, one of the considerable achievements is greater consistency with
Excel. One of my favorite features is Filtering. |
||
--- 2/05/2007 ------------------------------------------------------------------------------------------ |
||
|
Using a form field as a parameter
in a crosstab query |
||
| A client asked
me how to use a form field in a crosstab query. Initially I thought it
would be a matter of adding the following in the criteria field of a
query [Forms]![_MyApplication]![cboProduct] but it wasnt. Read my blog for the solution... |
||
--- 2/05/2007 ------------------------------------------------------------------------------------------ |
||
|
Office
Add-In Programming For .Net |
||
| Here is a tool
that might provide a leg-up for someone wanting to do Add-In
programming. Its called Add-in Express .NET |
||
--- 24/04/2007 ------------------------------------------------------------------------------------------ |
||
|
My First Video ~ What to do about
Macro Protection in Access 2007 |
||
| This video
shows you the best way to manage macro protection in Microsoft Access
2007. In other words it allows you to make sure that the message bar
that says Security Warning "Certain content in this database has been
disabled" no longer appears. Garry Robinson has written an article on
this topic for Microsoft in the MSDN Web site. The video shows you how
to set up a trusted location for your databases. Sorry about the clarity, Google video hosting reduces the bandwidth to make it faster. Also remember I am not a newsreader by trade Explore your data with this versatile graphing and data mining shareware tool. Read More |
||
--- 6/04/2007 ------------------------------------------------------------------------------------------ |
||
|
When
Access MVPs are desparate for coffee |
||
| Check this
funny (low budget) photo of Access persons out from the MVP conference. |
||
--- 9/03/2007 ------------------------------------------------------------------------------------------ |
||
|
Access 2007 makes incompatible
MDE's |
||
| The MDE
compiler that comes with Access 2007 makes MDE files that are compatible
with Access 2007 only and have no compatibility with Access 2003 or
2002. Whilst there has been technical arguments before as to why this
should happen, in this version there is also the ACCDE format as well
that is incompatible. The long and the short of it is that you will
still need Access 2003 or earlier if you want to make MDE files that
your slow moving clients can use. Of course my Access Workbench will help you run multiple versions of Access in this case so that you can both try the new version of Access and compile with the old version of Access on some databases. |
||
--- 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/04/2007 ------------------------------------------------------------------------------------------ |
||
|
Access
Form Tips from FMS |
||
| Check out
common mistakes that you make with an Access form. More interestingly
are some cool tips for Access 2007 which show some of the not so obvious
enhancements that have gone into this new version of Access. |
||
--- 20/04/2007 ------------------------------------------------------------------------------------------ |
||
|
Finding Stuff In Access 2007 |
||
| Handy
Reference Page for People Switching from Access 2002/2003 to Access
2007. There is an accompanying Excel spreadsheet that details all the
changes. If you need to run multiple versions of Access, don't forget
http://www.vb123.com/workbench/ |
||
--- 16/04/2007 ------------------------------------------------------------------------------------------ |
||
|
Access 2000,
2002, 2003 running on Vista |
||
| I hope you
don't get these problems on your new Windows Vista machine |
||
--- 13/02/2007 ------------------------------------------------------------------------------------------ |
||
|
Developers Running Your
Own Company In Australia ~ Click Here |
||
| If you are a
developer, I am interested in taking to people who can walk into a
client's office, talk specifications, build good data models, sort out
messy Access applications and keep the users happy. This is not full
time work and may only amount to a single project or two a year. If this
is you, contact me by email. If you have contacted me, don't worry, we
haven't forgotten about you. Garry Robinson |
||
--- 7/04/2007 ------------------------------------------------------------------------------------------ |
||
|
Wide
Area Networks and Access |
||
| A discussion
on Access once it heads to the world of failure prone networks. Also
discussions on performance in this environment. The conclusion, Citrix
or Terminal Server is a good one because it details why. |
||
--- 7/04/2007 ------------------------------------------------------------------------------------------ |
||
|
Spreadsheets |
||
| Excel is a far
more popular tool in the real world than Access, and whilst most
developers will find it a clumsy tool to develop in, the reality is that
many systems are set up in Excel. Irrespective of the obvious technical
merits of storing the core data in a database, spreadsheet users have
learnt how to achieve good results in a spreadsheet and are generally
enthusiastic about their own applications. It is into this world that I
find my team's Access skills being called upon time and time again. So why is an Access developer called into the Excel world in the first place? Read the article and others about how Access is being adopted in the real world. |
||
--- 1/11/2006 ------------------------------------------------------------------------------------------ |
||
|
Read the last
Access Unlimited Newsletter |
||
| Read the last
newsletter online. |
||
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
Editor of vb123.com
Microsoft Office Access MVP
---
To
sign up for Access Unlimited, head to
http://www.vb123.com/news/
To rename, unsubscribe below and then sign up with new email address.