please excuse the cross posting (in Forms Coding) but I'm not finding the
results I need for my problem.
My form is based on a query of just 1 table and has 3 controls; a combo box
with 1 bound column, an unbound text box for a number, and an "update"

I am trying to run a simple append query, but the query takes a long
time and I get an error message:
Not enough room on temporary disk.
I have tried to increase the maxfilelocks in the regedit.  I'm am

I have a table that has fields T1 to T10 corresponting to fields DEC1 to
DEC10 and I would like to search the fields in DEC1 to DEC10 , based on a
criteria and select the corresponding T1 to T10 and report the results.  For
example; if I am looking for a case sensitive value (say ...

Suddenly, messages I try to flag for follow up disappear. Where do they go?
And how can I make this follow up function again?

I have a query with inner join of two tables that contains the PKs of both
tables and should be updateable. I need to be able to update a memo field in
the query and cannot figure out why it's non-updateable.
Here is my SQL statement:

I'm trying to write a query that will calculate two different things:  1)  
Amount of time an order is on hold.  2)  Amount of time an order was in
process during weekends and holidays.
The first one is tricky because order statuses are stored in a separate log

Table1 contain car journal with nb of km on Counter after each journey
To calculate the distance of one trip I would like to have the Counter
status from the previous one.
Here is what I did:

Background of project:
I have a table with SS#, Student Name, and other related information.
This is a consolidated list from a total of 10 lists during a week of
registration.

Working with APD files I faced a problem. In one of the old MDB
files I created the following field in a query:
HelpFieldA: IIF([FieldA]>1,[FieldA],[FieldB])
How do I make the equivalent in a ADP query?

Hi, Please Help...
I am wanting to build a query that will show the Top 100 parts ordered.
My query has a list of all the products, qty, EngineerID and Contract he is
on, with Product Group

When I append a text field from a staging (temp) table to the master table,
some, but not all, of the data is truncated by 1 character.
The field definition is identical in both tables:
 Data type = Text

I'm making a database for my college's radio station.  They want each
DJ to have his/her own little table to keep track of which songs are
played on each show.
The problem is that I need to combine all these tables to be able to

Sometimes right sometimes wrong:
When I use the results from a field in a query as the creteria for a field
in a different query, I sometimes get a prompt (when I activate the query)
for a paramater criteria. I understand the bracket issues for a paramater

I have a database of customers that I call and want to add a "Never Call
Again" field for customers that no longer need to be contacted.  I would
rather use a text field instead of a yes/no, but am having a problem with my
query.

I have a set of data where I am trying to find the max price listed
from each vendor for each item (part number) then find the location
where this max price occurs.  I have grouped the on the vendor name,
part number and listed the max price.   The data also has a site name