this may be a stupid question...
how do I create a parameter query that is the equivalent of
where x contains "something" and the results return all entries that
have the word something anywhere in the field

I'm wondering what job title you use in your shop for what you do.
Here's what I do; I design/develop Access database applications for
other people to use from beginning to end. I do all phases from
meetings with end users, scope document, design, code, test with end

How can you update a Lookup List after it is created.  It is not tied
to any table.  I have tried adding the new data at the table level, but
when I go to the Form to input, it isn't on the list.  Any suggestions?

I am searching for code that makes it possible to connect a cash
register (operated with microsoft Access 2003 software) with a PIN/CHIP
payment divise.
Can some of you give me futher information where I could find that code,

I have a rather unusual problem.  Users sometimes run 2 or more copies of the
Access application on the same computer simultaniously.  This creates some
problems with duplication of records.  Is there any way to programatically keep
users from running more than one copy of the ...

I have a dumb question, but cannot find an answer:
I've got a string like
-"The day is Oct 2004 and it is nice outside"
-"Today is Nov 2003 and I am hungry"

Here's the code:
Private db As Database, rs As Recordset
Set rs = db.OpenRecordset("Table")
rs.AddNew

I am using Microsoft Access 2000 and Oracle 9.2.0.5 on Windows 2000.
When I export a table from Access to Oracle using ODBC
I get error:
ORA 972 identifier too long

I currently have a report that lists employees and the points they
have. This information is edited through a form.
Currently on the report I have...
EMPLOYEEID           NAME            POINTS

When you use an aggregate function in a SELECT statement, you cannot specify
any fields you want they way you usually can in a SELECT statement.  Only
fields that are part of the  GROUP BY clause can be retrieved.  How can I
create a join to select a record from a table using the ...

I cant open anything in access 2003 or 2002. It keeps shutting down and restarting. I reinstalled it twice with no luck. I even reinstalled the entire office program. When I open office then use the menu to open a data base. I get the error message "Unknown". Then access shuts ...

I'm trying to update the address record of an existing record in my mdb with
values from another existing record in the same table.  In pseudo code it
might look like this:
UPDATE tblAddress SET

I have an Access 2003 mdb with a Main Form that has a ListBox with a long
list of items.  The problem is the scroll bar on the ListBox does not scroll
all the way to the end unless you first scroll half way, then let up the
left mouse button, and then continue to scroll to the end ...

I am totally confused about the following:
1. Is it possible to change the size of an EXISTING TEXT table field
in Access 2k or later using DAO or ADO code?
2. If so, does anyone have some sample code?

There could be 50 vendors which we are going to send payments to, and
each vendor could have up to 100 records on the table for payment. I
need a method to enter a check# once then the system would put that #
on all the records for one vendor then add 1 to the check# and then