I am restructuring a database in Access 2007; it was built in older versions
of Access progressively over the years.  Yesterday everything was as it
should be-today the Tables and Related Views option in the Navigation Pane is
missing.  I have closed and re-opened the database ...

I have a database
tbl_Vendors =  Vendor_ID (auto) PK
tbl_Sites = Site_ID (auto) PK, Vendor_ID (number) FK
tbl_SiteVisits = SV_ID (auto) PK, Site_ID (number) FK

I have to create a database which monitors outcomes every four hours.  I have
created a table which covers 1 day and have then copied this to make the 2nd
day and so on.  The problem I have, this monitoring can last 1 day or it has
been known to last up to 6wks in some cases.  Is ...

I have a number data type in my primary key field and for some reason when i
key in 016 it reverts to the number 16. What can be done so it does not
remove the zero?

Can someone help me understand how to require that a record be put in a table
if a record is put in a related table.
Example:  If I am entering a Site Visit in my Site Visit Table, I MUST
include at least one Unit (which I visited) in my related Unit table and my

I am trying to figure a way out to make a table that will import data in this
format.
http://www.drf.com/entries/24/eCPW24.html?rn=500027
I was able to import this through excel but trying to see if there is a way

How do I connect a command button on an access page to a report

In design view, in an access table, under format a text field:
What is the expression ( like ">" that forces capitalization) to forced
upper case for the first letter of each word

All,
I've got a database currently residing on my server.  Many users access the
database to:
1. View data

I have 650 users located all across the U.S. that are out in the field and
log on to laptops throughout the day.  Does my company have to have a server
out there that all 650 users can access the back-end database that contains
the tables that each of their front-ends needs?

I am part of a group with 60,000 members and growing. Several hundred have
expressed a desire to all join an affiliate program, and it is important that
I be able to organize and track the joining process, so that each member gets
2 other members to join under them. I would like ...

I want to create a self relationship to track parnets of Goats.  each Mother
Goat has a tag and tag is the key field.  An example of the tag could be
Yellow13 or Black4.  As a mother has babies, I place a tag on baby, I want to
enter the baby in the Table with the new tag, and be ...

I think I figured out my tables and relationships.  
Tables:
Table 1
tblTowedVehicles

dear friends, i want to make database as follwos
manufacturers their products with pricing and other details
note there are more than 20 manufacturers and more than
1000 product they have,

I would like to be able to type a zip code into a form, and have it
automatically return the City and State into their respectiver fields, or
enter the city and state and have it return the zip code.
I have one table which contains Zip, City, and State fields which is the