I am trying to have a "workbook list" table recreate
itself based off what files are in a particular folder.  
For example, if I have file 1, file 2, and file 3 saved in
a folder then I would like my "workbook list" table show

    Can someone please explain how to set the value at
which an autonumber will start? I have two different
tables and in one table I want the primary key (CashSale)
to start at 599, and in the other table I want the

Need to create a routing slip for employee use

Hi, I need help!
I have a table named TblMDR and a field named MDR.  I want
that field to automatically default to "BVL" and then an
autonumber.  I can do this in a query but it does not get

I am new to Database Design and I just can't grasp the whole relationship
thing...maybe I'm trying to think too much into it.  Can someone point me to
some reference or material or some suggestions to make the whole thing click
for me.

Bible Database in form of Book chapter:verse (Often a span of verses or
across chapters)
Can I use a mask or template to enter data in Access 2003?
Thank you so very much & God will bless you for your help,

I would like on a form, to complete some fields.
EG am detailing an order placed by a customer. The
customer details are stored in a seperate table. I have a
look up to find the customer, but then I need to have

Is there a way to setup a field so that it automatically time stamps a field
I create a field with datetime type and set the default to NOW().
If I create a new record directly in the db this field get filled out.
However if the record is created through a FORM (actually 3rd party ...

How can I reasonably estimate the size my access db will grow to be.  If the
number of tables is fixed at 10 or less with each table containing 50 to 100
fields.  
Each row in a table contains a unique set of data identified by a case

I'm using Access 2000 in a front end, back end situation. My problem is this.
I set up my relationships in the back end and then they disappeared. If I try
to set them up again I get the error "The cascading options for the new
reference conflict with the existing reference." ...

We need to put together a database that tracks product
development and there are several points in the process
where the LotNumber will get split and then the new
LotNumber(s) (and possibly the original) will go on to the

The relationship in our db are randomly dropped. It
doesn't happen all the time or with all users. What do we
need to consider to find and fix this problem?

I have to add a few fields on one of my tables of  my split DB.Front End on
users desktop /Backend on shared folder.What is the procedure to make this
change???How will it affect the DB? Do i add the fields only to the BE on the
shared folder or FE..or both at the same time?

I have a text field that I need to insert a decimal point
into. The text field values are really numbers that I need
to input a decimal point into. I tried table design on
that field and put in a format and/or input mask but I

I have just designed a Student Report DBMS using ACCESS 2002.  There will be
a total of 50 users and probably about 20 users working on various forms at
the same time.  There are about 400 students in total, each taking an
average of 6 subjects.  I have read in a few books that ...