I would like to total the number of records that meet certain criteria in a
form.  The field name is "October".  1,2,3, or 4 can be entered into the
field.  The name of the query that is used in the form is "Student
Attendance Query".  I would like to total the number of records ...

I have createed a  form with a sub form. I populate this subform with data
with the code below.
When I cursor into a cell in the tabular datasheet I can't edit the cell in
any way.

How do you transfer a Textbox value from Form1 to Form2 and then have code
run on that value that you have transferred?

I have a form that displays basic info from a DB. On that form I have a
subform that I want to display related data from another table. The catch
is this: the data will not be related 1 to 1 by a key. The purpose of this
form is to locate keys in subform B that are CLOSE to keys in ...

I have a form in an ADP with a combobox that I created with the 3rd option in
the wizard. I put the combobox in the form header and have the detail section
invisible until an item is chosen in the combobox. The problem I'm having is
that the detail section always shows the first ...

... when passed via tab key or even the last letter changed ...
I wanted to change whatever string the user may type into a control to a
capital first letter
I put the call to a module func into both the AfterUpdate and the LostFocus

My database tracks employee training.
I have tblClasses, tblEmployees, and tblRegistrations. I have a registration
form with EmpName and subformClasses, which allows me to register one
employee for several classes at a time.

Hi! I've been looking at other questions posted here and have tried to
replicate one of the solutions proposed with no success.
I have a form and an (unlinked) subform. When users select a value from the
combo I want to set the Record Source for the subform to an SQL string which

I am trying to add a hidden field to a combo box, and am unable to get more
than 1 field to add/display.
The code is comboboxname.additem (value)
Can anyone tell me how to add the second field?

I have a docmd.requery that goes off every three seconds.  
When it requires the cursor moves to the first record.  I
was reading that I could add code that bookmarks the
postition, so after the requery the cursor does not move.  

Dears,
Need help in populating the month and year after entering the date of birth
in a field. Tried below but only gives me the number of years
age = DateDiff("yyyy", [dob], Now()) + _

How do I create a new directory for a file?

Howdy all,
   I have a form with the following objects and sql:
3 unbound listboxes
lst1 has the following sql in the row source

When running a query in Access there is a lot of networktraffic between
front-end and back-end.
When you make a docmd.runSQL with a statement is there any less network
traffic and are there any advantages / disadvantages with the two methods?

I have a strange situation in which a New Record is called up in certain
situations, but does not accept any new data.  The New Record is called by
clicking on a Command Button on a form.  If it is clicked right after you
have entered one record using that form ...