We estimate construction projects at various stages of
architectural design, and are in the process of developing
a database application that manages various administrative
functions--billing, performance history, scheduling, etc.

I am not a regular Access guy so pardon if the problem is
simple for you. I inherited an Access application that has
5 different table names but the structure. That is 1 for
each year. Example would be tbl1998, tbl1999, tbl2000,

I've read a bit about junction tables, but I'm still not
sure I have it right.  Is it necessary for there to be a
third field aside from the PK from the other two tables?  
I've read that the third field needs to be common to

i have an access application and i want to make an exe
file for application and run it without opening that in
access. how can i ?

The application I am working on is getting more and more
attention from management. They are asking to add more
data to it. To better manage the database, I'll need to
rename the tables, queries and forms.

I have 12 excel spreadsheets with totals in about 10
columns, I wish to link these totals to records in an
access table. Is this possible, and if so what is the best
way of doing it.  Thank you very much for your kind

I wish to define a one-to-many relationship between two
tables.  The foreign key is in a single field, but in the
other table, the matching primary key is in two distinct
fields.  In the Relationship window I finally got

I have committed a new user error!  Any help resolving is greatly appreciated!
In November I started building a new database.  I created new forms from the first by "Saving as" a new form name and changing properties as I went.  I had 8 forms and 2 forms working perfectly finally ...

I've been filling an access database table with both English and Cyrilic
characters. I was doint it directly into the table, without using a form.
In the table itself the Cyrilics looks OK.
But when I view it in a form, every Cyrillic letter tirns into a vertical

In creating a table for maintenance of a fleet of cars, I would like each record to auto number as the primary key, except I'd like it to be PER CAR instead of overall. ex: Car 2 could have records 1-100, and Car 3 could have records 1-250, etc. This would make the Car # and ...

I am trying to establish referential integrity between two
tables.  I linked them by IDnumber.  Facility Information
is the primary table and IDnumber is the primary key.  The
communication table is the secondary table.  It should be

Is there an easier way to setup data bases with dozens of,
Yes / No, Male / Female, Ethnicity with 7 Different...
I know I am whinning but if there is an easier way that
requires less that two (2) brain cells id really

Hi all - Access 2002 - WinME
Our company will be begin the 'Start-up' operations of the latest extension
of our Light Rail system in March next year.  We will need to track all
related costs and man-hours assigned to the various start-up projects. The

I am in the process of building a database that tracks all
the training we do.  My problem is not the people that get
it, but tracking the people that do not get the various
training that is required.  I know what all that training

I was wondering whether I could take the thread below a step further?
'Adding a new field to a table'
(http://www.msaccessforum.com/t53015-s)
I understand how to amend a certain TableDef to add a new field to a