On a form, we are trying to sum two fields, which are invoice amounts, and
have that sum display in the next field, on that same form. We have tried
building an expression that sums the two fields using several different
interations, but nothing shows up in the box. A couple of ...

I have been given the task of making this Access db read-only for some users.
Some custom menubar options are used for editing and I need to turn them off
or on depending on the user.
This is an old Access 97 system so the menubars are all macros.

I have 2 fields - policy number and policy type.  I would like the user to
enter the policy number and then have the policy type automatically be set to
the first 3 characters of the policy number field.  Is this possible?  
Doesn't matter where it has to be done, but I would like ...

I'm trying to format the color of text.  If sent =false then its black,
if it =true then its red.....this doesn't seem to be working....
Format(IIf([Sent]=True,"vbRed","vbBlack"(IIf([ItemType]=1,[ItemName],"
 " & [ItemName]))))

I have two Access apps.  They need to be linked (via Linked Table Manager)
and I must password protect both (company policy).  The problem is, when I
put a password on them, I can't link them - even if I use the same password,
I get a message "Not a valid password."

I have created a database for work.  So, i of course have had to create a
user manual (Microsoft Word) to go with it.  I was wondering if i could use a
command button on my main form that will open up this word file.  
Thanks for the help

I been working with access for some time now.  I'm no expert but it helps me
a lot to organize data, relate tables, produce queries and produce quick
preset reports. Usually I extract the data and analyze it in Excel.  
I know but I am having problems understanding the forms.

On my form, there are 2 fields - one named Process and the other named
ShipReady. The Process field is a combo box with 8 different choices.
What I would like to do is create something that if a user chooses "P",
"I", or "X" from the combo box, then the ShipReady field will

I have a form with 3 text boxes Value, MinValue and MaxValue parameters, .
When change the value in text box Value, change image according this value
(If < MinValue, between MinValue and MaxValue or > MaxValue).
Work fine trough code in On Current (Form) and After Update (Text box

I'm trying to develop a form that will be automatically populated if a
certain field in another form is 'Yes'.  Therefore I built a query that pulls
this information and then I built a form from this query.  However, now I
need to be able to add additional information to this form ...

In using an option group, is there a way to set the option value at 1.5, 2.5,
etc.?

I'm having a problem with the following equation and I don't understand it.
In Details from a query I have Claims (text1), Sales (text2) and =Claims /
Sales (text3).
The latter real numbers are: 32991 / 91362 which return 0, 36. However, the

Folks,
I have a table which has 4 columns.
ID (Primary Key)    Machine Name    Machine subsection      Room
1                                MPP1                    St12 - PnP

For my daily line up I have been entering one employee at a time in the
"login" tbl.  I was curious if I could create a form that would allow me to
activate 7 employees and one command button to generate the time for all 7.  
Example have a form with seven entery slots and one ...

I created a form with a subform for tracking student's time spent in various
activities.  the subform is tied to a table with an auto number for events,
because one student often does more than one activity each day, so date is
not a good primary key.  The question is now how can ...