I have a recordset find method that works with a simple expression such
as:
"ProdID=100"
but when I use

The database I am working with contains a field with as many as 12
different values (09,10,11,12,13,14,15,16,17,18,19,20)
My end user has requested that the number of times these 12 different
values appear in the table be grouped in the following 8 groups (15 or

I set the input mask for the date field to "00/00/00;0_" but instead of
showing a 6 digit date such as 01/01/06, I receive 01/01/2006 an 8
digit date!
Is there a manner in which I can over ride this?...In the table

Operating in A97.
I didn't receive much of a response conserning Pivot tables in Access.
Pivot tables are nice, but a CrossTab will work for me too.
Using a Pivot table, one is actually launching Excel for data viewing.

Today's problem is - my combo box works great until it comes across a name
with an apostrophe, such as Bill's Bike Shop. I'm sure this is very common
problem and I'm sure the work around is very simple. But danged if I can
find it. Thanks for your help.

I am trying to have a button on my order form that will work out how
much is outstanding on the order
on the form i have the total value of the the order  and also have text
box that i want to dispaly the remaning amount.

Is it possible to limit the number of Subform records using MS Access
2003?
That is, my end users want the capability of entering up to 12 records
on their subform.

Say you have a one dimensional array of 10 elements and a named range
called Data. You want to write the elements of the array to the sheet
starting from range Data. Without using a loop, how can this be
achieved?

How do I acheive this, any one know.
Thanks in advance.
Nick

There is code in Alison Balter's excellant "Mastering Access 2003"  to
create a list of error codes and descriptions but it only generates
error messages 3 through 94.  Is there a website with a list of all of
the error messages (with descriptions?).

I have a search results form that is being displayed as a continous
form.
I want to double click the name and then using VBA select the different
columns of information.

I am being thick.
I have a table of employees - EmpID & EmpName
I have a table or wage rates for each employee - RateID, EmpID, WageRate
RateFron (Date)

Hi Every body
I have a query that outputs students names on certain criteria
I want to collect these names in a single textbox in a form(separated
by space or dash)

Have a database with 100 or more tables.
Would like to set some property to flag those
whose data is dynamic from those tables
containing essentially static reference data.

About a year ago there was a thread about the use of global variables
in A97:
http://groups.google.com/group/comp.databases.ms-access/browse_frm/thread/fedc83
7a5aeb6157