I am trying to construct a query that sums sales by salespersons and
only returns a list of salespersons that have a sum of sales lower than
the previous month for whatever date rane is selected.
For example, if the user selects a date range of Sept.1 ,2004 thru Dec.

I am trying to construct a query that sums sales by salespersons and
only returns a list of salespersons that have a sum of sales lower than
the previous month for whatever date rane is selected.
For example, if the user selects a date range of Sept.1 ,2004 thru Dec.

I read the KB article to create a stopwatch in Access 97
(http://support.microsoft.com/default.aspx?scid=kb;en-us;142871), but
I'd like to do something a little different.
Instead of measuring time interval between command button clicks, I'd

I'd like to know how to run AVI video files with sound in Access 2003.
Microsoft's Animation ActiveX control doesn't play sound, so I tested
Dev Ashish's fPlayStuff routine. This is failing with error code 263 -
"The specified device is not open or is not recognized by MCI".

I have a database set-up with a form and two subforms in it. I have one
of the subforms (replacement parts) set-up where you can pick part
numbers from a drop down box and also pick a description of the part
from a drop down box. These are two separate fields. I want to be able

Can you tell me how to produce a query that when Login Date (entry) is
Sunday. First, check if the Sunday Date occur on 7th day of his duty.
Example 1:
Login Date    no. of wk days    Remark

I have some dates which show in a continuous form, multiple rows at a
time.  I would like to color the background yellow, or the text yellow
or some color other than black that would stand out, based on the date
value.  Suggestions?

SORRY I know we shouldn't do this but I'm desperate for an answer to this
and the previous post didn't seem to get a response.
I have a table with two fields, txtvalue (a number field) and txtmonth ( a
date/time field). I want to create a report that shows the difference in

This is an extension of a previous post which has been answered for me,
thanks to those who replied. But this is another request from my users.Is it
possible to have a subform that has a tabcontrol and then have another
tabcontrol on the first tab of the tab control? I've tried ...

I have a report/invoice that lists volume, price per unit, and extended
price.
My problem is being able to get the extended price by multiplying the
[volume] x [price per unit].  With just 2 decimal places on both volume and

I am having a problem with getting a recordset to fill with data in an
Access Data Project from a SQL Server database.
Here is the code example that is in the Access help files that I can
get to work just fine:

Why I am not be able to define following objects:
Dim wrkDefault As Workspace
   Dim dbsNew As database
   Dim prpLoop As Property

I have a form with a number of tab controls.  The tab controls are part of 3
sub forms that are based on different tables.Is it possible to stack the
tabcontrols as say 3 rows of 5 rather than 1 row of 15. With 1 row of 15 the
form is either too long for the form or all the tabs are ...

I have three databases.  DB1 has a button on a form.  When I click that
button, I want to import all the objects from DB2 to DB3 (just as you
would if you would chose the File > Get External Data > Import menu
option).  Then I want to Compact and Repair DB3.  I want to do this all

I found a simple piece of code in the past which allowed me to send
email from msaccess through vba code.  I cannot find it again on the
web.  I have found very long code on the web purported to do this but
it does not work for me.  I believe I may have been using