Hello - When I use the date entry shortcut (CTRL + :), the
current date will appear but the year shows as 2020. I've
checked the system date and it's correct. Can you help me
straighten this out? Thanx!

I know this is table design 101, but I can't seem to find anything in
the help files...
What is the difference between a key and an index?  Not only from a
usage standpoint, but how are the tables structured differently

I'm creating a database for hiring/recruitment.  There will be at least 3
tables in which each candidate will have a record - one for address/phone
info, one for assessment scores and evaluations, etc.
Not all of the data for each candidate will be entered at once (because of

Hi. I have added a command
button to my form which acts as a 'go' button for my
calender control. this has stabalised my database and i
only have one problem now. When i exit my database and

Hello, one of our old programers placed an email address     ABC@DEF.COM
some place in our database that is programically inserted into an HTM page.
Could someone suggest how I can find this old address that will be changed
to a new address.

Does anyone know how, using asp and an access database, one could display the total of the records retrieved. all of the records
retrieved are #'s and I need to display the sum of all those #'s.
thanks in advance!

   Is there anyway that you can have a database running
outside the access window. That is to say without the
file, edit, view etc. at the top and without the access
window?

I am trying to create a database to show the homework I set for my various classes.
I want to be able to enter homework for each class and then see a list of students and record their grades for each piece of work. I have a class table, students table , homework and homework ...

Everytime I try and use the Table Analyzer Wizard in
Access 2000 and choose to let the wizard analyze my
table, the application automatically terminates.  I've
tried detect and repair and that didn't cure the

My table is linked to a text file.  One of the numbers in
that text file has 2 leading zeros.  I do not want the
leading zeros to be imported into the Table.  How do I
strip off the two leading zeros in the Text Field?  I

i have three tables: products, categories and
subcategories. any product may have many categories and
many subcategories.
in my products table, for the category and subcategory

is it possible to do self reducing lists in Access ?  I have an Excel sheet
that can accomplish this >automatically because the sheet has dynamic
formulas<, but it is getting very cumbersome and with lots of people
inputting data, it is not infallible.

Newbie to Access 97 here.  I'm trying to figure out how to
automatically increment a specific alphanumeric so I can
have Access 'assign' the alphanumeric each time I enter a
new part number.

How would i design my database to work like this:
We have 5 functional teams in the database.
Four of those team can only have access to  their own
teams.

The form is opened with a macro to open it to a new
record with a autonumber.  How can I undo this record if
the patient's last and first name has already existed in
the db?  I have the lastname and firstname txtbox