I am building up an address database, where I will need to add data
frequntly. The database is built up in a number of  tables and I wonder what
is the right way of entering new data, without having got to enter them in a
number of tables?

Hi, I have been trying to teach myself Access and design a database to record
students' mandatory community service hours for about 8 months now.Just when
I think I understand, I come up against a wall.
This is what I have so far and am open to any and all suggestions.

I'm developing a courier appln which contains the customer rates
different for each customer.
i need to fetch the customer rates from the db. Each and every customer
have different rates for the different countries, cities. I can't

Both for an Inventory DB I'm working on, and for general knowledge for future,
wondering about the following situation -
Intentory Item (parts) table, approx 2000 records at this time, having the usual
fields; Vendor, Manufact., partNo., etc.  For about 25-50 of these

Hi people, I'm relatively new to access and relational databases and I need a
little help.
I have several tables, and the ones I need help with are the following:
People

I found a website that displays a calendar. It's possible to click on a date,
and a dialog box pops up. In the particular instance I'm referring to it has
a brief quote, but this could be used for a number of other items, including
birthdays, special events, quotes, reminders, ...

Is there any way to disable the main close button on a database?

I am looking for some direction here and hoping for help.
First let me outline a couple of things. The non-profit organization I work
for is a homeowners association, and part of the associations common grounds
is three cabins to rent, a campground which includes three shelters, a

Hi, How can I indicate the relation to be a 1to1 or 1-to-many or many-to-1 on
my relationship diagram.  It seems to have a mind of its own on deciding what
it should be.  The field in the edit relation dialog is Read-Only and I can't
edit it.  

I work for a company with numerous branches.  On occassion, any branch may
have information to add to a list that we're looking to consolidate into a
database.
I'd like to design a Data Access Page in Access 2003 and post it on our

I'm trying to create a Multiselect function for a list box in a form which
has a subform. I've tried using both Simple or Extended, then selecting terms
from the list in one record but then uses that term for all records in my
database. Any idea how I can select different terms ...

1. I have a database with 9 tables. My main table has about 100 fields in it,
and I am looking at adding more fields to this main table, and yes they are
all related, but I'm thinking the table is getting too big. Are there
guidlines for a size of a table?

I'm a .net developer working with developing automation equipment for the
sawmill industry. The main focus of our product line is mechanical and
measurement equipment but our clients start asking us for an inventory system
to keep track of their produced volume.

I'll like to know how do I open a specific record on a record form??? In
order for me to edit that specific record and or reading it...
Thanks
I know this trick is as old as Access is... but ups... I forgot how to do

I am creating a client database in MS Access with the following (simplified)
table structure:
tblContacts:
ContactID (pk - autonumber)