Can anyone help me; I need to do a calculation to add a constraint to the D.O.
B field so no one under the age of 14 years will be expected in to the
database field of D.O.B

I want to have greater control in postioning control objects on Access forms
in design mode.  I seem to remember being able to do this in other Office
applications using the Alt + arrow keys?  Is there a similar keyboard action
in Access in desgin of forms and reports?

I need some help, can anyone tell me how to do a calculation in access to
show  person must be 14 years and over

In access report it is possible to insert an unbound textbox and set it's
control source to (=1) and it's running sum property should be set to over
all. then in print  we see that access for every record shows the rcord
number.  (a counter i mean).

I have a custom DB application that a user has been using for some time now.
We just added an assistant and now more than one user are using the DB. On
one form and from what i can tell only that form the users are getting "The
save action was cancelled" when the form is opened ...

I'm having trouble with a calendar linked to a form.  I have a main form with
three calendar buttons.  When clicked a small form with a calendar and a
close button comes up.  The main form is NOT closed when the calendar form
opens.  I select the date using the calendar and click ...

How do I get rid of MSAccess Title in Warning boxes. When a form fails to
open (No Data for example) How do I stop the MsgBox Identifying the
Application as ACCESS by showing a MsgBox "Open Form was Cancelled" that has
ACCESS as it's Title.

I have a minor improvement I would like to make to a database I'm
constructing.
I have a recruitment database that holds candidate information and interview
information in two seperate tables, in a one to many relationship so that one

I am learning how to create custom error messages.
I know about the "OnError" event of the form, and knows how to replace the
standard error message.
I wish that Access will produce an error message saying something like "You

I have a form with a field for the user to choose his/her name from a combo
box. What I'm trying to get to is that once the form has been entered and
saved I would like that one field to be locked so the field cannot be
changed. Any help would be appreciated.

I have another question
I have a from which uses a command button to load a report based upon the
catergery selected in a combo box.  i want to add two things
1)  If no catergory is selected it loads the report showing all catergorys

Hi,
I am working on a cost table that has two fields categoryID and
categoryDetailID. Both fields are linked to a separate look up table.
The selection of CategoryDetailID depends on which categoryID is first

I have a form which crashes MS Access 2003 whenever I open it in form view.
I can open the form in design view, then click form view and it works fine.
Any ideas?
Thanks,

On my form i have a command button that opens another form based upon the
client selected.  Which work fines.
My problem occurs when i close form (command button to close) the first form
has resized it self to a small window.

I have a lookup table that consists of an ID, a description and Update
indicator fields.  I am creating a form (continuous form view) that displays
all three fields.  I want to set the form to display all records in the
table, but I only want to be able to edit records where the ...