Thank you in advance for your help! I have two Excel spreadsheets that I
successfully imported into Access 2003 and created tables for. I need to add
the field from one table to the other, but there is not a direct match in the
relationship. The large table uses the Employee ID ...

I have a record for each contractual document (let's leave it general,
please). Actions are generated against that document. When all actions have
been resolved, the "owner" of the contractual document indicates completion
of document processing by filling in a DateCompleted ...

I have read many, many threads on this, but I haven't found one that really
matches my question.
I would like to have the Find window to default to a "General Search",  and I
have made the appropriate settings within the Tools/Options/Edit/Find

Is there a way to fax the form page via the fax modem on my computer?

I am wondering is it possible to set up a database where i can keep adding
questions to a table and then print out a random test from the questions
entered. like 30 random questions out of the database and thenprint them.
Also ifthis can be done what way would it have to be laid ...

  I have a field "Received" in a query formatted General date,i added
another field to extract the week day using the formula
Day:format([received],"ddd") now i want to sort the field day ascendingly in
a week that starts from Sun,i tried to sort it but actually it's sorted

I am trying to create a tree or roots or branch type diagram in access.
What I am tring to do, I have a list of customers and whom they were
recommended by.  I want to create a branch list that shows who was recommend
by who, so I can follow each customer back to the source.

I need to upload data from PeopleSoft 8.9 on a regular basis to an Access
Database.  As this is employee data and changes regularly I need to be able
to update the records with new information for employees already in the
system.  I would like to link the two databases directly ...

Tomorrow is Show-And-Tell time....   I can probably put it off
until after lunch, but I'd really like to show the user something
in time for them to organize their observations/change requests
in time for me to work through the weekend.

This is really strange, but I can't figure out what is causing this.
I have an Access 2007 application stored on a network shared drive. I
just created a new report, saved the report, and closed Access.
Then, I went to my wife's laptop, and opened the application from

I don't know if this is the correct approach, but this is the idea
I've got:
A form will have a few controls to enter some data and two buttons.
One button is "Enter as New Record" - this one opens a subform for the

The popup calendar I downloaded from Allen Browne's site worked in one
Database perfectly, but after I importing it into 2 other databases since
then it has not worked.  Ithas to be user error, but I can't figure it out.  
I receive the following message after replacing the ...

I have two tables: Table 1 stores the primary key, Protocol#, along with
details about the protocol. Table 2 stores additional information that will
apply to SOME of hte protocols. It has no primary key, but is linked to table
1 through Protocol#.

Hey All,
I have a query which allows users to score projects by a number of factors
which help determine that project's priority for funding. The various scores
are totaled and the project given an overall score. I would like a query to

I have a monthly productivity report that I print for a list of staff members
and the report content is fine. However, some employees have multiple pages
and I have to indicate page numberings at the footer (i.e., Page 1 of 7,
etc...).  The problem is that Access will indicate ...