vb123.com.au
Access
Unlimited News - 2008 October - 2009 March
See all newsletters
Independent news for enthusiastic Microsoft Access and Office readers
| Produced by Garry
Robinson from Sydney, Australia.
|
| 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) 9665 2871 in Australia or email me. http://www.vb123.com.au/professionals/ Garry Robinson, Office Access MVP award winner. |
--- 29/03/2009 ------------------------------------------------------------------------------------------ |
||
|
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 |
||
--- 19/03/2009 ------------------------------------------------------------------------------------------ |
||
|
Link Subforms to the Control rather than the Field |
||
| Luke Chung
from FMS discusses this fine detail on how to setup subforms and master
form link fields that I never thought about. Sounds like a useful thing
to think about in busy systems. |
||
--- 5/03/2009 ------------------------------------------------------------------------------------------ |
||
|
Office 14 (the 2010 version) to Run On Win XP |
||
| Tony D'Ambra
from Access Extra pointed out this post on Office 14 and Windows XP.
Backward compatibility is good to know for all those companies just
trying to get by with Win XP. If companies want to save money on not upgrading Windows, will everyone get a good chair and monitor instead, in my view that's money well spent. |
||
--- 2/03/2009 ------------------------------------------------------------------------------------------ |
||
|
Access
Support for New Data Types in SQL Server 2008 |
||
| SQL Server
2008 introduces a number of new data types, including a new DATE data
type with a greatly extended range of dates. It turns out that you can
link you access applications to tables with the new DATE data type and
this fully supports updateability on linked tables. Although direct use
of other new data types is more limited it is still possible using
stored procedures and pass-through queries to get meaningful results;
for example when using the new Geography data type. For more information
and examples follow the link Andy Couch, developer of the MUST SQL Server upsizing tool available at http://www.vb123.com.au/up/orders.htm |
||
--- 25/02/2009 ------------------------------------------------------------------------------------------ |
||
|
2007
Attachments Converted to SQL Server |
||
| One of our
readers asked, can your MUST SQL Server Upsizing tool convert
attachments that are supported in Access 2007 to SQL Image blob fields? The answer to that and the curly issue of MultiValue data fields in Access 2007 is discussed here. P.S. Remember when you purchase MUST from vb123.com, you get a free copy of our Toolbox. |
||
--- 18/02/2009 ------------------------------------------------------------------------------------------ |
||
|
Creating A SharePoint Task
List with a Custom Workflow Reminder |
||
In this this talk, I will show you how you can create a customised Task list in a Microsoft SharePoint site. Then I will show you how you can use the Office tool, SharePoint Designer to create a workflow reminder everytime a Task ismodified. If you are familiar with SharePoint, the workflow features in SharePoint Designer are worth knowing about. If you have never seen SharePoint in action, you will gain an insight into this hugely successful and flexible Microsoft Web/Intranet site builder. Garry Robinson. On this page you will find a link to a video that I created for Internet.com. |
||
--- 31/01/2009 ------------------------------------------------------------------------------------------ |
||
|
MUST Prices Have Been
Adjusted |
||
| Thanks to the
plummeting UK Peso taking a Pounding, the prices on our popular Access
to SQL Server upsizing tool, MUST, have been adjusted 40% downwards.
|
||
--- 23/01/2009 ------------------------------------------------------------------------------------------ |
||
|
Rule Britannia, Wikepedia Rules the Waves |
||
| Wikepedia now
have editorial competition from Encyclopedia Britannica and I don't
think that will be a bad thing. |
||
--- 22/01/2009 ------------------------------------------------------------------------------------------ |
||
|
Cut and Paste from Excel 2007 to Access :( |
||
| In mid
December, an Excel 2007 patch stopped people from copying from Excel
cells into Access. If this will affect you, read this page from FMS (our
new software partners) to find out what to do. |
||
--- 20/01/2009 ------------------------------------------------------------------------------------------ |
||
|
We Are Now Resellers For FMS
|
||
| Purchase FMS
Software from us and you will find yourself with the latest version of
our software for almost nothing. If you head to our FMS page, you will
find the option to read about and purchase FMS Visual Code Tools, Total
Access Analyzer, Total Access Emailer and Total Access Detective.
|
||
--- 19/01/2009 ------------------------------------------------------------------------------------------ |
||
|
Access 2007 and DB2 |
||
| This article
uses Access 2007 linked to DB2 and displays charts as well.
|
||
--- 7/01/2009 ------------------------------------------------------------------------------------------ |
||
|
Creating Custom Task Lists Using SharePoint Designer |
||
| One of the key
new features in Access 2007 was better SharePoint integration. This
video describes setting up a custom task list (Can be linked to in
Access) with an automatic workflow reminder that is sent when a task is
completed. Features SharePoint and SharePoint Designer Note: We use http://www.sharepointhosting.com/ for our smaller clients. |
||
--- 19/12/2008 ------------------------------------------------------------------------------------------ |
||
|
Hotel Booking Data Model |
||
| Here is an
informative page describing the data model for a Hotel Room booking
system. |
||
--- 10/12/2008 ------------------------------------------------------------------------------------------ |
||
|
A List Of Limitations When Moving Data to a SharePoint Site
|
||
| This page from
Microsoft gives you an idea what can and cannot be moved to SharePoint.
My golden rule is only move what you want to share outside your normal
userbase and NOTHING more. Note: We use http://www.sharepointhosting.com/ for our hosting. |
||
--- 10/12/2008 ------------------------------------------------------------------------------------------ |
||
|
The Access
Workbench |
||
| Switch
databases quickly, find out the users opening your databases, switch
between Access 2003 and Access 2007 and much more. |
||
--- 3/12/2008 ------------------------------------------------------------------------------------------ |
||
|
How to Setup a Survey Database with Option Boxes |
||
| I was recently
asked how to setup a form to use Option boxes for data entry. The
solution required a subltle setup of tables and lookup tables. The notes
for this task are in The Toolbox website |
||
--- 25/11/2008 ------------------------------------------------------------------------------------------ |
||
|
Error Number List |
||
| Todd from
Manchester writes "I was just reading your latest 'MaxOut On Access Weekly' newsletter (received November 11th, 2008). I just want to add a note to your article titled 'Access 101: How Do I Replace System Error Messages With Custom Messages?' **. FMS has recently released a listing of all Access messages. It can be found at this URL: http://www.fmsinc.com/MicrosoftAccess/Errors/ErrorNumber_Description.html I enjoy your newsletter. I have your book 'Real World Microsoft Access Database Protection and Security', and have found it most useful. ** Note from Garry: Our MaxOut newsletter comprises of 6 Access MVP blogs as well as my own writings. www.vb123.com/news for more on that |
||
--- 21/11/2008 ------------------------------------------------------------------------------------------ |
||
|
Get ready for the Economic Upturn
|
||
| If you are in
the unfortunate position of not having much paid work on in this global
economic downturn, now is the time to upgrade your skills because if you
are a skilled developer who can help people solve business problems,
positive times will not be far away. So as it is likely that you are an
Access practitioner, I suggest that the best way to improve your skills
is to push into areas where Access provides a stepping stone. To me SQL
Server is one of those areas and here is what you have to do. 1. Identify the database that you are most proud of and convert it to run with a SQL Server backend. 2. Do not stop when things get hard, solve all the problems. 3. It would be best if you then started using that database in your day to day work. 4. When that works, start converting the Access queries to Views, Pass Thru Queries and Stored Procedures One thing you shouldn't do though. is become 100% immersed in your unpaid projects because its always better to write software that people need. For this, you will need to make sure that you attend conferences, participate in online forums and contact all the people that can help you get back into the thick of things. Good luck to you in your endeavours. Garry Robinson from Sydney, Australia |
||
--- 7/11/2008 ------------------------------------------------------------------------------------------ |
||
|
Developers and Information Workers in a tricky business climate
|
||
| Luke Chung
from FMS has written another one of his insightful articles on the
dynamics of programming using rapid development environments such as
Access, Excel and SharePoint. This one has been written with the
motivation of the economic conditions but its a timeless piece. Read on
|
||
--- 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. |
||
--- 30/10/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 |
||
--- 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. |
| 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
