I have a table with index keys made up 2 fields: Phone, Year.
In my form, I created 2 text fields for phone, and year input.
Also I created 2 command buttons: Add, and Find.
I can find the record with 1 field but I cannot figure out how to Find a

I have a small(?) 4-table contact management/sales call report database that
I need some help getting off the ground. It basically works but have some
form problems, security questions and basic db design questions (to keep from
storing duplicate data). If anyone is interested in ...

We have been using a product called Access Autopilot for the past year, but
have been having some problems for several months.  We have not been able to
get a response from the company!  The software stops running and we get a
message saying "Service has been preventively ...

I need to create a database structure based on an indentured or indexed "Work
Breakdown Structure" (WBS) numbering scheme (i.e.  2.5.15.2.7).  The
numbering scheme is based on a max of two digits per level with a max of ten
levels (i.e.  99.99.99.99.99.99.99.99.99.99).  I first ...

I am working on a form using an select box as a filter it works fine but now
I need to select more then one location. I was thinking about using choose in
a query I need to see an example of using choose

I have a Case File management db.  There can be multiple clients in each
case file.  Each case file has a primary contact.  Each client also can have
separate addresses and address history.  It is possible that the Primary
Contact is not a client.

Firstly can somebody please tell me if it is possible to do a database design
change on a separate copy of my database and then bring it on to update the
one I am using. Does this have any effects on my data already in the
database? Secondly is it possible to seperate my data ...

I'm fairly new to ACCESS (and not very knowledgable in it's technical
aspects).  Can someone please give me advice on how to create a field in an
ACCESS database (table) that will automatically register the current date
when a new record is posted to the database (that is, the ...

I am having trouble with my database. I need to be able to put expressions
into my database. I have 4 columns that are applicable. DOE-Date of
employment, Date of last review, next review due, and days late. I want to be
able to input the Date of employment by hand. I want the ...

I have the following tables (for business loans):
Borrowers - Contains info on the borrower, address, financial info, etc.
Loan info - contains details on the loan, terms, collateral, guarantors, etc.
Principals - contains financial info on each principal

Anyone noticed this one?
CurrentProject.Connection.Execute _
"CREATE TABLE Oops;"
Set rs = _

how can i copy selected records to a new database while maintaining the
numbering that was originally assigned by auto numbering and relationships. I
am using access 2000

If so, would you be willing to share the design?

I constructed a database nearly ten years ago with very little knowledge
on my part.  I’m self-taught and have learned by example.  I’m sure
there is a better way to set this up, but I keep coming up against a
mental block, so that, even though the old way may be clunky and not

I'm very new to Access so this is a very basic question.
As my first project I'm setting up a database on politicians in my state.
Some will have 2 addresses..1 in our state and 1 in Wash DC.  They also will
have 2 websites.. their official site and their re-elect site.  I'm not ...