I have a table already populated with distinct records
and I need to add a field where I can assign a unique
ID.  I want the unique ID for the first record to read
F007708604 and then go from there (F007708605, 606, etc.)

MS Access 2K, Windows XP
========================
I have a database which is to be used by multiple "groups"
of users, and each group may have different reports and

I am finally considering spliting my database.
I want to use the AutoeFE Front loader, or something simillar to it.
My question is as follows.
When I initially put a FrontEnd on each users PC & and then they begin to

I have a problem w/ my toolbars.
In any view (table, query, form view), the selected toolbars switch the
orders for no particular reason.
Many times while working in Access, the "File, Edit, View, Insert, etc.)

not sure how to do this but what I need to do is have one
table get info for a field by pulling information from 2-
3 other fields and then use this new field as the link
between tables.

In Access 2002 Bible, page 86, second paragraph, it says:
"It's also a good idea to create a separate datatbase for
just your tables.  By separating your design objects
(queries, forms, reports, etc.) and the tables into two

I recently posted a question about multipe M:M relationship tables.
In one reply, RPW responded with the following:
*************
Although the following is an unlikely table construct, it helps for illustrative purposes.  

I have some experience using Access, but I've been asked to tackle a new problem, and I'm lost. My church is creating a survey to assess priorities and preferences in preparation to search for a new minister. We will be creating the survey in Word (mostly check boxes, i.e., 4 ...

For educational purpose, does anyone have some links to sites where I can
get a functional Access database on an Accounting system (inventory &
accounts)?
Thanks

I need to come up with a design for the tables listed below.  Although I
provided some general information about the relationships
as well, I am not too sure as to how the actual table joins should be
designed.

Is there a way to get the AutoNumber feature in Access to
begin incrementing at a number other than 1? For example,
to begin the numbers assigned to a customer ID field at
4001 instead of 1. The AutoNumber field would then

After splitting my Database, I opened the back-end to see that all (50+) fields had been reset to Text format.  Additionally, all paramters that I had set (default values, input mask)  -- including those not available in form field properties (i.e. Required, Allow Zero Length) -- ...

I just took my first Access class and i am trying to
design a very simple database for about 20 employees.They
each have an employee number but yet i can not assign that
as a primary key.I know it will just require two

I am using a combo box to display the results of a query
for which there is only one value returned. I am trying to
have the information added automatically without having to
select the drop down box control. Does anyone have an idea

Hiya,
I am attempting to create a table with n blank records in
it, where n is a vairable inputted on a form. How would I
go about this as it is driving me nuts!