I've setup a query that compares the difference (in years) between two
date fields (Joining Date & Date Cancelled) and then totals how many
people fit into each category (0 years, 1 year, 2 years etc.).
The query is setup so that it only counts records that have both a

I have a report with an accumulating value control. I use the Detail_Format
event to periodically change the backcolor of the control. The control
(Me.Tot) prints green except for the records where it reaches a multiple of
300. In the Open event I set the variable Milestone to an ...

I have an Access 2003 data file that has now corrupted twice in a
week.  The database is extremely simple with one main data table and a
few lookup tables.  The lookup tables are linked to the main table via
relationships. Each user has their own copy of the frontend which

I have an Access application on a terminal server. Sometimes my users
need to export reports to pdf, rtf or xls files and save them to their
own client device hard drives.
They can do that right now the way I have this set up, but it's

Is there any way at all in Access 2003 to bind a report to an ADO recordset?
The closest I've come so far is to use a pass through query that gets a
table based UDF- but that's still not optimal since it's a pain to use
paramaters.

I am trying to fix the following VBA code from an MS Access database I
inherited.
I conclude with an example of one of the symptoms resulting from this
VBA code:

I have a number of Access 2000 format databases on a Windows 2003
server.  For some reason I can no longer compact these databases
directly on the server using Access 2003.  Access 2000 seems to
compact them just fine however.  If I copy the database to my local

I have a client who that was using an mdb file, and they appear to
have accidentally attempted to compact/repair or convert it, and then
tried to stop this activity in mid-process.  Oy vey.
If I attempt to open the file, I get an error message saying the

I have a DB that I developed on access XP (2002) and deployed over a
year ago.  No one has had problems printing any of the reports within
the DB until we started loading 2007 on new computers.  The access
2007 users cannot print one of the reports.  This is maddening since I

I have a form in which there is  combobox  which has empnames listed
and a textbox which has empIDs. textbox value is loaded from the
table, i have written a query which sets the criteria for combo box to
select the name that its ID is written in textbox. It does the filter

I'm using the following code to send email addresses from a query to
Outlook:
Dim db As Database, rs As Recordset, sql As String, emailTo As String
Set db = CurrentDb()

Dear reader,
By opening an application I get always the main Access window with the
closing cross [x] in the above right corner. Is there a possibility to make
this closing cross invisible?

I have a table with two columns, labeled Year and Loss. In the Year
field, I have the numbers 1 to 10,000, each which can or cannot
repeat. In the Loss column, i have numbers corresponding to the
Years...for example:

I'm trying to send an email from an Access procedure using CDO. I've
been able to do it successfully with three different sending email
addresses, but not with the email address I actually need to use in
production. In that case I get a message saying "The transport failed

I use access front end with tables link to sql server 2005.  I got error on
update as follow:
"Error 3622 - You must use dbSeeChanges option with OpenRecordset when
accessing a SQL server table that has Identity Column"