Hello, I'm using Access 2003 and am a novice.
I'm creating a very simple (I hope) relational DVD collection
database, and am encountering a problem when I add a third table and
try to join it to the other tables.

Access 2007:
So I have a subform with a control that has an OnEnter event. I'm finding
that the event is triggered when the form is open, even before the OnLoad
event of the form is triggered.

I don't know if this is the case or not, becuase when you use Access 2007
help it seem to get a lot of unrelated results, but do all of the words get
searched rather than filtering results based on all the word?  So it I enter
Linked Table Manager, do I get all of the results for ...

Ok here's a good one.
I have four tables called:- Main Control (Main Form Data), Board
Information (Details about Board Revision), Software Information
(Software relating to the Board Revision) and SF Numbers (a table of

I have a main form that has a number of fields that are populated by
the user. The fields in questions are
1) RGAID - Auto Number - Primary Key
2) RGANbr

To find the linked table manager in A2007, right click over a a table name.

I have the following on a click event on "Followup" command button.  On
clicking this button it open a param form.  It looks at pts assoc with doc.  
There maybe more than one pt.  If the "appt" or "followup" field dates are
null it will open form to enable to enter info reg pts ...

I have a database that uses a main form with 6 subforms in it.  In each of
the subforms, I can enter multiple lines of data for each main form record.  
However, when I select a new record on the main form, the data in the
subforms (which is linked to the data in the main form) ...

I have cells with titles in which some words are black, others are red/
struck through, and other words are blue.
For every cell that has blue words, I want to convert those words to
green.  All other words in the string should remain, as is.

When I tried to add another subform to an existing subform, the "InvNbr"
field is missing from the invoice table.  My table structure is as follows:
tblVendors
VdrID PK

I have created an access form whose records are stored in 2 tables and i have
inserted second table as a sub sheet into the main table .If i enter a
subject number in a text box and hit a search button i should get  all
records from database and display on form

I a new user of Access 2007 and am wanting to use a drop down
list in my form.  Is this an option? Help!
-
Jane Marlotty

We have a form with a list box that allows us to view equipment information
(part #, desc., etc.)  When we select a record from this list to enter into
the form, the information is not populated in the table.
Little background information:  We have one table that contains ...

I created the form in '97. When we converted to 2007 the form no longer had
spell check available. We have two users that have only the form and the
ability to enter data, they do not have the program. They are also Spanish
speakers and need spell check for English words. I am ...

I am working on a database that tracks insurance policies for clients.  I
have a main client form (frmClient) with several subforms on a tab control.  
On the policies subform (displayed as a datasheet, master/child link is
ClientID), I am only displaying a few key pieces of data, ...