i have 2 tables 1 has the codes of the classes per period
and per student  the other table has who that code
(teacher name) it belongs to What i need to do is do
lookup the code and export out the to another table

I currently have a FORM that, using combo boxes, enables the user to select a Inventory Item from the Inventory Table (using the Lookup function, this combo box selects the Inventory ID and corresponding Inventory Name), while also allowing the user to select a Renter (using a ...

Can anyone tell me how to get my switchboard to start up
when I go into my access program??

I want to set up multiple databases due to the volume nd
complexity of data. Where can I find info to help in
design to eliminate pitfalls and how to interface
multiple databases?

hello - basically i want to create a unique ID but i want it to b
something specific i choose (such as MS1, MS2, MS3 etc.) but i woul
like it to carry on into new columns automatically like autonumbers d
- can anybody help

I would like to archive data on the 15th of every month.  
How do I create a macro or procedure to do this?
Thanks

Rather than getting into detail about what I've done,
first let me tell you what I'm trying to accomplish.
I want to create a 25 question quiz that will be
accessible online.  I've got the web interface taken care

I have created a database that tracks equipment.
I created a table called Location with the following
fields:
Loc_Id (auto_number and primary key)

I have 3 tables with similar data.  What's the best way
to combine them into one table?

I created a unbound form and now I want to add command
buttons, and toggle buttons. Can I now bind the form to
the table it refers to, or do I have to go out of this
form, create a new one, and rebuild all the things I put

I am shipping a new version of my VB program to my client - it uses an Access .mdb file for data storage.  The new version requires changes to some of the db constraints, eg some mandatory fields are now optional.  Is there any way I can script these changes rather than apply ...

I'd like to capture all the changes to a table after a major process OR I'd
like to compare TableA before process to TableA after process and produce a
list of all data elements that have changed. Does anyone know how I can do
this?

When I try to use the linked table manager in Access 2003, no tables show
up.  I open the same file with 2002 and they're there.
I also have trouble in both versions if the path and file name is over about
60 characters.  I can't expand the linked table manager window or scroll to

I am currently designing a prototype model, which should
process order taking, recording and identifying of stock
as well as recording payments.Any suggestions would be
greatly appreciated.

Hello I have a table in in that table I have a refrence
number.... I have the folowing set in my autonumber
field...
"MR"00000