I have a project where I have to assign a three-part ID
number to each new entry. The first two parts to
the "number" are typed in by the user. Access is to assign
the numeric part (e.g. 1,2,3...)

I have a project where I need to maintain an operating permit for a
client.  The permit has the following format:
Process 1 - Engines
  System 1 - Emergency Power

Does anyone know of a way of copying data in 1 field in a
row to other multiple blank fields in a large table?
I have filtered records and want to copy a particular bit
of data to thousands of rows, where this field is

I have a table that lists employee names, employee ID,
Badge numbers and other info on the employee. This table
is used in multiple queries. When employees leave they
are deleted from the table. We ran into a small problem

I have two linked excel "txt" files that are linked. They
get automatically updated on a daily basis. Firstly should
this link be refreshed after this update, if not ok and if
so is it possible to do it automatically ?

I have built an access data base for Preventive
maintenance.
My problem is this. Some machines need to certain tasks
performed after 5 uses, 30 uses, some daily, monthly, etc.

I have been reading a book that talks about using a many-
to-many resolver or junction table but I just don't get
it.
I have two tables: tblProjects and tblEmployees. A Project

I need to setup tables. Here is the problem. I work in the
newspaper industry. One publication date can have many
inserts associated with that date. The inserts can have
the same name but different publication dates. How can i

How do you import an arranged text into a memo/field where `arranged text`
means the text with the several paragraphs, i.e. the text split into several
rows by the ENTER command.
Assume that we have such arranged text in 2-3 columns and 100+ row table

I tried multiple different changes, but without any luck
maybe someone here can help out on what I am doing wrong.
I keep getting a message:
The changes you requested to the table were not successful

I have set up a 'simple' database for inputting times
spent on jobs and created a query whereby an individuals
statistics can be calculated for a month. The problem lies
in that when the database sums the times for the various

on just a PART of a field?
Here's the structure so far:
Access 2000, 3 tables (Furniture, Titles, Descriptions), no joins.
Here's the design & some sample data:

I tried this post on the general board and didn't get a
response - I'm hoping someone can help and it's simple,
I've been using the lookup list wizard but want to allow
other items to be entered in the field(better yet I'd

Is there a way to have one table (for example I will call
Main Table) and backup (I'll call Backup). What I need to
happen is when records are added to the Main Table I want
it to be added to the back up. Here is the catch. When

Is it possible to lock a table so that new records can be
added but existing ones can not be deleted?