vb123.com.au
Access
Unlimited News - Edition 83
See all newsletters
Independent news for enthusiastic Microsoft Access and Office readers
If you cannot see any links in this article, you are
reading it in text format. The newsletter can be signed up for and read at
vb123 dot com
| 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. |
--- 28/11/2007 ------------------------------------------------------------------------------------------ |
||
|
Read the latest
Access Unlimited newsletter online |
||
| Greetings to
you all from Sydney Australia. This month has been our best since I started getting serious about using other Access professionals to undertake projects for my clients. For those of you that ask occasionally about the future of Access, let me tell you that Access is not dead, it is still flourishing. Enjoy the newsletter. Garry Robinson Access MVP and Editor of vb123.com and vb123.blogspot.com |
||
--- 27/11/2007 ------------------------------------------------------------------------------------------ |
||
|
IT Departments and Microsoft Access ~ Developers Have Their Say
|
||
| Last month I
asked you, the readers for input into "What can IT Departments do to
improve their support of Access databases". The response was fabulous as
many obviously seasoned developers described their experiences and came
up with solutions to this phenomenon / problem. Please have a read and
even better, send your IT manager to have a read as well. |
||
--- 5/11/2007 ------------------------------------------------------------------------------------------ |
||
|
Adding a Decent Tick to Your Access Report |
||
| If you want a
tick (or an empty box) in a report that doesn't look as quirky as a
check box, its time to add a new field to your query and use the Chr()
function. Then add that new field to the report and assign the data
control the WindDings font. See how it looks. |
||
--- 26/11/2007 ------------------------------------------------------------------------------------------ |
||
|
Processing SWREG Order Emails in Access and Outlook |
||
| For many years
now we have used the DigiBuy Credit Card processing site run by Digital
River to handle most of our online orders. Well at the end of November,
Digibuy is closing down. Now we have been moved to a cheaper and very
similar site also run by Digital River called SWREG.org. Anyway as a
consequence, I have adjust our Digibuy order reading software to work
with the SWREG emails. As the two emails were similar, this only took an
hour or so. Read the article that I have prepared on this topic.
|
||
--- 27/10/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 before it is transmitted and in most
cases, you should be able to recover a corrupt database in less than 30
minutes elapsed time. "I know that it works because we use it from time
to time." Garry |
||
--- 10/11/2007 ------------------------------------------------------------------------------------------ |
||
|
Using Microsoft Access to manage and interrogate a web site |
||
| Stir your
imagination by thinking about using Access to grab extra value at low
cost from your all important web site information. This is discussed in
the MS Access Team blog. |
||
--- 30/10/2007 ------------------------------------------------------------------------------------------ |
||
|
Reporting Monthly Data in a Yearly Range Without Code |
||
| Luke Chung
from FMS writes a detailed paper on how to store and then report monthly
data without using any code. I like to use iif statements to tackle
these sorts of problems but I learnt a bit from this article.
|
||
--- 28/11/2007 ------------------------------------------------------------------------------------------ |
||
|
Garry's Access blog |
||
| My blog rolls
on Enjoy |
||
--- 1/11/2006 ------------------------------------------------------------------------------------------ |
||
|
Read the last
Access Unlimited Newsletter |
||
| Read the last
newsletter online. |
||
| 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 |
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 Toolbox 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 Microsoft Office Access MVP
|
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
