I use Access databases at work and sometimes the cursor gets lost in the
middle of the screen, so to speak.  I have been scratching my head and
looking and looking to see if there is any way to change (for instance) the
background colour when the cursor enters a field so the ...

I am running Access 2003.
I have linked images to display on a form. The image path is stored in
tblPersons.Photo. The form has a text box "txt.Photo" which displays
the contents of tblPersons.Photo and cmdAdd and cmdDelete buttons to

I have a Multiuser data entry mdb (built in Access 2003) split between FE and
BE.  Both FE and BE reside on network directory.  Each user has read/write
access to the network drive.  I have a start up form with the datasource
being a table linked to the BE.  My Start up options ...

I'm trying to set a conditional format on a field that will become disabled
based on the value of another field (which is a drop-down combo box). I'm
choosing the "Expression Is" in the condition set up box and have tried the
following expressions:

Quick Overview
Header Page
-------------
Detail

I have a form which I set to allow additions (No edits, No Deletes).  The
form only has 1 control - cotinuous form.  On the form I have the control's
x2 click property calling Allen Browne's popup calendar.  My problem is that
although the user cannot manually make changes to the ...

Good morning.    I'm trying to figure out how to write a formula for a
calculated text field called Cost:
If Hrs is blank, allow a manual entry, otherwise if Date Initiated is <
#4/1/2007#, then Hrs*94.45/1000 else Hrs*99.55/1000

I have two tables:
tbl:Field_Mass1
StationID (fk)
SampleID (pk)

Hello, I have a database with a recordset having a primary key. I want to add
a feature that allows the user to select the recrod ID from either a combo
box or by entering the number in a text box. I know this is possible but I
can't remember how. Please help!  Thanks

I have a database where I have a main form that has customer data, a subform
that carries tracking data for escalated calls and a nested form that
contains notes for the escalated calls.  When I go to input a new record, I
am unable to add any notes or change a check box from the ...

I need to verify what is being passed to a query from a form.  This action is
activated via a macro.  How can the macro be stepped through and then how do
I verify what has been passed to the query.

I've a continous form which shows a list of all records (to be precise, it
shows the results of a search query). In this list, a brief summary of each
record is shown. To view details of each record, I have put a button "view
details..." on the right side of each record which ...

I have a form with a continuous subform. The form is based on a products table.
The subform is based on a table listing who is paying for the products. A
third table lists how much each person is paying towards the product. There
is a DLookUp function on a field in the subform, ...

Dear users,
I am stuck with a very simple problem but I really don't know how to solve it,
I have the bound Control Box which showing the Grand Total of the amount in
an invoice, and the format for this control is "Currency"

I would like to prevent a record from being updated by a user at the same
time.  How can I enter code to prevent the same record in a form from being
updated by another user at the same time? The record can be opened multiply
times by different users but cannot be updated ...