I am hoping for some advice.  I have built an access database with multiple
tables.  The main tables are:  tbl_Investigator (names, addresses of outside
investigators); tbl_Project (project information); tbl_Reviewer (names,
addresses of internal reviewers).  These tables are ...

I want to auto update data information from another table. Below is my table
set ups.
I want to link two tables so it updates automatically when one table field
is updated another table field is also auto update.

I have created a lookup column in Access 2007 but I need for people to be
able to choose more than one option on this one field.  Does anybody know how
to do this.  What im asking for is really a "please tick all appropriate
answers" field.

I have a DB (Access 2003) which contains two tables each table is linked two
a seperate SharePoint site.
My objective is to keep the Table 2 columns updated by pulling data from
Table 1. Subsequently, I want perform this action without overwriting data in

I have a field called account number which can only consist of 9 characters
in total in most instances the account number consists of just 9 numbers but
rarely there are ones that have 8 numbers and an x on the end.
i have set the field type to "text" and i have set the validation ...

My boss is chairman of a committee that awards scholarships to college
students. This organization's members are different companies around the
states. I am trying to put together a database that will help us keep track
of applicants. The information I'd like to keep is applicant ...

I have two tables one will house the main account information and the second
will have the monthly amount charged, on the second table, I want an
autonumber that will tell me what payment number this is for this account.  
These accounts all start at various times, so one might be ...

I am attempting to create an invoice from linked databases; customers and
tank rentals at 4 levels of costs.  I can link the customers to the tank
database with, after monthly entries of incoming and outgoing tanks, will
reflect the detail of the tanks and ID.  There will be a ...

Hello.  I'm new to this group and I have a question:
I created a form to build a quiz by entering the question,
distractors, correct answer and graphic name if one is used, and some
other information needed for the quiz.  Once the user finishes making

I need help from start to finish because I think there are probably many
steps to do this.  I would like to put a command button on a form so when
the user clicks on it, the result from my query will be stored in a table or
excel spreadsheet.

I'm supporting a database that is comprised largely of fields and variables
with the data type Single. Over the years, the client's needs have changed,
so occasionally I have to change some of these fields and variables to
Double. This doesn't happen often, but once in a while, ...

I have a subform with fields: First Name, Last Name, Phone, Expiration Date,
Membership Status. I want to create a calculated control to display the total
number of records appearing in the subform. How would I do this?

I've got a database which includes a number of tables, some of which
are linked on a primary key.  When I first designed it, they didn't
have a unique identifier for the table entries, so I just used an
autonumber field.  Now, they have a unique identifier which includes

Is there a way to play a Wav sound file when a command button is pressed?

I created an Inventory Control Database using the template in Access 2000. My
only problem is that the products table does not meet my needs. I need to
replace the Products table with about five new tables. I want to start small
so for now I have replaced The Products table with ...