I've designed a query which merely counts the number of different types
of orders.
What I am after is a way of getting a Grand Total which will be the Sum
of all the totals.

If Err.Number = 2001 Then
I have the above line in a procedure
I downloaded. I don't know what error
that is exactly.

I am trying to use the calendar control in Access (Calendar Control 11.0)
I have it working but for only one form. I do not know VB/VBA very well, but
how can I open the calendar control, which is on a form called frmcalendar,
so that all I have to do is click or double click a ...

I am new to access, building a query for doctor's info, on the query
design view, Last Name field, how to let people in a pop up window:
"Enter last Name", just put in any first letter  to find the last names
begining with that letter. such as type in: y, will give all possible

I'm trying to add two radio buttons to a form.  It is a simple male or
female choice.  I have added the column to the table, added the
choices, and grouped them on the form.  How do I get the selection from
the form to put the right response in the table?

I have a main table that I need to delete records that arn't referenced in
another. Query says I cannot delete.
If I remove the reference query all deletes ok.
Hope there is a way around this ?

Without building a report, can VBA simply print
a query's dynaset - much in the same manner
one would by opening the query manually from
the database window and clicking File, Print?

Set rstOtherTable = MyDB.OpenRecordset(xxx, dbOpenDynaset)
I have a question regarding syntax of the above OpenRecordset method:
Is it OK for xxx to reference both tables and queries when using
dbOpenDynaset?

Given the following statement:
SELECT * FROM tbl
WHERE [tbl].[column] IN ('a', 'b', 'c');
I want to be able to continue using IN so how could I change it so

What is the best way to include a picture of a product on a form that
includes info like (costs,  list prices, sold, bought, and the like). I have
jpg files of products and would like to link to form and table. I am not
able to do code some simple macros ok

I use this to list table fieldnames to the debug window.
Can it be modified to perform similar objective for saved
query objects? Would it be best to trash this completely
and write a procedure for queries from scratch?

I am writing a hands on test in MS acess 2003 , and I need to disable
the user access tothe help file. HOw do I do that? I tryed to install
acess adn diselecte the help file but I didn't get a option to do that?
Is that any file I can delete from the computer ?

hey... i have a report whose detail section is based on three departments so
the report is 3 pages for that, plus two pages for a report footer and a
cover page report header.  if the three departments are a, b and c, i can get
them to print either in ascending or decending order.  ...

What does it mean if I get a "Reserved Error" #2950 when running
Application.SaveAsText acModule, "AutoExec","c:\TextFile"  ???

what's the difference between inner join and outer join in sql?