In my school database, I have birthdate in short date format in my
table.  If I want to create a query to select all students with a birthday
during the current month, how can I split up birthdate to do that?  Thanks!

Basically needing a bit of help with MS Access, and a few forms im
doing.
Ive made a form, which is now linked with an imported MS SQL
database/table.

I have a textbox "tbSession1" (Actually I have several)
that when double-clicked will cause a related combo
box to become Visable and dropped. I can obviously
capture the name of the textbox in it's Double-click event,

When UPDATING, INSERTING, SELECTING or DELETING in Access with SQL is it
better to reference a Listbox field by placing the Listbox value into an
Unbound Textbox or by refering to it by column....such as
Me.Listbox.Column(0) also is it OK to use Me. in an SQL statement.  Just

Novice
I have a combo box on the header of my form that selects travel
destinations. It worked fine until I changed the name of a field in the table
(and in the code).

I made a query called "STOCK", in that query there is a calculated filed
called [Stock].
I want to have the value of that stock for each [ProductID] as it appears in
the form "Products Deliveries".

I have a combo box whose underlying
query contains [FirstName] and [LastName]
as separate table fields. I want to populate the
RowSource with a formatted name:

I have a form which takes values from the user and saves it into an existing
table.
The problem I face is when the user does enter some values and deletes it
and closes the form still a new record is created.

my some text has been converted in to unicode text.
how can i restore my original text.

I would like to be able to highlight each control on my forms at it receives
the focus. I could do this by changing the properties of each control
individually, but that is a lot of work. Is it possible to write a routine
that I can call from each form to do this ?

I'm very new to Access but I've created a form named NewMembers which is
linked to a table called members. The object of the form is for the user to
input new membership details and besides the usual fields of name, address
etc. I have a field for Date of Birth. I also have a field ...

I have a filtered subform that's not linked to the main form. The data on the
subform is filtered based on the controls on the main form.  
The filtered subform is showing data ok, but the problem is exporting the
filtered data from the subform.  I tried OutputTo method, but ...

Grreetings.
I have a main form that on it I would like to either place a subform with a
subsubform on it or instead place 2 subforms.  What I am attempting to
accomplish is to have one subform (B) dependent on the other subform (A)

I have a cascading product picker that relates 5 categories each
providing a pick list related to a previous parameter.  The picker
works when placed in a form by itself, but the parameter doesnt pass
when the combo-boxes are nested within the subform.  I am currently

I am trying to run the procedure below and keep getting the error "  Syntax
error (missing opoerator) in expression."
Access highlights this row:
rs.FindFirst Criteria