I am wondering if someone knows how to create a validation rule in a table that would throw an error message in a form.
Here's what I have in a table:
Field1
- Data type = Number

I have a database that tracks transactions for internal
comany use (intrabank transfers, wire transfers, etc.).
Many of these entries are similar period to period
(changing only in amount and maybe description).

My "imported or linked" database has duplicate rows. The
(columns) fields I need to extract only need one row for
each entry in the invoice field. Please tell me where to
find out (a) how to compare one table to another, and if

I have a split database on a network, it has been split, Front End and
Backend. I have the Backend on the server and each of 18 computers have the
frontend. For some reason I have been getting this error as noted on Subject
line,,Any suggestions as to why, this was working a month ...

Help! I'm struggling over this problem and need either suggestions on the way to accomplish, or a better way to design my tables
I have a customer database that contains the following tables: Quote, Quote Details, Job, Job Details. If a customer accepts my quote, then I would like ...

5-CR19AI46130-6  -5651 (wrong)
1-RT1AI59401-1-5751 (should appear like this)
2-RZ1AI30464-13A1-5751 (or it may appear like this)
The above numbers are concatenates of other fields

how can you tell if a recordset is open?
how can you tell if a table that is being used as
recordsource for a form is open?

Thanks in advance for any information.
Does anyone know of a database / template on newspaper
production. I would like to see a database which track
inserts from the time they enter our receiving area thru

  I get the message whenever I try to open a table in
any view.
Box Title: Access
Message:   Unknown

I have a table with Contrac_Num, Company_Name and Fees
that are charged to that company by contract.  I have a
table with 124 codes for each type of fee.  They enter the
Contract_num, Company_name and Fee Code. I need to find

I am trying to invoke create table wizard and nothing happens.  Would anyone
know the reason for this?
Is there settings enabling it?
Thanks in advance

I like to would like to design a table for medications and need help any help I can get to make it very stable.
I am new to database, and have limited knowledge so please provide more details if you like to help.
Patient prescriptions (multiple prescriptions for each patient)

I have a database that tracks transactions for internal
comany use (intrabank transfers, wire transfers, etc.).
Many of these entries are similar period to period
(changing only in amount and maybe description).

I am using a query to provide lookup information to fill
in  a field in a table. THe query is working as designed
and returning only one value. I am trying to eliminate the
need to select the drop dowm key and just have the results

I am now working with old DB that they want a new table
for:
Old: Contracts Table
      Contract number