vb123.com.au
Access
Unlimited News - 2009 April
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) 9340 7789 in Australia or email me. http://www.vb123.com.au/professionals/ Garry Robinson, Office Access MVP award winner. |
--- 5/05/2009 ------------------------------------------------------------------------------------------ |
||
|
Access Unlimited Returns Courtesy
Of the FMS Email Product |
||
| If you had
been watching your in-tray, you would have noticed that my newsletters
have been few and far between lately. For that I apologize but fear not
the content was being written at the usual pace, the issue lay with the
newsletter provider having some business problems. So here I am again but this time around I am using the FMS Total Access Emailer to deliver the newsletters to you. If you have seen any of these articles before, sorry about that, I will aim to get link and descriptions all the recent articles out to you soon. All the best to everyone. Garry Robinson Microsoft Office Access MVP 2006-2010 |
||
--- 5/05/2009 ------------------------------------------------------------------------------------------ |
||
|
Get Ready For The 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. Identify the database that you most proud off and convert it to run with a SQL Server backend. Do not stop when things get hard, solve all the problems. It would be best if you then started using that database in your day to day work 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 |
||
--- 29/04/2009 ------------------------------------------------------------------------------------------ |
||
|
Office 14 in 2 versions (32 bit and 64 bit) |
||
| This post and
many others are indicating that Office 14 might come in 2 flavours, 32
bit and 64 bit. Why is this important, well if you want to use more than
4 gigs of memory on a PC, you need a 64 bit operating system. If you
have that operating system running an emulator to make Office 32 bit
work, that is wasteful of resources. |
||
--- 7/05/2008 ------------------------------------------------------------------------------------------ |
||
|
Read the latest at Garry's blog
|
||
| Read the last
posts that Garry and Wayne have made on our blog. |
||
--- 29/03/2009 ------------------------------------------------------------------------------------------ |
||
|
Repair Damaged Access
Databases |
||
| vb123.com and
everythingaccess.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 who have
stuck 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. |
||
--- 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 video, 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 is modified. 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. |
||
--- 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. Also
if you purchase FMS Software, you can qualify for free copies of our
popular Access Workbench or Toolbox Resource kit. |
||
--- 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. |
||
--- 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
|
||
--- 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. |
||
| 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
