I have a database that i am trying to eliminate duplicate entries the fields
are FirstName,LastName, WorkPhone, and HomePhone.  I realize i can have more
than 1 client with the same name that is why i am using phone as well.  I
started at the table level and made a unique index of ...

Hello. I have a database that I am creating. I have 3 sub switchboards
that I want to look up very specific information. If I type or select
the name of a company (from a dropdown box I have on the switchboard),
I want to hit a command button that brings up the contact form with

Currently I have a form that will allow me to checkout material to
technicians by scanning the techs name (own table) then the items barcode
(different table). The system works but is repetitive. I would like to scan
or type the tech’s name just once and scan multiple barcode ...

i have two tables: 1 has a list box that is pulling data from the other table
so if i need to change a name i can go to the list box to do so.  the list of
names are there in my list box but when i choose a new name the entry is
blank.  what am i doing wrong? why wont the names ...

My database is created by importing returns under from our MFG software
program and then downloaded to excel and imported into Access.  The software
does not have the ability to go directly to Access.  After importing I append
my "summary" table using an append query.  Somewhere ...

I have a two tables.   the first table has a list of all mutual funds
for all clients and the recommended replacement along with the
effective date.   The second table the the mutual fund data table.
my relationship is a one to many from the mutual fund data table to

Would like to have a status automatically change based on answers to
questions.  Some of the "If, Then" statements are working and the status is
changing as expected.  Others are not.   Any help that can be provided is
appreciated.

I have a database which was built to run a single process.  At the completion
of the process I want the user to be able to make a copy the BE (with a
specific name) and clear all the data in the current BE in preparation for
the next processing.  Each processing requires new ...

The desktop shortcut for MS Access stopped working.  I have checked and the
network is mapped correctly.  Other network applications and shortcuts are
working fine.  I tried to create a new shortcut, it too did not work.

About Me:  I have basic knowledge of Microsoft Access, and I am a
computer programmer (visual basic .net)
Situation:  I have been given the task to look into a problem that our
data department is having.  Some of the data files that they receive

I have a file that I import which is a detail file of a order system.  It contains the basic elements of an order system (order number, item, quantity,, and pricing).
I need to add line numbers to the orders, so if there are three products on the order, I need to add line numbers ...

Hi, I hope someone can help me with a Subreport problem I can't seem
to figure out.  I have a "Downtime-Query" and a "Downtime-Subquery".
Within the "Downtime-Query" I have a "Date" field with Criteria of,
Between [Enter Report START Date] AND [Enter Report END Date].  When

If I input a city with hyphens such as Burnham-on-Crouch into my customer form, all
is fine.  However, if I then want to place a new order from the 'Orders' form from a
combo box with the customers name (which is updated from the cutomer table), I get
the following run-time error.

I am trying to figure out how to create a query with a newly created field
called "Price" whereby the price will be $7.00 if the manually entered text
in the Color field is "black" or if the field is left blank OR the price will
be $10.00 if the manually entered text in the Color ...

I need to be able to restrict what goes into the primary key as in it must
have 7 numbers or either one or two letters at the end. It is the Personal
Indentification number of a person and every person has only one number they
are all 7 numbers and either have one or two letters ...