I have 3 images stored which are to imitate a button. One for Normal,
one for Depressed and another for Highlighted.
The 'Normal' button is placed on the form.
The Mousedown event changes the button to 'Depressed'

I am writing a query that uses a switch statement.  Here's my
statement:
Region: Switch([STATE_CODE]="PA" Or
[STATE_CODE]="DE","PennDel",[STATE_CODE]="NY" Or

Ok, i have formatted a time date field to short time, but i only want access
to display the hours part, e.g. 2 or 3 hours. As i cant format access fields
into an hour format, i want to create an input mask, or some validation to
only allow the user to enter the 1, 2, or 3 hours

I've been Googling and reading for 5 days now trying to figure out how
to write a query that selects records with dates in the current week
(Sun to Sat).  You'd think it would be remarkably simple (maybe it is),
but I can't find a simple answer.

I have a client who has just migrated from Access 97 to Access XP.  He
uses make-table queries to sort tables by two fields (text & double)
before exporting the records for another application.
In Access XP (SP2) the make-table sort works correctly on the first

I've created a subform that displays the results of a query. The
results of the query contain a unique ID named "Invoice_ID". I want to
be able to double click on a specific row in the subform to run a macro
which opens a new form and automatically "jumps" to the selected record

I am using Access 2002.
I have a client transactions table with a field for HoursBilled,
BillingRate, and AmountBilled.
Amount Billed is a caluclation of HoursBilled * BillingRate.  I can get

In a form, when I modify some data and move to the next record, I want
be able to trap an event and do a query to check on the change done to
the table. Currently, I use the form After Update event, but when I do
a query, the table is not updated yet. Is there another event that

The  SQL below worked in  Access 95 (V 7) is not working in the current
version (V 2003).
What is supposed to happen:
1) From my form I hit a button that calls an input box.

I am new to the advanced level of access, and I have quite a few
changes to make to an existing database.
The current database's main form needs to have additional check boxes
added to it which in turn are meant to be linked to relevant tables and

I need some help sending records to a variable from a button click on
my form.
I have 3 tables involved.
I need to pull out the first HEADER, then pull out that headers

I am not sure you can do what I want to do but here goes,  I have a
client database, I have a field for company, first name and last name.
What I would like is a combo box I could start type in say A and the
box would return the company values and the last name values that start

Hi - I created a linked table via ODBC to a SQL Server database.  The
table in SQL Server contained over 12,000,000 records.  Later, I
started a "Delete" query.  When I realized that I was deleting from the
SQL Server, I panicked and tried to stop the query.  Esc didn't work,

I am not sure which would be the best place to post this question, so I'm
posing it here with Access general questions.  I have reached the point many
times in Word and in Access where my ignorance of VBA is a real detriment to
me.  I saw some posts about VBA classes with a ...

I am not familiar with programming languages.  I use Access because it
is simple to construct queries.  PROBLEM:  In a database used to
calculate employee payslips everything went smoothly on both the
current data and the accumulated total until an employee was given a