I have a form that is based on a Query. Since I have based the form on the
query I can no longer enter information on my form. I am stumped. How can I
base a form on a query and still be able to enter info on my table?
rebecca&payh.org

I am running a query which references a subquery.  the criteria in the
subquery is set to a value in the form (Forms!Results!cboSeason)  
I am receiving the error: too few parameters.  Can I use a forms value in a
subquery?  When I take it out it works.  So far, from what I read, ...

I am using the JDBC-ODBC bridge from Sun to load data into an Access
database by calling on the executeUpdate method of the PreparedStatement
object.
I get a return value of 1 and no error messages. However when I open the

Albert,
Thanks for making your WordMerge20 sample db available- it's very slick!  I
have a question about chosing a query.  All of the queries that I'd like to
use for my WordMerge require user input- they are renewal notices with an "as

I am  confused with the following Query.  I would like to delete all records
where the ITNO, PO, Line, and Vendor fields are the same in two tables.  
DELETE FROM tblReleased WHERE
(

DISTINCT vs GROUPBY ?
Hello all,
I'm trying to figure out if there is any difference of performance using
either

I have a database with many tables and queries, which I have been developing
for several months now.  Today, all of the queries which contain at least one
expresion started generating a compile error.  I have not made any recent
changes to most of these queries, and they all ...

Hi.
Im working on an A2000/XP mdb which has a field containing entries like
"Maths Mentor", "English Mentor", "Music Mentor" etc. The second word is
always Mentor. Is there an expression I can use in a query that strips off

Hi can anyone help with this:
I'm trying to use an IIf Between and And statement to work out
curriculum levels  ie if between 1 and 4 then show '3c' if between 5
and 8 then show '3b' and so on, I've got the first bit working ok, but

can anyone tell me what this error means and how to fix it?
Thanks

Hi there,
I have a bit of a problem.  In MS Excel, I can easily compute a tiered
discount using the mininum and maximum functions.  In Access however, this
doesn't work.

I have two queries which I have joined through a field. I am trying to delete
records from one query based on a criteria. I had accomplished this using
joined tables but due to permission issues, I am having to change tables to
queries. I dont know if one can delete records from ...

Is there a way to order a table in the same order as the data was entered?
I know in Oracle you could do this using rownum, but I have not been able to
find anything in Access for this.
Thanks,

Using Access2000, I am trying to use an unbound form to specify the criteria
for my query.  In the unbound form, I have multiple fields, where any of them
may be filled in to further filter the results.  In cases where the field is
left blank, it should be assumed that the ...

I have a database for budget purposes in each record has a "Notes" field for
explanation.  The data is accepted into the form and table without any
problems but when I pull a report some of the memo items are truncated.  I
have the "Notes" Property Item "Can Grow" set to "yes".