|
---
15/10/2009
------------------------------------------------------------------------------------------
|
|
|
The AutoExec Macro explained
|
|
| |
Access has a
starting mechanism called the AutoExec macro. This macro has been around
since Access 2 and is still an important foundation for protecting your
database. When your database opens, Access first processes the startup
options and then looks for and runs the AutoExec macro.
|
|
|
---
15/10/2009
------------------------------------------------------------------------------------------
|
|
|
You Can Do That with Datasheets?
|
|
| |
Everyone who
uses datasheets knows they're powerful, but very few people know all of
the things you can do with them. Michael Kaplan pulls out a handful of
tricks from the unlocked Access 97 wizards that can help you really get
the best of these useful items.
|
|
|
---
19/05/2009
------------------------------------------------------------------------------------------
|
|
|
# The Access Workbench #
|
|
| |
Find out who
has your database open, start the correct version of Access, easy
compacting and backups, change startup options, create version zip
files, shutdown database all in a simple interface. We use this program
a lot.
|
|
|
---
14/10/2009
------------------------------------------------------------------------------------------
|
|
|
An ADO Tutorial: What is ADO?
|
|
| |
In this
article, Russell Sinclair provides a primer on what you need to know
about ADO: what it is, why you should care, ADO's relation to OLE DB,
and a tour of the major objects in ADO.
|
|
|
|
| |
|
---
8/10/2009
------------------------------------------------------------------------------------------
|
|
|
Access Answers: Tricks With Combo Boxes
|
|
| |
Doug Steele
show you how to manipulate a ComboBox to display multiple fields and how
to synchronize one Combo box with another.
|
|
|
---
7/10/2009
------------------------------------------------------------------------------------------
|
|
|
SQL without Joins
|
|
| |
If you always
join tables you put in a query, then you aren’t taking advantage of one
of the fundamental features of SQL. Not only that, Peter writes, but
you’re also missing an opportunity to see how SQL really works.
|
|
|
---
20/09/2009
------------------------------------------------------------------------------------------
|
|
|
Alternative Access Buttons
|
|
| |
With Access,
the rule for buttons seems to be "You can have any color button you
want, as long as it's Battleship Grey." But you don't have to be that
limited: You can expand your buttons' range in color, texture, and
functionality, provided that you're prepared to bend the rules a little.
Paul Millennas shows you how.
|
|
|
---
20/09/2009
------------------------------------------------------------------------------------------
|
|
|
Everything About AutoNumbers
|
|
| |
AutoNumber and
identity fields have some benefits—and some costs. In this article,
Russell Sinclair covers just about everything you can do to manage
AutoNumbers in ADO, ADOX, and DAO. Since most AutoNumber fields are used
as primary keys, this is the information you need to manage your tables.
|
|
|
---
20/01/2009
------------------------------------------------------------------------------------------
|
|
|
# VB123 is a Reseller of FMS Total Access
Tools #
|
|
| |
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.
|
|
|
---
20/09/2009
------------------------------------------------------------------------------------------
|
|
|
Access to Excel Automation tricks
|
|
| |
Doug Steele
looks at several techniques to use Automation from within Access to
interact with Excel. By the time he's done, Doug has exported every
table in his Access database to separate sheets in an Excel workbook
|
|
|
---
18/08/2009
------------------------------------------------------------------------------------------
|
|
|
# Convert Access to SQL Server #
|
|
| |
Upsize to SQL
Server 2005 or 2008, easily repeated conversions, highly accurate SQL
query translation and web form conversion.
|
|
|
---
20/09/2009
------------------------------------------------------------------------------------------
|
|
|
Managing Access from .Net
|
|
| |
You can
automate your Access application from a .NET program–but you'd better
watch out. If you're not careful, Access will unexpectedly become
unavailable, for instance. More importantly, you need to be able to get
rid of Access when you don't want it anymore. Peter Vogel shows how to
handle both of these problems.
|
|
|
---
20/09/2009
------------------------------------------------------------------------------------------
|
|
|
Undo in Sub Forms and a General Error
Handle Function
|
|
| |
Russell
Sinclair looks at implementing undo in form-subform applications and
then goes on to demonstrate some reusable error-handling code.
|
|
|
---
20/09/2009
------------------------------------------------------------------------------------------
|
|
|
The Easy Approach to Code Reuse
|
|
| |
The hard part
of code reuse has always been finding that elusive snippet of code
that's buried somewhere among hundreds of modules in different
databases. This article introduces an easy-to-use library add-in that
allows you to quickly access your favorite procedures, plus a look at
using the Windows clipboard.
|
|
|
---
20/09/2009
------------------------------------------------------------------------------------------
|
|
|
Product Review: Access 2003 Conversion
Toolkit
|
|
| |
Danny explains
(along with comments from Jon Sigler, Group Program Manager for
Microsoft Access) why, if you plan to make your living delivering
Microsoft Access applications, you owe it to yourself to consider the
Conversion Toolkit's place in your practice.
|
|
|
---
20/09/2009
------------------------------------------------------------------------------------------
|
|
|
Using Access for Email Alterts
|
|
| |
How to create
Microsoft Access email is a common request. I received the following
question a while back and it presented a great opportunity to show how
useful Microsoft Access recordsets can be. Microsoft Access recordsets
allow you to move through a set of records and use the data contained in
them to perform such tasks as emailing, running reports or queries,
analyzing data, etc.
|
|
|
---
29/03/2009
------------------------------------------------------------------------------------------
|
|
|
# Repair Damaged Access Databases #
|
|
| |
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.
|
|
|
|
|
