A couple of responses suggest setting the default value of a date time field
to
Now().  This process, however, sets the date/time of when the previous user
exited his/her entry but it may be hours before the next user makes an entry,

These books are recommended on the page prior to this forum:
Microsoft Access 2003 Step by Step.
Access 2003 Bible.
Special Edition Using Microsoft Office Access 2003.

Finally decided to create a database, for a sports club.
Sorted all other problems and errors so far, except for my "time" dilema.
The situation is that one competitor will have times for several events. The
times for these events will be measured in minutes:seconds:hundredths of

OK, I'm new at access!  I want to set up a way to keep track of dogs entering
in our training program & leaving the training program.  
The tables I  have set up are as follows
Table 1) DogID, DogName

Earlier today I submitted the question, "In an Access form set up to allow
users to only create a new record, how can Access record the date and time of
the record creation."  I add now that I want the Date and Time to show in a
control in the record that the user is creating.

Here's my thing(?) I am the middle man in an order and supply chain.
Every two weeks I order from contractors, people to perform work for my
customers. Every Contractor can supply all of the same type of people
(craftsmen) to all of my customers, who use all of the types of people ...

Hello Its me again
Here is what I need
I need to have an inventory form or table that will have around 20-30
thousand entires in it.

I typed all imaginable statements of the subject of this post into the Help
question wizard and got no returns that even resembled the questions.  Hence
I turn to you all again.
In an Access form set up to allow users to only create a new record, how can

I saw this question in public access and the answer was not clear to me.
Hopefully somebody can break it down a little more for me as I am in need of
the same answer.
I have a project that gets daily reports done in "notepad". I want my form

I'm attempting to merge 2 tables based on a similar primary key field, but
one table uses an extra zero in the middle of the number.
How do I run a query to match the corresponding records?

OK - I'm an experienced C/Unix/SQL programmer.  I'm not an experienced
Windows platform developer.  I've been maintaining some data in Access.  Now
I have a need to use the data in Access to generate a plain text file
(dynamically create SQL to be used to update an Oracle schema ...

I have a field that is for street numbers. I have it set to text, because I
am not going to do calculations on it. I want users to only put in numbers.
How can I restrict users to only inputing numbers?
Thanks,

I am looking for an .mdb template for storing scientific data.

I am new to Access, and have made one large table with around 100 or so
fields.  In reading these posts I am getting the impression that I should
have more than one table.  If all of my forms and queries work fine, why do I
need more tables?

My company designs and supplies steel buildings. I am trying to convert all
of our spreadsheets into one database.  To begin the process, I want to make
a Purchase Order and am not having much success.  What I would like to know
is; Is there a purchase order template out there ...