I have created a form and would like the users to be "warned" when they
choose a certain field that tey are choosing that particular field.

I have a form that has a child and grandchild subforms.
Form= Customer
Subform=Company
Sub-Subform=Products

How do i set to cycle through records with mouse scroll in access 2007

I have a form with 2 subforms.  Sometimes when the form opens, the subforms
are not displayed.  This does not always happen and it is random.  I have
tried refresh, repaint, requery to no avail.  Sometimes the user can click on
the area where the subform should be and the form ...

I have a form that suddenly no longer shows any controls.  I have been
through Allen Browne's article about this, and the discussion groups - none
of the conditions that usually cause this are in place:
the data source for the form is a table, not a query.  The table is

I am a complete novice with Access and have been trying to muddle through
creating a database. So far, I have been much more successful than what I
thought.
I have a form with 2 sub-forms. The first form allows the user to view

Is it possible to change the colour of all the fields in a single record in a
continuous form?

I have an application (MDB1) which sources data from another Access DB
(MDB2) and I was wondering if it is possible to execute a 'Make-Table' query
located in MDB2 through VBA code in MDB1?
Kind regards

I NEED TO CREATE A BUTTON ON THE BOTTOM OF A FORM CANCELLED, MCAD, COMPLETED
THAT WHEN CLICKED SHOULD OPEN AN FORM TO ENTER DATA
tHANKS

I have what should be a simple problem to solve. So far I have only been
annoyed not being able to solve it.
I have a numeric field on a form. I don't want a popup message if a value is
not valid (null or alphanumeric). Rather I just want a zero to be entered.

Hopefully I can explain this in enough detail to make sense!
I am creating a contact database and am just starting to create the
main form. On the main form it shows a particular contacts details (eg
name, phone, email etc), then I have a number of subforms which

I have a table that contains some data, including a EmpDate field.  I
have a query that will bring up the last 90 days worth of data, based
on that date field.
What I need is to be able to bring up that 90 day history, click on a

i have created two pages in a form using the corresponding button from the
toolbox. i have created an option group and combo boxes in the first page.
Suddenly i realized that the combo boxes appear in the same position in the
second page too. if i delete them from the second page ...

Bear with me, I am very new to access...
I have a contributor table and a donations table. I also have a form for each.
On the contributors form I have displayed a child form generated from the
donation table which shows the donations that contributor has made.  I would

Is there a way to cancel a change in an option group? The option group still
changes to the option clicked on when clicking on the NO button with the
following code in the BeforeUpdate event of the option group.
If MsgBox("Change?", vbYesNo) = vbNo Then