Can somebody please help me with question? If I allow
duplicate data to be entered into my table field [Client]
because it is neccessary how could I then detect this
situation every time it occurs and tell user on my form?

When I select a wizard, whether in table, query, or
report, etc, the wizard does not open.  How do I solve
this problem.  I can only create things in design view.

Does anyone know where I could find a free, simple
purchase order system that I could manipulate for Access
2000?
TIA

What is the best word.doc or pdf file to download and use
to design a access 2002 database from the ground up.
Thanks
John

I have an Access MDB that links to dBase files.
The problem is that there is a separate group of dBase
files for each day of the week.  The table names are the
same, but you have to get them from a different file.

First, I have 3 different ODBC Tables in which I'm pulling
certain fields together to form a Make Table Query.
Second, I would like to add a field within my Make Table
query to include a number that is a result of three

I am working on a database that will work on a FIFO
inventory model.  I cannot get the database to remove the
product from the inventory in this fashion.  How would I
go about getting the database to take (for example) all

I am tring to put together a query or series of queries
(my VBA expeirience is very low) that will distribute
work assignments by creating child records in another
table based on the two parent tables

Is there a way, either through a macro, query or VB coding
to change the formats of fields in a table that was
created using a query.  When a make-table query is run,
the resulting table does not keep the field formats of the

I have a field that contains a formula that calculates %
based on information that is entered on the form. All the
information carries over to the table EXCEPT for the %
(the field that contains the formula)... Any

I have a system that collects usage data by month by individual within the company. Each month's data does not necessarily include the same individuals. For example, if there are 500 employees in the company, in January, I may have a listing with 100 employees. In February, I ...

Does anyone know how many users can have simultaneous
access to Access97?  I thought it was 255 but my friends
in the know (supposedly) say 10 max for updates.  HELP!!

Please Help,
I have database that is heavily used for data entry. A
user will input info on a simple form that feeds to the
main table. 4 users access the database from our network

I want to scan in documents that pertain to each
customer.  How can I create a table with the customer ID
field and a field that links to that customer's document
(The document is a scanned document so just a picture)?

I am trying to edit a tables' structure using VBA. I can
create a basic field using .CreateField()
and .Fields.Append.
I want to create a field in one table that exists in