I have a form with fields Name, title, Company,etc..
I set up the Name field as combo for adding makes easier.
When I add new records, if the same person exists in the
table, I would like to fill the fields like title, address

I have a database with voter information and ten fields that tell the
elections they voted in or if they were absentee.  I basically need to be
able to filter everyone who has a "V" in at least 3 out of these 10 fields
or a "A" in at least 2 out of the most recent 3 fields.  ...

I have created a Contacts database based on the Contact Management
template. The form for entering contacts has a command button for
phone calls. When I click on the button, it opens a form for phone
call records. The form shows the name of the contact, and the record

I'm creating a userform to be filled in and when the "OK"
control button is clicked it will fill the information in
on the next available row on the spreadsheet.  Following
is the code I wrote but it's not working right.  It's

Is there a rule when primary key is needed in a table?
For example I have small tables with 5 - 20 posts. These are used with
Comboboxes in another table. I realize now that a key isn't needed in
the small tables.

I've read through as many posts as I can but I would appreciate some
help in the following:
I am trying to create a form for data entry in Access 2000.  The first
box is a combo box that drops down a list from a table I have created

I have a table in which records are uniquely defined by four columns,
being
name, counterparty, account and date. I now want to make a form (bound
to the table) in which a user can filter down to the record he wants

How do you store images in an access database.  e.g JPeg of a person

I posted the below question and received the posted below
advice which doesn't work.  Advice as to correct syntax or
correction of existing advice would be appreciated.
______________________________________________________

I have a DB set up for recording enquiries and clients.  All clients start
off as enquiries and are converted to clients by checkbox value.
When an enquirer decides to become a client all of that persons details are
recorded i.e. mortgage details, children, employment etc.

Hello, I've just imported some inconsistent data from a csv file into an
Access2000 database. Most of the fields come through just fine except a
field where the data is separated by .
Here's an example of what it looks like:

I have a database for a carpet cleaning business. I want
to be able to send out, on a monthly basis, reminder cards
reminding customers it has been 12 months since their
carpets have been cleaned. I can build a query to find out

Hi, I want to be able to click on a button and have a form open, linking to a
table/query that already has records in it but for all the fields to be blank
so I can directly enter fresh information. There's a button in the navigation
bar at the bottom but I want to hide it so ...

I'm trying to copy linked tables from the front end database, but when I copy
them or export them to another database, they copy across still as linked
tables.  I want to copy the tables, but not take the link with them, or to
break the link.  Is there any way to do this?

If I have the Date of Birth in a field, what expresion can I use in another
field, say AGE field, that would calculate the actual age automatically?
Like DOB field has 29/06/66 in it so Age field becomes 38 calculated
automatically when DOB is entered.