For the third time since I built this database, the
Autonumber field (a primary key) has created duplicates
upon itself.  
That is to say, after nothing significantly changed in the

My membership database has a birthdate field, i would like
to get the age (in years) of the members on my entry
form.  Any suggestions?

I have been asked to add a field (done) with employees in
a combo box (done) so whoever has the medical file at
this current time thier name will show up on the form
(done). The problem I now have is my employer told me he

How do you format a table to report/recognize duplicate
entries without prohibiting you from entering them?
I.E.  Entering two people in table named Bob Smith.  We
want table to recognize that Bob Smith already exists, but

How do you define a sort order in a master table?  I.E. I
have a large table that lists candidates with numerous
fields.  I candidates to be listed by last name, then all
candidates with the same last name to be sorted by first

To All on MSDN VB Discussion Forum:
Is it possible to make the default value of a field equal
to the value of another field or fields of the same record
in the current table?  If so, where would this information

I have a table linked to a SAGE accounting system thru an ODBC link.
As part of the data entry process, I need to input a Sales Order
Number on a form which is of the format ...   0000012345.
Is there any way that I can only enter 12345 on the form, but when the

I am looking for someone to make a couple small access
databases for a project I have for college.  Please email
me at mhess00@verizon.net for more information.
Thanks

I have an access database where whenever I try to it I get
this message stating,  "could not creat; no modify design
permission for table or query MSysAccessObjets".  Is there
a way for me to open this database?

Is it possible to run code when a table is updated
directly? I can do it if I create a form from the table
and put the code there. But is there a way to add code to
the table itself?

Hi! I was hoping I could find some suggestions for a
problem that I was having. I have a unique ID field in my
database but I want to be able to leave it blank for a
while and then enter a value into it later. Basically I

Happy new year for all!
I have
T_Products: IdProduct, Product, UnitPrice
T_Clients: IdClient, Product(acquired),

Thank you for the replies.
With your advice we have altered the structure to separate the address types
and the name types by adding another table called tblNAMETYPE, so the system
now involves four tables, which are shown below:-

I work with Access 2002. And I want to reset the Autonum
field to deliver my application.
I tried with the method described in the Access Help
pages. This method works fine to preset the Autonum

Hallo to everyone .... i'm new to access
One problem that i cant resolve is how create a table insertin
automatically in the field name the elements that came from a list o
another table: