I'm certain this has been answered somewhere but I couldn't locate the answer.
Three tables, one a junction table.
Table 1 tblMembers...
Table 2 tblPractice (Sessions...)

I have a form with date ranges.  How do I change the format from tabbing
between dates versus using the enter/return key?  Some of my forms use tab
and some use return.  I would like to make them uniform.
Thanks,

I'm using an input mask on a field.  The mask is  

The mask is set up so that the underscore character appears for every
character in the mask, denoting the field length (this includes the optional

I am trying to use DSum on a form with multiple criteria:
DSum("[ExtendedTotal]","[Order Details Extended]",
"[Products.ProductID] = ______
I need it to look up and sum the records where the Product ID is any of

I am using an unbound combo to search records on the main form.  When I
first open the form from design view, the combo is nicely set to blank until
the user clicks it (and can select record to find in the list.)  After the
record has been selected and appears in the main form, ...

Hi guys i really need a Query to show the top ten entrys in a table :}

I have a form with a number of fields that enters values straight into a
table. Suddenly I cannot view the past records on this form all I can do is
add a new record.
The records are still there in the table but I would like to be able to

I need urgent help to bind Company field and a City field to a Combo
box of Names,all this data comes from the same table, I just want if I
select a name, based on that selection it fills in the other 2 fields
automatically

Relatively new to Access and limited knowledge of VBA....
I have a form (frm_Detail_By_Location) that has many fields on it.  The
forms' source is a query (frm_Detail_By_Location).
I want to add a button to the form that will sort the form (while it is

I have a form with a subform that tracks the different times a student is on
our campus.  The primary key is an auto number for the attendance since a
student can come on campus more than once per day.  the problem is i have no
way to detect duplicate entries or overlap of times. ...

I have a bound main form with one subform.  The subform is linked to 3
textboxes on the main form.  The textboxes contain the keys to the data in
the subform. The textboxes changes value based on what I select in a combo
box on the main form.  

I am brand new to Access (which means that any reponses that use
programming language as opposed to software uses instructions will,
unfortunately, be lost on me).
I have a fairly basic question.  I created a simple form for a database

I'm using this code on a listbox to find records on the same form.  It
works fine except I need to base this on 2 criteria not one.
Me.RecordsetClone.FindFirst "[LineId] = " & Me![List52] & ""
    Me.Bookmark = Me.RecordsetClone.Bookmark

Can I bind a form to a table in another .mdb file?
Thanks
Paul

Access2003: When naming "Items on this Switchboard" with the '&' character in
the middle, e.g., "AT&T", actually displays as ATT with the 2nd T underlined.
How do I get the '&' to actually display as '&'?