Ok, I tied all my tables together, however, instead of answering edit to one
table as I was changing my one to many relationships, I created a new one.  
Now I have two of the same table except there is a "1" in the title to the
newly created one.  I want to delete that particular ...

I am using Access 2000
I created a Db, forms and reports early this year.  Through out the year, I
edited records and added new records using a form I created.  Then yesterday,
I decided to try and put a password to the Db to eliminate anyone not

My XP Professional Home Edition doesn't have Front Page for SP3 installation!!
I've gotten  Microsoft Office XP Professional Service Pack 3 CD-rom for my
Microsoft Office XP Professional HOME EDITION which doesn't have Front Page
on the orginal purchased CDs.

All,
Thank you very much for your suggestion to check out the "At Your Survey"
database - this proves very helpful.
I did have a question regarding its design and its pertenance within my

I read a post on here about "splitting" the databases.  In replication
synchrinization, I have run across some corruption of the files.  Queries not
running, when clearly they exist and what not.  Are these the kind of errors
that replication creates?  If I split the databases, ...

What is the best way to have defaults in one location but available to the
whole application. Some examples would be Sales Tax rate, Late Fee charge in
addition to things like scanners/printers or other things used with in the
program.

I want to make a data base which (among other fields) has the field "Bank".
In this field I want to register up to 20 banks for each observation (which
is a company). Is that possible? The point is that I want to be able to make
a report that shows which banks are involved with ...

My boss wants me to design a form for our database which allows the user to
select from a reduced set of options each time they click on subsequent drop
down boxes (i.e. it only finds matches from within previous selections).  
These are currently all in one table but the final ...

I am attempting to make a table with 5 years of date on it
When i add Date2 field i get nothing
It runs fine with only date and week field
wanting to make

I am trying to plan for a database that allready contains repeating fields
and existing data.
eg.
Spec 1   Spec 2   Spec 3    RSpec1    RSpec2   MembID

Is there a way to set\change the Format Property of a filed in table by SQL
statement?

I have imported data where in one field (Invent#) leading spaces and perhaps
also trailing ones appear. I tried to get rid of these by first creating a
new field (CorrInv#) and then using an update query. In the grid I have one
column with CorrInv# as field name and at the line ...

Using access 2000 (because that is what client has). I have a table with a
large # of fields, 209 at present but it will come down a few when test
fields are removed. I am setting a descriptive caption on the fields to
display as labels when they are placed on a form. Most ...

I am having quite a problem regarding a database I am trying to put together
from linked tables in our inventory program, Mas 200.
I am using 4 different basic tables
SO1 Make Table - fields: SalesOrderNumber, SalesOrderDate, ShipDate,

I have an Access 97 database with two Tables on has only two Fields
"Officer" "Location" I use this Table in a Combo Box for the Officer to
enter their name into the second maindata table. What I now need to do is
that when the Officer selects his name from the first table I want ...