i have a parameter query that gets its parameters from a form.  i have date,
employee, job#, task #, etc.  (every record in table is unique not because of
any one thing (job#) but through a combination of all these things plus some
others).  anyway, if the user wants to list all ...

I deal with both companies and end users and I'm trying to figure out how to
set up the contact table.  My plan was to set one table for companies and
have contact entries as a sub form and another form for contacts with
individuals but both the company contact sub form and the ...

I have a report where the default menubar is the Access default report
menubar.
I built a custom menubar that only has a Close button on it, and no Print
buttons. (NoReportPrint)

Office 97, is it possible to password protect (opening, using, running) a
query and not the database?
Thanks
GRCC

I can't seem to find any introductory material on charting.
I want to chart this recordset (fields go to December):
Yar           Jan     Feb        Mar      Apr
----         ------   ------    ------    ------

how do I format colums of # to $ and sum of on an Access spredsht

I've been requested to write a program to transfer data from one M
Access database to another MS Access database (doing it manuall
isn't a problem but an automated program is required)
I have a query which converts the data in DB1 to the right format (

Hello everyone, I'am so stumped.
I'm pretty good with Excel, so I know I can do this in excel if I really try
with a few formulas.  But it would be something that I would have to do every
week.  So this is my problem.

I currently have a date field formatted as number, ex.110690.
I want to create a query that just searches all the records by the year.
Is there a way that access can exclude the first 4 digits and only query by
the last 2?

How do I get access to do the following:
I have a table with multiple records and fields. I wish to swap the value of
a particular field of two records. This field should have a unique value so
I don't need to worry about two records with the same value. For example:

Is it possible to create an organizational chart in Access?  If so can
someone help me to get started.  I have all employee names, their dept, their
supervisor, and rank (#) assigned to each employee as to how they rank within
the structure of the company, there are also dept ...

One day, I am going to have what's called "newsgroup posting rage" and I am
just going to post a screenshot!............................<just kidding>
Ok.  I had some wonderful help from Tina who got my tables designed and
relationships established. She also made some basic forms ...

How do you open a Form {Data Entry only) to show the next avaiable
number in ID field when it opens.  I'm not using autonuber.  I want the
form o be Data Entry ready but showing the next available number so that
the customer doesn't have to look for the next number.

I am VERY new to web design and I can't figure out how to allow a page on my
website to be printed in a "printable view" that I see on so many websites
that only prints the text as opposed to all of the extraneous stuff on the
page that  I would get if I just printed from the ...