I've created a form in Access 2000 where I'm wanting the
SignDate plus the LeadTime, which is always in 3, 6, 12,
160 etc. months, will give me the RenewDate. Then I'll
print all the renewable contracts.  Could anyone help on

I am relating a database of jobs performed for any certain company to a
database of contacts we may have for that company by company name. The
jobs database and the contact list database both have fields called
company name (or similar), here's the question:

I need help to build a query to pick only the latest transaction date from a multiple transaction date with multiple Items Data Base?  The idea is to have only the latest date of an especific transaction type X per item.
I tried the Top Value but the query came with more than one ...

Every time I close the database table I am working on, it
renames the database title by adding another number, such
as Collectibles30 (where Collectibles is the name of the
database).  I do not save any changes or additions to the

Hello, Access 2000,Xp Profesional, need help is setting up
table / form for input of data.
large number of vendors on "Vendor Table" and 20 project
on "Project Table".

We are redesigning the address tables of our Access2000 database so as to
allow consolidation of old individual address tables such as Account
customers, Freight depots, Delivery addresses, Postal Addresses, Pickup
Addresses etc etc into one address system consisting of three new ...

After compacting of my database the fields of one table
lost their properties like format, default values and
allow zero length. What is the reason?

I was trying to add more fields to my original table but
encountered the following message "Too Many Fields
Defined"  Then, it would not allow me to save the fields
I had just entered.  I reviewed my manual and I

I have a customer who is entering numeric data into a text
field through a form. There is no autonumbering field in
the table. Customer is relying on the person entering the
data to keep the correct format on the log data field. the

I am trying to create a few formulas in a database I am designing.  The following is what I am trying to do
1) I have a starting date.  I need to show in a separate field the date 1 year from this starting date and when that date is reached to update both fields to reflect the new ...

I have a simple database for tracking property sales which includes a
property information table and a sales information table.
I have been using a composite primary key which I now realize makes no sense
(i.e., composite of parcel number and the date I entered the transaction

Is it possible to set the default value of a field to repeat the value from the previous record?

Hi. I have a table with a control that's a time stamp so I
can keep track of when a record is added. I'd also like to
create a field to track who made the entry. I think I need
to set the default value to =CurrentUser or something. Any

I have a database containing a table "Files", with fields "ID" (autonumber),
"size", and "checksum", and others which will not concern us.
I wish to know the IDs of the records that have duplicates. A duplicate is
defined as a record which has the same Size and the same Checksum as ...

How to check errors (programatically) returning from a
database modification operation from the ORACLE database
when linked within Access 2000.
If you have any URL or code sample, please provide me.