I have a database with 50 tables.  Each table is related
to each other through a field named "ID2".  The tables
are related on a one-to-one relationship.  when I open up
the database to add a new entry. After entering the "ID2"

I created a new table (during runtime) by using an SQL Statement
The problem is that Access does'nt 'know' it until it reconnects to the server
How can I tell it to create the table object for the new table ?

I need to take two tables in Microsoft Access and somehow
have access sync data between two username and password
fields between the tables in the same database.
For example, if a username and password is put into the

Dlast returns wrong record on autonumber field
I been "docmd.runsql insert into values ..
for  over 18 months, and looking for the last recor
with Dlast("Id","tblStockIn") to record on the paper doc

Am working on a database to track instructors and what
they are able to teach. It will include computer software
as well as safety and other types of courses.
What would your advice be:

My Access question concerns adding new records:
If you use forms view to add a new record, the star at
the end offers blank fields for data entry.  Is it
possible to offer a drop down list (look-up list) only in

I have some corrupt records in my database, the data
displays in chinese (literally).  I am unable to delete
these records, I am also unable to run a repair/compact
sucessfully. I have tried downloading JetComp but that

Is it possible to change the alignment of text/numbers in
a table? the reason that i ask is someone i know (not me,
honest!)has designed a data base table and the text is
right aligned!

I am using Access 2000
I have two tables, a main table and a lookup table
The key in the lookup table is an autonumber field, which starts at one
In the main table, I am trying to make a field lookup a combo box which refers to the second table

I am making a database that tracks each employee's stats
on a daily basis.  The problem I have run into is if an
employee switches managers.  I want the information about
each employee to be viewed under what manager they

Hello, I currently import a text file into my database as
a table "tblMain" what I have in this table are the
following fields; "ID" "LastName" "FirstName" "Absences"
and "Date". The problem I am having is that I have the

OK here's the deal. We have 36 craft. I am keeping track of Deviations
from specs and have to create a serial number every time a deviatin is
authorized. The makeup of the number is five digits that never change
dash four alphnumberic digits that will not change dash three digits

I have inherited an Access 97 database that is being used in several
locations. It is not networked.
The database is split in two: data and code with the data tables being
linked to the code application. The code is distributed as an MDE file.

    I'm  trying to determine if there is a way to get Access to put a
calendar (monthly, yearly, etc) into a table, or however else Access may
create one, and then see what are the values for fields in another table for
a given date.

How do I set up a table field to calculate the record
individual's age, given today's date and that
individual's date of birth?