I have a large table with a field (Mon_SO) with values of 0 or 1. There is a
row for each week number. What I would like is to sum the Mon_SO field for
the previous 3 weeks only - something like:
CSO: DSum("[MonSO] ","Table1"," [Table1]![Week] <="& ([Queries]![Query2]!

We have a large corporate project that is an ADP hooked up to SQL. Many
Programmers work on it so it is under sourcesafe control through the IDE.
This has been working fine for many years. We have just come across a new
problem we cannot resolve.

Hi all out there, does anyone know of any controls which could be used to
show the multiple results from a search? it would be best if i could know of
a way to show all the entities of a search result which it is tied to.

I have been using this query as a recordsource for a form in development for
several months:
SELECT tblDMSData.*, tblFilteredDMSIDs.[Select], [Week Ending].[Week-end Date]
FROM [Week Ending] RIGHT JOIN (tblFilteredDMSIDs INNER JOIN tblDMSData ON

We have MAC users and PC users that will be using our custom Access .mdb (or
mde) file.  Right now I use a little program called Setup Factory (freebe) to
deploy to PC users.  Is there a better one to use for this?
Any advice as to what to use for the MAC users?  The Access file ...

I need to make a list of dates from the following:
Field                  Example
RptStartDate        1/13/06
RptQty                   10

My forms are taking forever to open in my database.  It is taking 30 – 40
seconds to open a form from the database switchboard.  I found a previous
posting suggesting establishing a persistent connection to the back-end from
each of the front-end workstations to speed performance ...

I'm just starting out in Access and want to change all records in a field
from "Yes" to "No" using vb and not use an append query.  Then I can use a
button on my form to print the report based on the query and before returning
to the form reset the field.

I'm trying  to migrate a Access aplication from V97 to 2002 .
In 97 when I wanted to reference the Database I used:
dim db as Database
set db= dbengine.workspaces(0).Databases(0)

Is it possible in an Append Query, to change the table that is being
Appended, using VBA?  Can someone give me a quick idea of how to program that
snippet of code?  Thanks!

I would like to disable a command button once it has been clicked,
via code attached to that button. Is this possible?
Any help with this is appreciated.  Thanks.

I need to create a report on data found in an excel spreadsheet but I
need to use a query in order to do so.  I was wondering if that was
even possible and if so then how would I go about doing it?  Any help
would be appreciated.

Access 2000:
Is the conditional formating for a control a property or something that I
can duplicate for several controls?
Thanks.

I have a listview in ms access 2003.
I need to be able to order the columns when I select it, but I get an error
message. This is the code I am using:
Private Sub ListView1_ColumnClick(ByVal ColumnHeader As

Can someone please help me find (or provide) an example of using VBA in a
module to create a Select Query. I tried searching for this in on-line help
and Microsoft.Com. Right now I can put new sql text into an existing query
(myq.SQL = sqltext), but need to 1) create the query; ...