I want to create a field on a form that will look at the child's birthdate
and calculate their school year (kindergarten through 12) based on their age
as of September of the current year. Example, today is April 11, 2008, I
would like the grade to be as of September 1, 2007.

I have a dropdown in a access 07 Form which has a list of States.
I would like tjhe state of Washington to be the default state showing, yet
allowing the user to click the dropdown arrow to select another state. I
tried the Default option and typed 'Washington' in properties, but ...

Heres the problem:-
I have a subform within a form.  When the user enters data into the last
cell of the subform I have set an Event proceedure on the Lost Focus, to
send the focus back to the parent form.  The problem is that the subform

I have a database with 5 tabs, 4 have subforms, linked to main form via a
user ID field that automatically fills in on all subforms when the ID is
entered on the main form. The problem is that in form view, after entering a
new ID, when I click on any of the other tabs, the top ...

My problem is very simple and yet I could not solve this problem.
On my form is  a combo. The properties are as follows
Control source  :  Wqty  (which is bound to a number field in the table)
Format:  when I enter #0.00 it automatically change to Fixed

I have been asked to write a small inventory application where the item id's
and descriptions need to be kept in both English and Chinese.  I have all
versions of access from 2000-2007 available.  I believe the text fields have
to have the Unicode setting on, but how do I allow ...

With a One-To-Many relation between two tables, is there a way to
display the fields of the "One" table once in a "grid" like display?
See below.  I'm using Access 2002, but have 2007 if it has any new features.
Company.... Name

Where might I find calendars to integrate into my access 2007 db.
Don't need for data entry just viewing.
Thanks,
James

I have a DB that utilizes a "temporary table" environment.  A user will open
a form with the specified information, and that record will immediately be
written to a temporary table.  On exit, the user is prompted whether or not
they want tosave the record.  If they say yes, the ...

I would like to have a subform that displays in datasheet view that
highlights the line item when clicked and if double clicked added to a
table as an urgent/critical item.  How would I accomplish this?

 Is there anyway to have a continuous form populate from Left to right
instead of from Top to bottom??
Ernst.

I used the code from http://allenbrowne.com and seem to have problem with the
line. it worked fine when the table has an auto number column but i removed
that column the table has just one NAME col also it stopped displaying the
names.

I run Access 2003.  Here's what I'm trying to do:  Users click a
search button which opens frmSearch. Users enter the first and/or last
name of a person and press enter, which displays a list of possible
records.  Users can doubleclick any record in the list, which displays

I have a form with a TAB Control on it.  I have fixed the form so that as I
exit the last field on the first page of the TAB Control it goes to the first
field on the second page of the TAB Control.  When exiting the last field on
the second page of the TAB Control it goes to the ...

This should be simple, but I can't figure it out.  Nor can google.  So
I need some help.
I have a form with various controls - including a couple of text boxs
I want to use for collecting date information from users.  The