vb123.com.au
Access
Unlimited News - Edition 79
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) 9340 7789 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 |
||
| Greetings to
you all from Sydney Australia. During the last month I have been
busy.setting up a database that combines a SQL server database with a
number of million record line tables (ODBC links), two access databases
and 3 linked text files. Amazingly if you respect the primary keys when
setting up your interface, everything hums along at a reasonable pace.
Included in the this is a Tab control that holds five sub-forms of
related data. My hat goes off to Access, it is a wonderful tool for
pulling data together. Enjoy the newsletter. Garry Robinson Access MVP and Editor of vb123.com and vb123.blogspot.com |
||
--- 8/07/2007 ------------------------------------------------------------------------------------------ |
||
|
Right-Click Microsoft Access Menus ~ Excerpt from Garry's Protection
Book |
||
| Right Click
menus allow Access users and developers flexible access to all the
built-in menu items and, indirectly, to any objects in your database.
Though this flexibility is good for a developer's productivity, it is
not necessarily so good when it is available to the users of your
database. In my experience, most users are interested in software that
makes their job easier. Right Click menus bulging with developer options
(such as the Design View and Database Window commands) probably do not
assist in that aim. In addition, if users are technologically
competent,they may be tempted to alter the programming objects of your
database. Therefore, it is important that you learn how to use Right
Click menus to setup a good user interface and to protect your database
at the same time. TIP: For Access 2007 developers and those thinking ahead, whilst the old menus and the top toolbars may have been replaced by ribbons, right click menus still persist in the user interface. So if you can add your custom right click menus before upgrading, your database will be protected in Access 2007 as well. |
||
--- 28/06/2007 ------------------------------------------------------------------------------------------ |
||
|
Pinpointing where a crash occurs in your VBA code |
||
| Luke Chung
from FMS writes about trapping error handling in Access vba. |
||
--- 27/06/2007 ------------------------------------------------------------------------------------------ |
||
|
Free
Access 2007 Developer Extensions |
||
| On this page
you will find out more about the free runtime kit and developer
extensions for Access 2007.
|
||
--- 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/06/2007 ------------------------------------------------------------------------------------------ |
||
|
Google Docs and Word File
Collaberation |
||
| Woodies watch
gives a good overview about collaboration with Office Word and Google
Docs |
||
--- 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 |
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
