How can I uncheck the "Search Fields as Formatted" box in Access2003 as a
default setting.  Users forget to do this at the start of a Search and the
search then takes a longer time.

I am using a query to do some imported data validaton.  All was well.  I had
to add some additional business rules which increased the number arguments I
need to pass to the function to validate.  I have 12 arguments and I get this
error:

Hello, i am a newbie to access, it is possible intersect this two tables in
a new table
The table T1
   Data as DATE

I need to carry out a search for a number of items in a list box. The number
of items will vary each time and what is searched witll vary each time.
I have set up the list box and query but now i just need some code to help.
Im very clueless when it comes to code so if someone ...

I have several values I would like the queries to display, however i have run
out of space in the criteria entry boxes. Is there a way to expand selection
OR leave out certain criteria.

I have set up a parameter query on a Y/N field. How do I control how to
answer the question? At this point i have to answer with 0 or -1.
Thanks

In Access 2003 I need to make a new table from an existing table. Each
record in the existing table has information on costs for a project
over 3 years. The new table must have a record for each project for
each year. ie One record in the existing table will convert to three

I have a parameter query that filters date and another field "Step" for my
reports.
This works fine except now I need to be able to choose more than one Step
for my report.

After much work....and much great help from this board, all things are coming
together.
BUT....now... the one "GRAND QUERY" that actually brings it all together
seems to not allow more than 16 fields to be referenced.

I want to have a field in a query that shows yes/no depending on whether a
date is present in another field.  It doesn't seem to work:-
SELECT [tbl_CR_CR2Deliverables].[ID], [tbl_CR_CR2Deliverables].[Delivery
Expected], [tbl_CR_CR2Deliverables].[Delivered],

What's the easiest way to append ten tables and simultaneously add a new
field on the new table that records the table the appended records orginated
from?
Thanks from a query/Tabledefs collection beginner!

I am trying to create a crosstab query to populate a report.  I have a many
to many relationship. For instance table 1 customerid, startdate; table 2
savcustid, customerid, savingsID; table 3 savingsID, savings.
What I am trying to do is on a form select some date corresponding to ...

I have a price table that the first column shows the old part number and the
second column shows the new part number.  I need to add the word "USE" to the
front of  each record in the second column.  Can you help?
Thank you,

Query elapsed time sequential history moments.
Hi to All,
I have a Table "StatusHistory"designed as:
PK, AutoNumer, Primary Key

Is it possible to use a query or table as a RowSource for a list box
as well as be able to add values to the RowSource in VB as you can if
the type was Value List?
If not, how can I go about extracting a column of values from a table