I am trying to save the value of a primany key as a foreign key in another
table. I would normally do this by linking subforms but the form is looking
good and i have all sorts of stuff linking to it that I don't want to mess
around with.

I am looking for a Headcount template to manage about 400 people.  Does
anybody have a good template.

Basically, I have two columns:  "Description" (a text field), and "Call
Number" (also a text field).  The first spreadsheet I successfully imported
had only numbers for the "Call Number" field.  The second sheet that failed
had "Call Numbers" that had numbers and letters (such as ...

Excuse me but I am getting old and forgetfull.
I developed a db about 8 mo ago for a golf course and did something so the
non-programming folks would not get to design view, etc...
Now they want me to do some change and forget how to get design view back,

Just had my computer upgraded to XP pro with Access 2003 and Word 2003.
Is there a way of sending the results of a query to a Word mailmerge
document.
Is there a simple way of doing it or does one have to use ODBC, OLE, DDE or

I am not very knowledgeable in Access, aside from being able to create tables
and forms, no code.  I use access on a shared drive, but I am the only one
who makes changes to it, all other users input data on forms only.  Sometimes
I can not open it when someone else is in it, and ...

Why would the changes I make in the Page Set-up feature (& save these
changes) always revert back to the default???? It's frustrating to have to
reformat my Report everytime I look at it.

Hi, let me start by saying I am Very new to Access. :) What I am looking for
is a template for content management.  I have found some, but nothing is
exactly what I need.  I'm not sure it's even possible.  This is what I am
looking for.  I have 3 excel spreadsheets with multiple ...

I am writing a script that updates data from one database table to another
database table, and in my sql statement, I compare the first names and the
last names.  At first I was getting an error because there were apostrophes
in some of the names, now I have a function that ...

This is a little complicated but I'll try my best to explain.
I have an order form with items on it.
Each item on that order form has to print to a different printer.
I have 3 different printers that they can print to.

Can you have a form link you to another form by using a button? Or can you
only do that with a switchboard?

Hi, I have a basic database for a sporting group. I have a list of matches
(approximately 500 matches) to be played. eg. joe   versus   bob, and greg
versus harry. My question is how do I do a count of how many times bob has
won, or do a report on who has won the most matches, down ...

I am trying to create a substring that will only recognize the 3 and 5
characters of a set of numbers that will exclude these numbers when I run the
query. I am not sure what my syntax should be though. Possibly
substr(to_char(hours.projectNumber),3,5) <> "0599998" And

I ran a query with city, state and school enrollment and I want to know the
total enrollment from all schools in each city. There are duplicates of many
cities.
Thank you in advance for any help.

I have a excel tabe with 60 columns. first 5 of these columns are data to be
filled and rest is calculated automatically using formula  in excel. I expect
in due course of time there will be 1000 rows filled (at present only 200
are filled). so all my 1000 rows (except the first ...