I have several fields in a query I'm totalling.  The sum function doesn't
work unless all fields are populated with something.  Is there a way around
this?

I have a database for patient details with one table [colp_patients].  It has
a unique ID field, and an NHSNo field (which is a text field - it needs
spaces), which is also unique to the patient.  I was led to believe the same
patient could be entered many times, but have since ...

I have three tables Named Stock,Invoice & Approval Book. But I need only 2
forms to be print out i.e. Invoice and Approval Book. I need to put data from
table stock (by just clicking/double clicking)  and data should be exported
to invoice or approvel book?

I have two groups 1-Admins 2-Users.  I want the users in the USERS group to
beable to enter data into a form.  However once the form is saved I DO NOT
want any member of the USERS group to beable to change the data in he form.  
Please is this possible and if how?

When my A2000 developed application is opened in A2007, an extra bar appears
directly below the title bar.
How can this A2007 bar be removed from the A2000 application ?
See example at:

Hi. Can someone help me please.
I'm new in Access
I copied the Quarterly Orders By Products query from the Adamastor example.
Now, I want to see this data by Month. So, what i did was to substitute the

I am using ajbFindAsYouType with a tabular table and it works great!
Thanks Allen!
I have built a table with only the fields I want to search/filter on.
I'd like to use it as "menu."

In my form I input a value and AfterUpdate checks the value and looks
that the value is wrong. How can I cancel this input automatically,
because my table does not accept null-value into that field, what I am
trying to input?

I'm doing asset register but some of our assets are depreciated by 10%
reducing balace. I cannot find anyway of using a 'x to the power of y'
formula where I would have [value] * [rate] to the power of [age of asset].
Can anyone help? or have I just confused the problem?

I want to validate data entry in one control based on another. I looked at
some of the other threads in the discussion group but still not understanding.
It's an inventory database. In one control, I choose from a Combo box called
[Combo18] whether the record is a 'Sale' or a ...

Hi. I with a blank.
I have a form and inside I have a subform.
I want to type a value in a text field on the form and then I want that the
filed of subform gets the same value that was typed in the filed of textbox.

I have a button in a database form to email the text in .rtf format but it
always gives the database engine error only on the one computer.  I am
totally stumped. Here is the code from the button :
stDocName = "Print Tool  Damage Sections 1-2"

All,
I am currently creating a form that contains a combo box that when clicked
will allow the user to select a training program. The Training Programs table
has and ID, ProgramTitle, and ProgramDate. The user knows the training

I wonder if anyone can help?
I need to add a control to my form to display some data that my users will
be able to copy and paste directly into a web-based application.
I don't want to use a textbox as that would mean the data could be deleted....

we need a business plan made up. how do we go about this?