I am trying to build a form as a type of interactive map, a copy of an
overhead view of farm land.  I have 576 text control boxes, each represents a
single plot of land on the map.  I want to be able to choose a single plot of
land, text box, and have it return only records that ...

I have an auto number field in my table for primary key.
It does not let me to create relationship when I have auto number field.
Should I use long integer instead or I have something wrong?
Your information is great appreicated,

I want to change the default grid dots per inch spacing in Access 2003 forms
design view without having to enter the desired spacing in the form
properties every time I want to design a new form.  I know I can save a blank
template form with the settings and then use that for ...

Hi I would like some advice how to develop a resource forecasting database to
view resourcing graphs. At the moment i have to copy the 'Task Usage' Hours
(for a year) from my Ms Project File and paste the hours in excel to produce
a graph. Cheers

A single .mdb file, containing tables, queries, forms and code, runs at an
acceptable speed whether from a local drive or from a network drive.
Split the file, moving the tables to a back-end and then linking them to the
front-end, and it runs incredibly slowly. A query which ran ...

I want to go from an Excel workbook to an Access DB application so that I can
add additional data and project items without compromising the formulas that
calculate the averages.  I think if I persisted with Excel I could probably
get it to work, but I think it would be better to ...

So I had a database that served it's purpose; however, there have been lots
of changes in the information captured so I think I'll need to start from
scratch so it works.  I need some suggestions to ensure I can get the end
result.  I'm not certain if I can capture all the ...

We are creating a historical log that only records the values at that time of
transaction. I have a table with employee names and job titles that will
become a lookup for some child tables. So, with this, I'd like the lookup
field of job title to be bound to the child tables. ...

I need to graph a Gantt style chart in Access. Is this possible?

I work for a non-profit organization.  With the help of a grant, we hired a
consultant to come in and design a database incorporating 3 divisions of our
organization.  He dazzeled and intimidated us with his technical jargon.  He
has been working on this project since Feb.  In Aug. ...

i am using office 2007
i have a table called titles that has title of the movie and the another
field called year of movie also another table called actor that has actor
name of the actos and another infos

I have a database with three tables that are One to One relationship.  I have
a Primary Field in each table named EventInfo_ID.  I have set the first
EventInfo_ID Field to Identity Yes, Identity Increment 1 and Identity Speed
1.  I then set a relationship with the three Tables by ...

I need help on database design which can manage many to many
relationship between "N" number of tables. for last 2 days i'm
thinking over this but not able to find a solution it will be great if
someone can help me.

I have been using personnel medical claims database designed outside of MS
Access for years. I would like to have something like it made with MS access
but do not have enough knowledge. I have started it and am having problems
with the macro and making it work the right way. Is ...

I'm new to access and just read about normalization. I'm creating a
Sports Card Manager application. My question is how would I normalize
my database. Right now I have one table labeled cards, with all of the
fields in it, like one big spreadsheet. Here are the fields...