I'm using Access 2002, and trying to create a recordset
object. I've Included the "Microsoft DAO" library in my
references.
I currently have a form, table and a module setup in my

How do you set a switchboard to select different queries?

I'm trying to create a chart from a query that spits out 10 fields.(%A,%B,%C.....%N
I want to plot these 10 fields in descending order in the chart.When I use the chart wizard,I get a message saying the chart can accept a maximum of 6 fields
Anyone have ideas on how to plot more ...

Is this option per Application or per Machine?  If I
select "Compact on close", will it work on every database
on that machine, or just the one that was opened when I
selected the option?

I have a subform for Customer Business Partners
The Subform is linked by CustomerID to the Main Form so only the related partners to that customer show
However I would like to display those Partner Records Side by Side across the page and not down the page as it usually does. This ...

I am creating a database to track training on SOP’s (Standard Operating Procedures) by person and job. SOP’s are revised periodically. It is important to know the effective date of the current version. I need help defining the table relationships. The following conditions exist
A ...

I have two tables.
tblZip is a list of all ZIP codes.  it has 3 fields: State, City, and ZIPcode
tblSchools is a list of schools. it has two fields: SchoolName and ZIPcode
I want to create a query that wil have 4 fields:

What I would like to do is to end up with a report that shows the number of
items sold per week. Where the list of goods goes down the left side of the
report and across the top the number of items sold in the last 12 weeks.
..but I do not want to keep altering the query or report ...

I am currently creating a Datebase system, where i have to create forms, could anyone tell me how i do this? Thank
Michelle

I have a problem with my report footer, when the report consist of more than one page I dont get the footer to stay on the bottom of the page.
I have tried to use the page footer but then I get the text on every page not only the last one which I what
Anybody with a good tip on how ...

I am looking for help and ideas.  I am building an
inventory database for salvaged vehicles and parts as well
as our cost, asking price, where we got it, and what we
did with it...all in all, I have 22 columns for each

Needless to say, I am new to Access, although I had years programming DOS databases
In a form I want to display data that is in a table.  In the form's Control Source I put (without quotes) "=[Clients]![IntroDate]"  - where "Clients" is the name of the table and "IntroDate" is the ...

I'm relatively new to the Access world, and had a question
I just can't seem to find an answer too...
I'm trying to make a "pseudo" Inv Control DB.  What I need
is for the worker to be able to input his part number and

Scenario... there are two fields on a form created from a
table. Both fields are combo boxes which show a unit
number and unit description (i.e P06|Pipe Fitting).
One field shows and uses the Unit number...the other

After I create an email and clik send. the email lands in my outbox. I then click send/recieve and it apparently performs this action scince it takes a couple seconds to send the email and the window shows 'send/recieve complete', but my email is still in my outbox!! Under the ...