I have an address field and in the form's property of "Enter Key Behavior", I
have "New Line in Field" selected.  I have this same field multiple times for
different types of contacts, and all are set up the same way (i.e., technical
contact, executive contact, billing contact, ...

This should be so simple, but I've struck out.
A table has multiple indexes, but it always uses one of them for every form.
I'd like to display the data in varying order depending on the use of the
form, so how do I tell the form what index to use?

How can I set my database so that when I open the database a form will
automatically pop-up.  I need to have one particular form pop-up evertime
that my database opens.  Please help. Thanks.

I have a table with 12 columns.  The columns i am concerned with right now
are Master File (TEXT) and CAD(Boolean).  I know how to do what I want in VBA
but Access does not support VBA in querries so I am lost.  I want the query
to check Master file and store if CAD = Y.  Next ...

Can someone please give me a couple of examples of a table with a
multiple-field primary key? When would this concept be used?

I have just completed the devlopment of a helpful communications set-up
using Access, but the final key step is being able to place long email
address strings into the Bcc box in MS Outlook using the Access SendObject
Macro.

I have a table where work done on aircraft is broken down into zones and
qualifiers applicable to those zones. For example 'fuselage' has qualifiers
such as 'front', rear', 'flight deck'etc.
Users need to query the data based on zone and qualifiers.

Well, that's not a very good description of what I'm trying to do but it's
hard to put this stuff into a few words.  I am using MS Access 2003 and am
having a major "brain fart."      ;-)
I.E. - I have this table:

I have a payroll check stub report that I need to show the year to
date totals for. The report is based on a table with no underlying query.The
report uses the date field on a form to filter just that week for the
stub.Thanks for any help.Jim

Thank you in advance!
I have a TxtName unbound and i would like to populate it with the
name(LastName, FirstName) that is bound to iether  ID(primaryKey) or
SSN(bound).

When I change the information in a table, how do I get the form that was
already created to reflect the change?  ie. showing new field, changing it to
text or yes/no for example.
Thanks,

Attempting to produce a number for Years of Service, by subtracting the field
[hire date].  I am using the following in an unbound text box in a report:  
=Date()-[hire date].  It is producing a result, however not recognizeable. I
have the txt box formatted as a general number, ...

can anyone help with this query example, write down a qeury statement
as if following WHERE in an SQL statement to report this
all students who do not live within 10km of birmingham univeristy or
less then 19years old

I have a query (qryPortlandData) with one table (tblPortlandData) that works
fine. I'm trying to add another table (tblToteParts) with one common field
(PartNumber) between the two tables...but I keep getting the error 3079 "The
specified field <field> could refer to more than ...

Just a quick Q. Where is the setting to turn on Line Number in code view??
Bill