I created a field called cash in a MS Access form, I want the totals
for these  fields 100 50 20 10 5 to be placed in that cash field. In
the control source for the cash field I am using
=Sum([100]+[50]+[20]+[10]+[5]) and thought that would work but it

I cannot do anything with the form i created. I cannot add, delete, or
modify a record. Is there something i missed here?

I have a date field (for birthdays) on my form but don't know the year of
birth for many of the people I'd like to remember on their birthdays. For
them, I put in the year 1900. But for SOME of my contacts, I'd like to know
their age (i.e. for "special" birthdays, like sweet 16 ...

The form opens with the first record.  You can then scroll through the
records or add a new record.  However if you change any data the record locks.
You can not go to next record and your change is not saved when you close the
form.  There is no error message.  What's going on?

(A'03) I would like to know if it is possible to change the size of the
vertical scrollbar in a list box. This is for a touch-screen application, and
‘fat fingers’ have a hard time hitting the stock narrow scrollbar. I tried
creating large command buttons to the side of the list ...

I have a form that exceeds a single printed page.  When it is printed extra
pages are produced.  The extra pages occur after the first printed page but
before the rest of the page of the form is printed and another extra page
after the rest of the page is printed.  The extra ...

I am having some problems with a check box.  I've added a field named "Floor"
, which is a yes/no field. tWhen I create the ehckbox I realize I must bind
it to a control source, which I do to the field named Orders!Floor.  However,
when I click the checkbox on the form, I get the ...

I have a main form set up with two cascading combo boxes in the header
section of the form;  cboBaseComm and cbo SecComm.  cboSecComm filters
dependent on cboBaseComm. (this filter works fine)
In the details section of the form I have a subform that gives vendor

I'm working on porting an Access DB to SQL. I'm trying to decide whether to
keep my original front end mdb/mde and accessing SQL via ODBC linked tables
or use an ADP.
Anybody has any pro/cons?

In my forms or tables, I can use the format property to make the data
displayed be uppercase, but it is not actually stored that way -- it is
stored how it is entered (either upper or lowercase).  How do I force the
data to be stored as uppercase?

Hi I am new to Access and I have this problem that occurs when the user
either presses the last tab key or when you turn the scroll wheel on the
mouse.  In each case this action causes the form to go blank.
What I want is for this not to happen..

In Access 2003 forms, when entering data, how can you stop the form from
scrolling to a new blank record? I've tried saying no to Add Additions, but
if I create a new record, the form will be blank.  I can't find anything
under properties to prevent the scrolling.  We're finding ...

I have some Row Source Data that worked OK under Office 200 but now we have
transferred to Office 2003 doesn't.
The data is "SELECT data_stans_combined.Para, data_stans_combined.Title FROM
data_stans_combined WHERE

I would like to change the color of the strike through line for tracking
changes.  Red to Orange.

I run a database to record assessment results and would like to put a
photograph into each candidates record (form) as an aide memoire for the
reports I have to write