I have a table that I have consecutive numbers in and I would like to setup
a form that will automatically enter the next number each time.  E.G.
ITCC07-001, once this number is used I would like it to automatically go to
ITCC07-002.  But I need to be able to stop this at the end ...

I linked a parent and child table.  The parent had an autonumber
connected to the child table field which was an ordinary number.  This
worked fine when I opened each table and then the plus sign against a
record the other table appeared as a sub-table.

I have a form with the following SQL statement:
SELECT Orders.CustomerID, Customer.FirstName, Customer.LastName,
Customer.Address, Customer.City, Customer.State, Customer.ZipCode,
Customer.Phone, Customer.Fax, Orders.OrderID, Orders.CustomerID AS

Just installed Access 2003 to manage our HUGE database for our supplement
website. I can open the database (created by our programmer, the jerk), but
when I click on a table or anything for that matter I get "ODBC connection
failed," and "Cant Open Table in Designsheet View." Now ...

Would like to add a text box that contains a calculated field containing info
from another table.  Other than building a form off a query I don't know how
to do it.  I thought putting =sum([name of field from other table]) would
work but it gives me #Error.  The tables are ...

how do i recover deleted table in access 2003? thanks!

I am working on a Database to keep track of what classes are needed by
students for graduation, and how they are progressing toward that goal.
Students are on different Tracks. so I have set up a Table containing those
Tracks.

Access 2003.  I have only had experience making forms based on a table or
query so when the recordset is set to query 1, I can only add controls from
that query.  Is it possible to add a control from another unrelated query?
If so, how do I do that.  Here is the sql from the ...