I have a field that the user enters in a 4 digit code.  What I am trying to
accomplish is... when the user enters in the 4th character I want the focus
to move to the next field.  The problem I am having is, how do i count the
number of key strokes in a given field and keep track ...

Hi again,
I have Access 2002. The main form of my mdb file is set Popup = Yes.
I have it so the Access Window is not showing when the form is open.
When I minimize my form I then see the Access window and have to minimize it

I have seen before where someone has created a userform used for searching.
The results of the seach are displayed in a listbox. By double clicking on
the the required record in the listbox all data for that record is passed
back to a main form.

Here is what a I want to happen.   When a teacher counts a student tardy in
their class for the second time, I want a message box to appear telling the
teacher to assign the student a 1 hour D-Hall.  For the third offense, a 2
hour D-hall, fourth offense and every one after that, ...

I have a field that can not be set as required at the table level so I have
code at the form level to decide if the field is required, and then force
entry of the required data.
I have placed this code in Form_BeforeUpdate. It works as intended if I use

Currently my Access DB has a form whose 'Record Source' property is set to a
query.  The query is pretty simply in that selects all fields and all
records from a table with personnel data then orders them by last name then
first name.  The SQL view of the query is:

Is there a way to suppress the import dialog box from showing, I used our
company logo as a picture on many forms. I almost reqret doing this but it
adds a little umph to the presentation of my app. There are about 15 forms
that have the logo on it, then there are 10 other forms ...

I have a multiple fields in one control as per example below, on an Access
2000 form, is it possible to format just one of the fields in bold, if so how?
=[Suburb] & " " & [Zip_Code] & "."
Many Thanks Sean

I have a parameterized query (qrySAR_Status_by_IR) that I am passing a string
to through a form:
SELECT tblSAR.SAR_ID, tblSAR.SAR_Multipurpose
FROM tblSAR

I have a combo box on a form to display a list of drivers from the employees
table.  Since one person is the primary driver of each truck, I would like it
to default to the driver whom this truck is assigned to(tblEmployees,Truck)
however be able to choose a different driver if ...

The second line of this code isn't working...
I need Text136 and Text140 to add and then multiply by STax...
I'm only getting Text136*Stax
Any help appreciated.

For a parameterized INSERT Query, aka
With cmdCommand.Parameters
    .Append (cmdCommand.CreateParameter("@ClientName", adChar, adParamOutput,
50, Me.ClientName.Value))

Is it possible to have the Back Style of a control dependant on content/no
content in a text field on the same form? I have an Image control called
imgTheImage and a text field txtImagePathAndFile. If the text field has
content, I want the Back Style of imgTheImage to be "Normal", ...

I have a form with a button for add new record that works fine. I added a
second button to save the current record.
I need two things:
1- after user fills all the fields in the form I do not want to move to the

I am using Access 2002.  In my form I have a received date text box and a
reassigned date text box and a completed date text box.  What I don't want
is to have the user input a completed date that is actual before the
received or reassigned date text box.  For example - Let's say ...