I am attempting to run this update query from code and I keep getting a
message that says "you are about to update "0" records".  The query
does not update the table at all.  These are linked tables in a back
end mdb.  What am I doing wrong??  The code is as follows.....

Is it possible to filter ontop of the current filter being applied to
records? This seems like it should be easy?
I have two drop down boxes-- one to filter on a student's last name,
one to filter on the current school year. They work seperatly, but not

How do you combine values in a report, for instance:
How do you get:
1  Bacardi Gold
1  Bacardi Gold

I have 2 tables:
person (person_id, first_name, last_name)
phone(phone_id, person_id, number, type)
Each person may have many phone numbers, one for each type

I (Along with the help of some of you guys!) have managed to get a
query working which takes multiple values (types of organisation) from
a list box.
The query returns a list of contacts (tblContacts.ContactID, LastName

Hello - I'm a newbie to coding!
I'm working on an access 2000 database which has three tables:
tblContacts - A list of customer contacts.
tblOrgTypes - A list of organisational types.

I have a report that's basically a calendar. I need to get a footer
that shows the range of dates on the current page (a start date and end
date). I know how to do that by putting a field in the header and using
some VB code to assign footer values.

Has anyone had any success passing an adArray arg to a command object
parameter for an IN Clause?
As in "SELECT * FROM tmp1 WHERE MyID IN ?"
I successfully open the connection object, and I can append the param the

 I have several applications that maintain a Jet database
via ODBC.  There are perhaps two dozen tables, ony two of
which have perhaps 10,000 records each.  The rest are
rather small.  A typical MDB file runs between 1 and 4 MB.

AlphaTIX is a powerful, fast, scalable and easy to use Full Text
Indexing and Retrieval library that will completely satisfy your
application's indexing and retrieval needs.
AlphaTIX indexing technology provides you with highest indexing

I created a simple Data Access Page and it views fine in Internet
Explorer 5.5 on my PC.  But when I try to view it on my Pocket PC
running Pocket PC 2002 operating system, I get the error message that
the page needs Internet Explorer 5.5 or higher to display.  Does anyone

After mastering Oracle and MySQL I decided to get back to the basics of
proprietary SQL databasing for my job and teach myself MS Access.
It has gone sluggish to the point where I have one question.  In having
multiple tables talk to each other, via the "attractive mask" of a

Hoping someone can help.
I am trying to concatenate the ages of still living children divided into
male & female.
So, male 23, female 25, male 13, female 18 should look like this.

I *can* calculate  the Gross Profit Percentage where both the Cost and
SellPrice are known,  using the formula:
(SellPrice - Cost) / SellPrice = GPP
eg  ($24.92 - $14.95) / $24.92 = 40%

I have a make table query in my database that I need to set to run on
startup.   What do I do to get this to work.
Like wise, I actually have 3 make table queries that I need to run and
I'm trying to create an automated script that will run them, but once