I am a bit confused by my relationships and keys. Perhaps someone could help! My database contains information about sites. The sites will contain houses. I...

I am an administrator and I have designed a small database which will be used by my colleagues at work. It's nothing brilliant but I'm confident it more or...

I have to design a database. It will contain details of planning applications. I've been told there is not a single item which will identify a site. There...

I have enforced referential integrity in my relationships. However, it seems to cause a problem if I want to leave a field blank! One of my tables is...

I have a table called 'client'. In it is a field called dateclosed. There's also another one called 'casestatus'. When someone enters a date into the...

I am still trying to design my database (keep getting given extra info which changes things). It is all to do with sites for housing developments. Each site...

I have to remove a field from one of the tables in my database. Access is telling me 'You can't delete the field. It is part of one or more relationships....

I need to change a field from a date format to year only. So instead of it reading 1 Apr 2008 or something similar it now only contains the year, ie, 2008....

Here's my scenario: The scheme is donors who make contributions. Here’s where I have a little trouble: The donations are of different types and need to...

When using the page I created to click through records I keep getting this error when I come to certain records. I can't figure out what field or parameters...

Why pay over $90.00 a month for Cable or Satellite TV services? Instantly Turn your Computer into a Super TV Get over 3000 STATIONS on your PC or...

I have an IT-generated database with a non-duplicating primary key that is a text field- unique inventory part. I now need to design an expanded database on my...

Hi, I'm having a little problem with making forms. The situation: I'm making a database for someone who is giving courses (design, etc). There are 4...

I have set up a database to hold data and test parameters. Currently I have two main tables, one is a catalog of samples including a catalog number(primary...

I have 3 tables: OrdersTable (OrdersTable_ID, ,....) OrderDetailsTable (OrdersTable_ID, Product_ID...) ProductsTable (Product_ID, ...

I want to import data to an existing table. I want to overwrite the data for existing primary key records and append new records for those that do not already...

All of the sudden, my tables won't relink (front-end program to back-end data) I didn't change anything in the structure of the database. What might cause...

Here is the situation: I have a front-end and back-end to a database that I maintain. I want to leave the database up to someone else and I want to automate...

In design view, I am trying to use the variable contents one one field to use as the default data in another field w/in the same table. I am trying to use the...

Microsoft has an "Access 97 Relationship Print Wizard"...