I need to be able to add a new field to my table and
change the data types of certain fields by using code.
Any Ideas?

I have a single database to cover inventory where there are 3 types of inventory and different detail questions to be asked for each, depending on what the type is.  I'd like to create a main inventory form for the general info, w/ an option button for each type of item (pieces, ...

I want to import data from multiple sources.
Each source has multiple entries with 6 fields in each entry.
Is there an easy way during import to assign the souce to each entry
in a 7th field.

I tried to sort dates in the mm/dd/yyyy format in a column
of my table, but the computer is treating my dates as if
they are just numbers so the sorting is not quite right.  
How do I format the date so that it can be properly sorted?

I have to design a table or tables to contain the
following type of info:
OrgNbr
OrgName

I was using Microsoft Office XP Professional
and now have upgraded to Microsoft Office
2003 Professional.
In Microsoft Access I have a Database

I'm putting a survey into Access and after my last round of updates to a table, when I try to save it I get an error message saying "property value is too large". Does anyone know what this means, or how to get rid of it?

I am building a database that has a contracts table, which
contains various information about our different
contracts.  I have pay methods fields and description
fields, ex. paymethod1, description1, paymethod2,

To All
How do I "update or replace a table" in the data base with new information without loosing my connection to forms that I have created? ( I am hesitating to use use "append table" because I have added information and new field on the new table. )  What I have done so far, is ...

I have 2 tables that are linked together by a field called
MemberID.  Table1 has MemberID as the primary field.  When
I originally designed the database, I split the tables up
and now realize that the information shouldn't have been

I am trying to limit the number of records allowed in a
table.  The best solution I have found is to create a
DELETE Query that deletes any records that go beyond the
specified limit.

Something has happened to one of the fields in my table.  
The field "Type" is in my table design.  It is in my
query, but when you pull up the records for the table the
field is not there.  Please help.....

I have a table that has two fields, the combination of
which is unique.  Can I make the combination of two fields
a primary key?
Are there limitations with this?  Both fields are wordy at

Can you import a Microsoft Access table to either the Microsoft Works
Spreadsheet or the Works Database?  I am planning on creating a database to
keep a log of the books in my church library.  I have Access 2003 at home
and my church has Works 4.5.  I want to use Access because you ...

I have two tables: tblCustomOrders (uses and autonumber to
create orderID, KI-0000) and tblProgramOrders (uses and
autonumber to create orderID, NW-0000).
The reason for two tables is that custom orders have a