I am very new to this and hope you bear with me!
I want to pull specific data from 3 tables into one report using a date
range.
I have 3 main tables and matching forms to enter the data which are,

All,
I'm trying to have the focus of a subform go to a new record when the subform gets focus. I've tried the two combinations below but they don't seem to work.
Any suggestions would be appreciated... Thanks in advance. - CES
Private Sub Form_GotFocus()

I have a dropdown box (but I can change it if need be), and want a particular
form or report to open based solely on the selection made from it.
I am creating a training database, which works fine up until this point.  
The dropdown boxx contains a list of the courses we supply.  ...

I have a database with 3 main tables - projects, companies and contacts. A
contact is always linked back to the companies table. A one-to-many
relationship.
WHAT I WANT: -

I wrote this code snippet for creating a table and want to add a
primary key... how/where in this code should I do so?
Sub Create_Table()
Dim db As Database

For maintaining address info, I currently have 3 tables, called
Contacts, Addresses and AddressTypes. Here are the fields in each table
(note: I'm not showing fields which do not pertain to this question):
Contacts:

I have a database with its linked tables in 2 different mdbs. I need to
define referential integrity, since the records are linked by a [FileNumber]
field.  If the file number is changed in the "master" database, it needs to
cascade and updated related records in the "child" ...

I am new to Access (2003) and I would like to do something very simple
and probably very common:
tblTypeA
    PK Type

I helped someone develop an access DB to store info about their suppliers and
distribution process.  
This is what I have,
One table that defines the suppliers of bottles (SUPPLIER), A table that

Background,
I have created a small D/Base. Within the dbase, I have created a form with
text box.
The idea for the text box is for users to add a description of some sort,

Using Access 2003

Please anyone can give me the design of Accounting software.
Thanks

How to calaulate the dates? ie. we have a 2005 dodge truck since 05/01/2006,
today's date 10/13/2006, like to know many days old?

I am hoping someone can head me in the right direction on this one. I should
tell you I am not that proficient at Access so if you can help please explain
your answer in a little detail.
In Reports I am trying to create Labels for ID badges using the Label

I am preparing a company profile so i would like to have a cover page
template for my company profile