I have a table that is used (through a form interface) to track the
start time and stop time of jobs in our shop. The user will click on a
button which fills in the TimeStart field with the current time. When
the job is completed, s/he clicks on a button which fills in the

I've got a database that I'm importing and then generating a primary key and
MS is generating an error say Dup. Key. The two fields in question is an
account number and a unique sequential alpha/number field. As an example:
Account    Key

I have a Score Sheets Music table that contains among the fields those one:
Composers
Lyrics
Arrangements

Kindly please advise if there's any restriction in the
number of records MS Access and will the ID no. assigned
be overflowed if maxium no. of records is reached.  Thanks.

I am wondering if it is possible in a date variable
(date/time type, short date, 09-09-0000) to enter an
incomplete date ? For example, if the day-part is missing,
but month and year are known. Or maybe I could give day

THIS IS STUPID, I'M SURE, BUT I HAD WORKS 4.0 AND WAS
ABLE TO SET UP FORM LETTERS WITH AN EXISTING DATABASE.  
NOW THE SPREADSHEET AND DATABASES WON'T MERGE. HOW DO I
START THIS OVER AGAIN (CREATING A FORM LETTER?) VERY

I would like to create a dynamic subcategory listbox that
displays only options appropriate to the initial main
category selection.  For example, I have a main category
list box that contains Drinks, Snacks, etc.  If I

I need to create an excel sheet to record and calculate vacation, sick, leave
time for a small business....just a novice at Excel.

I am using Access 2000
I made a Db program for non-Access users to use.  But
someone figured out that you can delete the record.  So I
set the form for no deletions.  But that does not take

Hi;
I need a simple way to keep track of incoming invoices in
Access 2000. I don't work in the billing dept., but I am
an assistant that has been given the job of listing bills

I am new at this. I would like tobe able to put an icon on the desktop that
would bring me directely to to a form to put info in the data base. First is
this possible? If it is how can I do that?
Thanks

We have a tracking system setup on the network and one of
the users performed a local save to their computer and
have been working off of the same database as the rest of
the staff, therefore I have two copies of the same

I am trying to design a table so that the team shown in the team 1 column
will never equal the team shown in the team 2 column

I am a newbie with Access and have been reading the Access
Indide Out from MS and have learned quite a bit. But Where
can I learn how to make an Access DB work with an online
web page such as a search page for product on my site?

I really need help with a formula to calculate the loan
amount based on the mortgage payment, interest rate and
term.
How would you calculate this in Access (any version)