I'm trying to develop a small database to manage vacation requests, using MS
Access 2003 SP3.  
I created a subform for detail of vacation requests by the selected employee
which fall within the specified time period.  The user should be able to edit

Service Pack 3 has killed a combo box we use to search for users in a
database.  We started receiving complaints about Access Database's a few
weeks ago and I've discovered that if I remove all service packs from Office
2003 Professional, the combo box function works.  If I ...

I regularly have to fill in forms with inspection data.
On the form, there is a drop down box with the list of inspection locations,
there are then several more boxes that need data inputted, e.g. id numbers,
inspector's name, equipment type etc, that are always the same for each

What is wrong?
In a form I have a combo box - when a choice has been made the result should
be saved i the query (where it is defined). It works partly
The result from the form - 2155931

I've been trying to approach this problem several ways for some time
now and to no avail.
I am making a database that generates staff rotas. There is a button
you can click on the main rota form to bring up an "edit staff" form

I'm not that famaliar iwth creating expressions so if someone can please help
me with this problem I would greatly appreciate.
I have a form that has "Status" field.  When I change the status to
"Terminated" I would like for "today's date" to populate in that field and

I have a subform that will not be used with every record; it is a follow up
form. If a customer has an issue that needs followed up on, then the end user
will click the button, the subform will open, and they will enter the
appropriate information.

Need help with the following code:
ID = numerical
pdate = is the date field in my query.
=dlookup("[Earned Hr]"/("[tpaid]"-("[project]"+"[Station]"+"[Break]"),

Hi!!
I have a main form with a sub form , I have linked the [number] field
between the main form and the sub form through a control using SELECT
statement to select the values from a Linked Table , they work properly, the

I have a list box that I would like to have "filtered" using various command
buttons.  The list box by default shows all records.  When the command button
for "Checklists" is clicked, I'd like the list box to display only checklist
records.  Below is some information on what I ...

when i change by code the controlsource of a textbox while opening the
report, access crashes.
is there a way to solve this (besides opening first in lay-out view)?
michel

I have a number of Yes/No chech=k boxes on a form.  The problem is that when
the user moves to these fields, the cursor is not obvious.  Is there any way
that the Properties of this field can be changed so that the cursor appears
to the right of these boxes and very clear?

Hey.  I have a data entry form that has a subform based on a query.  The
subforms query is based on a table that holds the cpsi (cost per sq. inch) of
our steel plate stock.  What its supposed to do is, when you pick a size of
plate to enter, it tags the entry with its cost per ...

My problem is how to convert a text to proper case for example  mARK anders
==> Mark Anders. It works with following function, but the field cannot be
edit:
Function Aa(strToChange As String) As String

Hi,  
I’m working on a continuous forms subform that has a simple query as the
record source.  Originally the query sorted the records for the form.  I want
to change the form so that users can click buttons over fields and change the