Hello all. I'm trying to change the color on individual rows of my database
in Access 2002. It will only let me change the background color of the entire
database not single rows or columns. Does anyone know how to change the
colors for individual rows?

I have one query consist with alot of table,
this query is very heavy in the matter of activating it.
is there any solution that the query will be lighter?

I have my comp set up to sleep after 30 min but it does not help!!!

how can i use in date function?
the field type is date :
Me.date = date <---- i get null
also in here:

If I have a Data Access Page generated (save as) by a report (in Access)
example: name & phone number
the page displays as a long list that needs to be scrolled. Is there a way to
display the list in multiple columns allowing more information to display on

I would like to send a report automatically via e-mail. I can do this if I
select one of the available formats (XLS, etc) but I would like to direct it
to a pseudo-printer to create a PDF file. I have found no way to have Access
identify a printer (other than the default printer).  ...

Hi.  I have several related database models which have many of the
same structures (tables/queries/reports).  I usually develop or change
some of those structures within one database and then copy them to the
other.  The problem is that when I copy and paste them, I can't select

I am working on a front end in AccessXP for a SQL2005 DB.  The main
purpose of the Access piece is to produce reports for sales, pricing
and inventory managment.  The reports we get from the software vendor
are ugly, hard to read, and I need the flexibility of writing my own

Hello,
I'm attempting to create a new record on a table using a form without using
the little new record button on the bottom of forms (I've disabled that
function for style reasons).  I would like to do this using VB if possible.

This may be a stupid question - but is it possible to link tables from an
Access 97 database to an Access 2003 database? The problem is currently we
have two databases that are linked together with a couple of tables. One of
the databases needs to be upgraded, but they do not ...

I need to import Excel spreadsheet data into an Access 2003 table.  Once in
Access, some of the data will be used to perform aggregate functions for
reports.
Several columns being imported from Excel contain mixed data (numeric-only

When a checkbox on my form is checked (yes/true), I would like the result in
the corresponding field to be an "X".  When it is not checked I would like
the result to simply remain blank.
I am working with a database in which the user simply typed the "X" in

I am trying to Link SQL 2005 tables with MS Access ODBC.  I setup an ODBC
System DSN to the SQL 2005 database.  The test says the connection is working.
When I use the link table feature, and select Files of type (ODBC
Databases()) the link form closes.  I get no error messages.

Please advise how best to do this using simplest syntax with the end
goal/result that shows: IF [MEMBER_TYPE] = S2x or S2TX or S2T or S2 AND
[WRITING_EXAMS] = 1, THEN "Yes", ELSE "No or Not applicable".  Even better,
if we can also include in the same IIF statement IF ...

I'm trying to do the following
Open a query that prompts the user for a date range.
Open a form to input a date range.
Export the query results to an Excel spreadsheet....