I have a cross-tab query built on another query. I have created a
form to display the cross-tab query. Now, I would like to restrict the
results of the cross-tab query by passing a couple of params to the
base query. Am just not getting anywhere. Can someone please help?

How do I add dao reference library to object browser in access 2000

As an amateur Access user, I've noticed that sometimes a period "." is used
instead of an exclamation "!" mark or vice-versa. For example as in:
Parent!fieldname or Forms.Formname.Fieldname or Me.Fieldname
I don't know if I used them correctly in my examples, but just curious about ...

Is it possible to write code that would allow changing of the location to the
linking tables?

I have a form with some required fields.  When they fail to enter data in
that field, it pops up a message box.  It takes them back to that field.
What if they don't know the information and they want to close the form?  I
can't get that to work.  I have added a "Close Form" button ...

I've got one table that lists contract payments for multiple monthly
payments.  Each record has contract number, payment date, payment amount
In another table I have all the contract info: contract number, contract
name, contract city, contract description, etc.

Hello,
I have a form that I want to make a few fields required. If I set the required property to Yes in the table the form is linked to, an error message comes up when one tries to save the form. However, this does not identify which fields are required for input. Is there a way ...

I have a filtering system in place to locate a specfic record in a table, but
for some odd reason it refuses to delete programically.
The code is as follows:
Criteria = "EmpID = " & EmpID & " and CourseID = " & CorID & " and SessionID

I am trying to enter an expression in the control field of my subform.
My goal is to have it add all amounts in the subform unless there is a date
in the cancel field.  If there is a date in the cancel field I would like it
to subtract that amount.

After i execute rs.Addnew....rs.Update how do I get the autonumber key that
was added?

I have a combo box that I'd like to use 2 ways.
1) Look Up Data in external table and populate form with data found. I got
this to work just fine.
Its the second way that I need help with:

I have a table that I have added a new column to (Projected End Date). I need
to autopopulate this column based on data in two existing columns. (Start
Date), and (Length). So all records would populate with Start Date + Length =
Projected End Date. I already created a form that ...

I have a situation in which one department is wanting to scan in old and new
invoices, etc to reduce the amt of paper.  But they would like to be able to
assign the scanned document(s) to the proper client and be able to display
the document(s) in A2k3 when they select the client ...

Here the problem~
I have a field "JobName" in a continous view, sub-form "sfrm_Jobs".
The sub-form is in "frm_Customers". I want to use the"JobName" field's
"on click" event to open "frm_Specs" and have it filter out everything

I have a report that shows the athletes in a  sporting event and their
coach’s name if the coach is also a judge/referee at this event.  The poupose
is so that when seting up the competition we can ensure the athlete will not
be in a lane where their coach will be judging them.