Throughout the year, I delete records which is a very common occurance in any
database.  However, from time to time, it would be nice to print off a list
of the records that were deleted.  Is it possible that when a record is
deleted, the person's name would automatically be added ...

Is there a way in VBA to check if a linked table in the database has
been updated?
Example:
I have a table "LedgerTemp" which is a direct link to a text file on

I have two questions:
1)  Say I have a form bound to a table.   Assume the user is entering
data into a new record at the bottom of the form.  Now, suppose the
user clicks a button on the form while he's still entering data and

Can anyone recommend a book on Access please? In the old days I used
to buy the GLR Developer's Handbook which I must say I did find useful
when I could understand what they were talking about. In other words,
I've been around Access for a long time but don't often have to

I am working with a union query in Access 97 (for a client).  All
works well except some of the numeric columns come through as text.  A
couple of them, that is fine.  However, other I put in a zero when the
field does not have a value from that query.  So I can't figure out

Not sure if 'introspection' is the correct term, so apologies if
subject line is off-base.
1) Is there any functionality that answers the question: what module
am I in?

I am having problem in entering data in the form of
1/2
1/22
1/3

I wonder what makes my application inflate.
Fortunately MsAccess compresses the file automatically when I close it, but
still I wonder,
what makes it inflate in the first place.

Assume the following:
1) multi-user environment
2) when user opens app, want to run some code that retrieves some
information specific to the user...retrieving this information is

I have 2 problems:
1. I want to import a single text file into an access table using a
Macro. I am however getting an error that I need to put a
specification name argument. What does this mean? It also suggests

Apologies in advance for what I'm guessing may be a trivial question.
Assume the following:
1) multi-user environment
2) standard (i.e. not a class module) module with:

When using ADO in a module inside an Access 2003 database do I need to
open a db connection even though I am working with a table inside the
same database?
I am writing a bit of code to periodically import data from a text

I have a application which reads from a dat file.I import this into
the database.While exporting this back I want to format the data so
that the alignment is proper.
I have the data in decimals which have to be padded with 0 either to

I am trying to find a solution for handling zipped data without the
need to ship / install any DLL files with the database. Does anybody
know of code to handle ZIP files that does not require any external
references? If I can ship it 'built-in' as either a class module or

I have 4 Access databases, all with the same data model but different
data.  I want to build a front end that brings all of the data in the
4 databases together into one.
Assuming my table of interest is called Removals, if I create linked