I am using Access 2003 to build a database that stores information for every
intubation performed on patients.  I use a subform in a main form to capture
the information for each intubation that is performed.  For example, on the
main form I have patient A's demographics.  I then ...

Would like a field in a form to turn yellow when another field in the same
record has focus but I have problems with the expression, is it possible?
Thanks
Quinto

I have a form with a subform and the subform has no scroll bars, record
selector, or navigation buttons. There are essentially two columns of fields,
the left column is on the main form, the right column is on the subform.
The problem is, if I have the subform where I want it, so ...

I have two combo boxes on a form.  One of them allows a user to choose a
category and the other filters the choices available based on the chosen
category.  There is a requery event in the afterupdate property of the
category field.  That part works fine.  The form needs to be ...

I downloaded a trial version of Access 2007 and it's causing me a lot of
grief.
If I open an application created with Access 2000 - with Access 2007 it
opens and runs fine.  Forms load and all controls work as intended.

I have a main form with 2 linked subforms, much the same as the customer
order form in the Northwind database.
The main form contains details of a site. The subforms relate to houses on
the site and the funding of them.

I am trying to insert Null value in column(ShipDate) in my table.That
column(ShipDate)'s type id date/time and format is short date.
I am using   ""   to insert Null in that column(ShipDate) but it shows
warning that

I would like to prevent users from opening a specific form in design view.
This includes preventing the form from opening when the user clicks on the
Design button in the Forms tab of the database window.
Thanks for any ideas.

In setting up a database for work I have found the need to link forms done in
excel that need to be completed for each record in the database.  I'd like to
be able to do that from the main data input form by adding the worksheet as
an object that opens excel and the appropriate ...

I have a form set up which is 1/2 page.
I would like to print 2 records per page.
Can this be done.
I won't always have to print the entire table as I will be adding records

I want to update data in table using form. I have 1 combo box on my form,
where I choose one number from 1 column in table, and then, all other fields
on my form have been filled in. And now, I want to change some information
about that number.

I have a form with a subform, and if you tab through the subform's fields,
after the last field, it tabs back to the first field on a new record. But
instead of this, I want it to send the focus to a different control (on the
main form) when you tab out of that field.

I have a form that shows a small picture of an object. When I
link to the image I check the 'link' box, thinking that it will do just
that. However my database file is growing rapidly and I have discovered that
the images are obviously embedded in the mdb file because they are still

Is there a way to have an event procedure run when you change records?
Thanks,
Ray

I know how to set up a form and a subform. Why I don't know is how to
set them up for data entry.
I have a form with subform, but the subform displays completely blank
because it doesn't have a record to display.