I am wanting to add the current date to each new form, as I advance
through the recordset, using the buttons built in to the form at the
bottom.  I have currently the following code, but I am wanting to
enable the date stamp on successive record entries in the same

I know it is a simpleton question, forgive my noobness.
I (obviously) know nothing about creating modules. the "for dummies" books
don't even enter in to it, and the Access Bible just overwhelms me with
info.

I am bringing in data from 2 systems, then comparing them for outages.
I bring all data in as Double, standard, 2 decimals. All data looks good.
But then when I subtract the 2 fields on SOME, not all I get
363797880708171E-12, yet when you look at the 2 fields that are identical ...

I have a form that I would like to autofill on field if another field meets a
certain criteria. For example: I have several services I perform. That field
is services. Depending on what that service is, the price field changes. Is
there anyway to get the price field to auto fill ...

What would be the best way to design this database with multiple
tables and all tables have a common similarities:
TABLES (divided by type of allegations):
investigation referrals

Hi, my name is Jean C. and well trying to finish a project. I have the
following problem, I have two tables "Costtable" and
"BackupCosttable". I want a command button to transfer all records
from the "Costtable" table to BackupCosttable" table. I want to make

I want to make a mask in a table.  It should be min 4 numbers in txt format
Eks. 1 should be 0001  not 1, 123 shoul be 0123.

I need to delete all records in a table but keeping the table. This is to
allow new records to be push into the table by my IT admin (he is not
familiar with Access).  Can't do appending data as past weeks data may
change. Any suggestions?

How does replication work is Access ? I think MSsql also have replication,
do they work pretty much the same ? What is a typical scenerio where
replication is helpful or used ?
Thanks

Hi Y'all,
I have a table field which I've formatted to MM/YY. On a form the
input box for that field is formatted the same. However if I enter a
date such as 03/08 (March 2008) it becomes 08/07. Access sees 03/08 as

I'm interested in hearing if anyone else is having these kinds of problems running Access 2007 under XP (SP2), on a 2.4GHz Pentium 4
having 1GB of RAM and no other applications running:
- sluggish behavior on opening objects (e.g., tables, queries)
- frequent lengthy "timeouts" when ...

I have a table named Case with columns CaseID, CaseDate, and Vehicle where
CaseID is the primary key. It is possible to have multiple cases for the same
vehicle as illustrated below:
CaseID  |  CaseDate   |  Vehicle

The database is on our central file server. Individual workstations
have MS Access 2003 licences. I created an access level security with
1 administrator and multiple users with differing rights (e.g. can add
records, can't delete). Current problem is that only 1 user (whether

I am trying to develope a database in access 2003 which can log who entered
specific notes into the notes table, can any one help on how this can be doen
autopmaticaly

Is there any way to create a Database designed to store quotes and them in a
random order when requested?