I am trying to simply copy and paste a bunch of rows with
currency number from the internet to excel to access, but
I am coming up with "The value you entered isn't valid for
this field."  In access the field type is currency and in

2 quick questions,
In some queries i get the Error message 'Access cannot
represent the join between ModID and MSModID' - most times
I use this join it works fine, any ideas why?

Once I retrieve my table an error occurs in the field
labeled CAN(Common Account Number). It appears like this:
#Num!
I reviewed the data in the Microsoft Excel format and it's

what is the best step by step procees to create a
database with forms to enter data and reports it will
probably be elaborate i need my references to be on line
or html files i can print

I have a table containing employee name, address, and
telephone number employee ID (primary key). I have another
table containing information on applications for post with
a primary key of (selection ID).This creates a many to

Is there any way to stop Access from removing the leading
zeros in a numeric field as you are entering data in a
Table.  ie. enter 000123 and Access stores 123

I volunteer for a non-profit service organization.
I have to keep track of personal information in one
table. In another table I need to list all the members,
and then keep track of their volunteer times.

Why is it the Access XP & Access 2003 does not support the
same number of nested forms in the same manner as Access
2000 (i.e. up to 8)
Just what is the magical number of subforms Access XP &

I have a table with 32,900 records in it.  I tried
to "Analyze with Excel" but I run into an error message.  
The message says, "There are too many rows to output,
based on the limitation specified by the output format or

My database contains the data for special needs pupils. I have a field that
has the reading ages of the pupils taken from a reading test. I struggled
for a long time to come up with a format that would record the data in the
way I wanted. E.g. a pupil with a reading age of 6 years 8 ...

OK, this is my first database and I've posted the table structure to get
your advice.  I've done some reading, but I'm still not feeling that
confident.
We've grown from a company of 3 to 8 and tracking software licenses is

I have a database of 2000+ clients with several forms to
update that database -- the dates I work for clients each
month; receipts information in payment for the work I do;
etc.  The original database was created in Symantec's Q&A

I need to create a table that has alphanumeric coloum
that is formatted like LLLL1234567 and i want the first
six numbers to auto incramete also i want the last number
to be generated in the sequence

I have two tables and I need to develop a way to determine
why one table has 7591 records and the other table has
5396 records. One table is a downloaded Access Database
and the other table is an Excel Spreadsheet.  The

I have a table with 34,212 records and a primary key in a
field called ID. My boss wants each record to
automatically assign itself a company order number in a
format of 04-xxxxx. I was able to somewhat do this in the