I'm trying to edit the Access 2003 "Orders Management Database" template that
I downloaded from this the home site.  However, whenever I try to add a table
or anything of the kind to the file, I get a message saying that another user
has the file open, and that to save my design ...

Hi - so far today (first day with access 2003) I created a table -
customerID...then created a form...customerID and made the layout the way I
want it to look.
Now I am working with the fields... I have all the numbers formatted

I have an access database and I would like to the Update field to generate
the date automatically after each change of data in the table. I read all the
postings on date, which were great.  But if someone could help with this,
would appreciate it.  I want users to know when the ...

I just inherited a large Access 2K3 application that is designed with 1
front-end mdb file that links to one of 3 dozen back-end mdbs.   Each of the
back end dbs share the same table structure.  They sort of function of as a
crude horizontal partition.  If they were combined, the ...

I am starting a new project to be able to track some of Inventory that
is being shipped with the product.  All the items have bar coding.  I
need to create a database that I can scan barcode and then to have a
check list before shipping make sure the correct items are leaving

I created a database with list boxes and combo boxes.  I know there is
a limit of 325 row in combo box and list box.  I have 30000 items in
the list and I want to be able to have it in combo box or list box.
I could see all the items, but when I select beyond 255 it defaults to

Is it material description enough as a primary key?, we are not in the stage
of using catalog as a material coding, what would be the constraints if we
use description as a primary key, than we will make an automatic pop up to
show the lowest material price from each supplier.

I have downloaded the "Issues Database" from MS. I have made changes to it to
suit my needs.
Anyway, I get stuck on one thing though. In the databse you can assign a
person who opened the issue and assign one how will address the issue.

I am making a new database and need a little help on the design... Im going
to need to see what type of rig (Drilling, Swab, and WorkOver) on a form that
shows the rigs name, make, serial#, ManufactureDate, Model, etc... what would
be a normalized way of setting it up? Thanks.

I am trying to create a database table for a purchase order inventory system
which tracks items issued in & issued out.
I have designed the following tables
Item master

I need to be able to search the word documents that I've added to the
database using the Attachment data type.  
I've tried querying it directly without success.
Is there a way to do this?

I have a database setup for the storage of details for project submissions.
I have a table which stores the details of the submissions themselves
(tblSubmissions) and want to create a link between these details and a team
of both staff members (consisting normally of 3 or more ...

I am very new at access, but I am trying to generate a unique anme/number
using the Last Name, First Name and autoNumber fields...by reading some of
the other posts, I have pieced together the following:
Private Sub strID_Enter()

I have what may seem like a silly question.
I want to create a 3 table database.
tbl1 - who! - names, title, category
tbl2 - where! - contact info

I'm building my first database. (I'm scared to death!).
Forgive me if I ask a lot of questions -- this is a huge project given to me
by my manager.
I have data sources of all types -- Word Docs, Excel files, Access tables