I put togheater a database with the help of some of your responses. For this
I thank you.
I need to be able to categorize the results of fields on a table, based on a
preset criteria.

I have some queries that will append NEW data from an identical external data
dase. I just import the tables and append the new data. The problem is I have
to run one query, one table at a time. Is there a way to run a macro or some
code that would run all the queries and append ...

My manager gave me an Access database on a disc and asked that I add some
tables and create a new quesry, but it is "read only" and will not let me
save changes.  I was thinking that I could just re-save under a different
name but the save as is in grey when I click on the file ...

I use Acc 2003. I pasted an inventory into my fields and they are all upper
case. Is there a way to change these to first letter of each word upper case
without retyping it all?   Imported:  TOPAZ BRACELET  Would like: Topaz
Bracelet

Alright, so I redid some tables and created a new form to represent the
tables for data entry.  What's weird is, when I tried to fill in the data,
the form wouldn't let me enter any data.  I recreated the form again to see
if it would happen again and it did.  What is up with ...

I split an Access 2000 database in Access 2007. How do I join it back
together so it is as it was previously?

Hi, I am trying to create a Day's delivery sheet seem to have got most right
but am having trouble with the Queries and reports. I want to have either a
query or report that gives me that days deliveries. I have tried >=date in
the critera in Queries

Have several reports I am working on. Need the gridlines (both columns &
rows) for the 'body' of the report, but want to remove the gridlines from the
'header' so can type in whatever I need to (for the title), without
constrictions of gridlines. How do I do this?

Is there a way to change the value of a primary key and automatically change
the value in all linked secondary keys.

Should I secure a database before I split it or after, or does it matter?

I'm so totally "not getting" this -- hope someone can help.
I have 4 tables (tCase, tDates, tMtgs, tNames).   The first 3 tables are
directly related (ID to ID, one-to-one), and have referential integrity.
The tNames table has multiple names that go with the tCase table, so I've

I want to make a query to pull all people with fax numbers.  I can do this
but I have duplicate fax numbers.  Is there a way to only pull one fax number
not the duplicate ones?  If so how would I do that?  Thanks in advance.
Maggie

I have a table of all the payments a student is scheduled to make during
one semester - tbCoursePayments - with the following principal fields:
intStudentID intPayRef dtMonth dtPayDue intAmountDue dtDatePaid dtAmountPaid
I have a form with a subform in datasheet view to list all ...

My company inherited a database that has numerous blank data fields. In order
to make the project work correctly the blank field(s) was populated with the
word "None". This had the desired effect and the project screamed along
nicely.

Did not quite know where to post this...
One of my users is getting a "The Parameter is incorrect" error message upon
opening his database. This is double-clicking on the MDB file. He claims if
he opens Access and chooses the MDB that way, it opens ok.