i am looking fo a sample of dissertation bibliography management in access

I was worrking with a clients db and without going into details, they issued
2 new records in a table then I restored it. I need to put these records in
and generate 2 new records in a table with autonum field. There are 2 "open"
places for the records but I don't if it's possible ...

I created several tables differentiated by YEAR. They're pretty much the
exact same fields (survey questions), just different years (there's no
relationship). Within these YEARS, there are questions for different DAYS.
So with each ID, I added fields for all the questions for all ...

I posted something regarding lookup values(22/11/2004).A solution was
suggested which requires me to use the DLookup() which I have read and
understood, but the probem is, where exactly do I type these DLookup
commands, is it on the field just next to the After Update,or in the

I am using two tables, one called projects and the other projects details.  
They are linked to each other by a unique number (projectID).  I want to be
able to number the lines in the projects details table by combining the
unique number fromthe projects table and a line number ...

How do I create a data array for data input of an unknown volume for a
particular field?  If I knew there would be 12 transactions, I could write
the database with 12 fields, but I don't know the number of transactions.  
Any ideas?

I managed to unlock all system tables within access.
When querying sysobjects I get an overview of all tables, queries,forms etc.
within my database.
The only thing I can't manage to do is getting an overview of the fields

(I tried embedding some high resolution graphics scanned images in BMP and
JPG format) in an Access 2000 database to use as the background of some
forms. I ended up not wanting them and thought they were gone as I could not
find any more reference to them in any form properties ...

Apologies for the duplicate post but I think something may be wrong with my
original post as Rick B responded to my post as follows: "OK. Do you have a
question".
So I am trying again. Here is my question:

How can I protect the design of my objects in an Access
2003 database? I want my users to be able to insert,
delete, and modify data, but I do not want them to be
able to change the design of an object, nor delete an

I was wondering if I should upsize to SQL backend or not - I currently run a
front end back enviroment, the backend right now is only 100mb and the front
end is about 32mb, I have users across the country using it (between 20 and
30) concurrently - some of the forms take a long ...

Building a database for a company. I want to print a catalog with reports
from the database.
I have the product and purchase price in a table. In another table I have a
number (45) which represents how much each product should be markedup. I want

I'm really stumped on a db that I think should be so simple...
I want to convert a 5 field Excel spreadsheet (with 1000 rows) to Access.
The table consists of the following fields...
1.  Sequential number (1 to 1000)

Can you highlight (bold or color) specific cells in color like Excel?

I am designing a database to track interactions with customers. In the main
table, I have TrackingID as the primary key. In order to keep track of
multiple interactions with the same customer, I have a RelatedTrackingID
field. This field is then linked back to the primary key ...