Not sure where to post this.  I have two tables and a
form for each table.  Tables are joined.  I want my first
form to have the second form as a subform.  I can do that
by just clicking on subform toolbar--- but I want the

Problem is when I view relationships, a main table is
completely above top border of the window, so can't see
it, nor drag it back into sight, only see the relationship
lines going to it.

I have JOHN, SMITH in one column, but I need John in one
column and Smith in another column.  Do I have to create a
column named Last name and copy and paste all the names?  
There's gotta be an easier way.

Is it possible to import data from an Excel spreadsheet
into an existing Table and have the data populate in a
field on existing records?
For example, I have a database that contains Customer

Is there a way i can have one tables defalut text value
lookup a user defined value in another table?  I know i
can use the form level to do this, but is it possible in
the table level?

Hi again
And here's my second question... is it possible to get multiple subdatasheets open at once?
For example, if I have a "People" table, an "Address" table, a "Phone Numbers" table, and an "Email" table, is it possible to get the latter three to all open up under the People ...

I have a form that brings up a group of business names for
us to give to callers.  Is there a way to rotate the names
so that the same name doesn't always come up first and
that we are not always referring the same company.

Dear Sir/Mam:
I am using access database in my application. Access 97
database is working corectly with vb 6.0 but access
2000/2002 is not working and giving error message

When you create a primary key on a table, does the primary key create an index or is it just a constrinat on the table
Thanks
ThomasLL

I have a field that contains dates in the following format:
1/1/03 - 1/2/03
11/1/03 - 11/2/03
I would like to be able to split the dates but I am unable

I can establish first primary key link table A to table B.
When I try the
second different primary key link, table A to table B, a
message appears that

Does anyone have a good template for a large scale
survey/questionnaire?

What's up wise ones?  I have a need that must be taken care pretty quickly.  I need to know where can get a sample Fitness Center-type Membership database.  I need to look at the keys and the relationsips between tables so that I can complete a project for a customer.  It should ...

 I have a number of installations that have a current version of an
Access DB, however the latest version of my software required a change
to the DB structure. Is there any way I can include a 'script' to
easily apply all the DB changes without having to apply them manually?

I want to make design changes on a database which one of
it's tables is linked to other database. the other
database is now being used.
Can I make design changes without affecting the other?