How do I add fields to the Access Inventory Control Database

  • Thread starter Thread starter Guest
  • Start date Start date
On Thu, 21 Sep 2006 11:33:03 -0700, overhead door <overhead
How do I add fields to the Access Inventory Control Database template
Click to expand...

Open the database. Hit F11 if you don't see the Database window (with
tabs for tables, queries, forms, etc).

Select the Tables tab. Select the table that you want to modify; add
the fields as needed.

Open each Query referencing the table and be sure it includes the new
field. You may need to open Forms and Reports, select their
Recordsource properties, and open them as queries; add the new field
as needed.

John W. Vinson[MVP]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inventory Database 1
Inventory Transaction Problem 1
HELP! with Inventory DB Template 1
Looking for software inventory database template for Access 2003 1
Excel Changing amounts from one sheet to another using specific item # 7
inventory control 3
Inventory project error in transaction 2
Inventory Help 3

Back
Top