I'm trying to find a way to create a logfile or audit trail of changes
we make to selected databases.  So if someone changes "David" to "Dave"
I want to log what the change was and date it was made.  I found an
example script of this when doing a Google general search, but I

Everyone,
I'm trying to export a table containing numeric fields with formats
such as "00000000" which would return the value with some leading
zeros. It works fine in the table as it is displayed as I want, the

I would like to run an MS-DOS command from Access (VBA) in order to read
a directory tree (into an external file).  The command works OK from the
command (DOS) window (in XP) but I can't seem to get it to work from
MS-Access (2003).  I tried a simplified command, DIR, but also ...

I am developing a simple app, and just found a problem that I can't fix
after 4 hours of trying.
I display a list of customers, and the user chooses one and displays
"orders".

I have an Access query that gets an ID value from an open form.
Something like
SELECT * from tablename WHERE ID=openFormName.ID;
But now, I want to also run the query by handing it the ID from a

I'm experimenting with Stephen Lebans' Rich Text Control for doing RTF
data entry into a memo field.
I imported the table, form, toobar, and modules from the A2k version
into an A2k3 DB. Then I edited a sample table record using the sample

I created a main form with 2 subforms.
In an attempt to move to the next record (or new record) on the main form I
get the error " Method 'requery' of object '_Subform' failed".
The database closes after answering the popup window (Microsoft Access has

Hi all--
In an attempt to commit an Access MDB to a versioning system (subversion),
I'm trying to figure out how to convert a jet table's metadata to text, a
la SaveAsText.  The end goal is to be able to build an MDB completely from

If you thought the Windows "copying files" progress bar was tupid
(as it will say "3 minutes remaining" then "6 hours" then "15
seconds" and so forth), I've got an even worse one.
I was at a client today and was implementing some changes to backup

The program I am creating takes certain files found on a Pocket PC and places
them on a specific directory on a network drive.  It is automated in the
transfering of the files, and in recording in the database the paths the data
were

How do I incement a numeric portion in Access 2003? The field I want to
numerically
increment looks like this:
Emp-1

I need to convert a 17mb access 2000 db to Oracle and house it in a
Citrix farm. The issue: we have never converted an Access Db to Oracle
but can probably use Oracle's Workbench to assist with this. Also - the
citrix folks do not want us to keep the FE in Access as the queries and

This seems a simple question, but I'm lost for the answer. Say, I
have two text boxes in a form: one for FirstName, one for LastName. I
want to combine them (which I can do OK) and enter the result into a
field called Name in a table. How do I do this?

Dear frends
Mr Stephen Lebans has designed a superb calendar. Does someone knows
how to modify it for displaying and picking also hours and minutes ?

I am trying to use vb code to set the filter on a form so that only
people with a common property can see each other on a form when they
open it (like if they are in the same department). But I cannot seam to
get the filters to work correctly and most of the time I'm just getting