I have 2 tables:
tblOrderDetails - ID (PK), OrderNumber, etc.
tblPersonnel - OrderNumber (PK), Initials
The OrderNumber are linked together. This allows the Order to be linked to

Hi all, can anyone help with a wierd problem?
I have been using a database for soem years, which involves a number of
related tables. I have a table of Transactions which contains an autonumber
TransactionID, plus several other fields. There is also a table of Items,

My main table  has several fields that are inputted via combo boxes in a
form, with the combo boxes bound to small tables with maybe only a field or
two....basically tables set up to provide the choices for the combo boxes AND
make it easier for users to add choices to the combo ...

How do I add an autonumber column to an already existing table?

Hello, All!  Is there a shortcut key for switching across tabbed tables?  My
A2K Help doesn't work anymore after a certain update.. so I'm sort of stuck
finding a solution.  Google wasn't much help either.  I would like to be
able move/switch across the tabbed tables in BOTH ...

I have an excel spreadsheet that has been imported into access. This
spreadsheet contains client name, document name, document date and
classification.  I have a list of questions that will be asked each client
based on their classification.  Each classification contains a ...

I cannot add a record through query datasheet view or a form.  Here's the
setup:
I have two tables linked to a frontend.  The relationship between the tables
is defined in the backend as one to many; referential integrity, cascade

I have very little knowledge of programming. I have a button that calls a
combo box then a particular report. I need to pause after the Combo box is
open to allow for data entry. then open a given form.
Any thoughts?

Let me see if I can illustrate my issue:
TABLE
# of Accts           abc         DEF      ghi
5000                 $5,000     $2,000  $300

I have taken over a database with a Memo field in it.  About one-fourth of
the records have data in the Memo field.  All of the field lengths are less
than 255, with 75% of them being under 100 characters.  What are the data
storage specs for Text and Memo?  Is text just a ...

I am not sure if this is the correct forum for my questions but I am going
to give it a try.
The IT department where I work is trying to grow our database development
services. We use both Access 2002 and 2003 and we are starting to use SQL

Friend,
I'm always looking for good and intelligent individuals like you to
visit my website, www.ChezBrandon.com , and it has pictures of
beautiful women, information about aged clones, and a link to Ultimate

Is there a way to show the size of the individual tables in an Access database?
It's well published that the maximum database size is 2Gb.  Since I'm
approaching this limit I'd like to know the size of each table within the MDB
so I can figure out the best approach for an ...

I designed my db with access 2000 and converted it to 2003 , but when my
clients open the db with 2003 it gives an error "OWC10.DLL file not available"
What happpens is that the spreadsheets that I put in via the active control
tool now does not show.

I have a form with a phone number field.  Instead of using formats or input
masks in the table I just formatted the field on the form with a format of
"@@@-@@@-@@@@".  Now when I use the Duplicate command button on the form, the
new record has double dashes such as ...