Re: Contact Database Search a Year

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You described the names of some of the objects in your database.

I still don't have much of an idea what you are storing in the tables, or
what the queries or forms are doing, or ...

By the way, if you want to look for (?) some table's records for 1999, you'd
need to have a data field that either contained a date (Access date/time
value) or contained the characters "1999" in some data field. Do you? In
what field(s)?

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Sla13jc" <Sla13jc@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:04751497-D83E-45B5-A238-93B9DE7CB166@xxxxxxxxxxxxxxxx
no i was just saying what year of access i am using it's alreday saved as
a
contact management database.

the tables are:
contacts
settings
sheet1$_Import Errors

Queries
Contact Extended

Forms
Contact Details
Contact List
Getting Strated

Reports
Directory
Phone Book

The rest is the same a basic database

What im wanting to do on the form contact list is search for a year like
type in 1999 in the search box and it pulls any data about 1999 in the
Field
called years.

Right now the search is only for a last name or a first name


"Jeff Boyce" wrote:

If your database is named "2007 Contact Database", you have a potential
issue already. That name implies that there's a "2008 Contact Database",
and that there'll need to be a "2009 Contact Database".

While this is a very 'spreadsheetly' approach, it is unnecessary and
counter-productive to do in MS Access. Instead, use a single database.
And
if your records include a field for Date/Time, you won't even need an
additional field for [YearOfContact]!

It all starts with the data ... and you haven't described yours yet.

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Sla13jc" <Sla13jc@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3ECA6EF6-2759-4D6B-BC61-97D0E1593102@xxxxxxxxxxxxxxxx
I have a 2007 Contact Database that i can search for first and last
name. I
was wondering if there is a way i can search for a year they were in
the
play
and what role they where in.

I have a field for the year, and a field for the role they where in

Help!!!





.

Relevant Pages

  • Re: duplicating database on 2nd dataset
    ... Why would your "second" database not need the same tables as ... Microsoft Office/Access MVP ... reports and queries), but insert new underlying tables - where the data is ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Is this possible??
    ... "Jeff Boyce" wrote: ... all those disparate data sources would have to share common ... Microsoft Office/Access MVP ... a database that they can click on a client's ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Is this possible??
    ... all those disparate data sources would have to share common ... Microsoft Office/Access MVP ... "Jeff Boyce" wrote: ... a database that they can click on a client's ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Copying the last record to a new record
    ... We could append this recordset as mytimestamp) to the database, sort the record source by mytimestamp descand move to the first record - that would get us to a copy of the last record as our new record. ... "Jeff Boyce" wrote: ... you're treating it as if it were a spreadsheet, ... >> Microsoft Office/Access MVP ...
    (microsoft.public.access.macros)
  • Re: Which the best option ?
    ... set up the tables so that there is something in common between the ... You have to tell the database ... "Jeff Boyce" wrote: ... Microsoft Office/Access MVP ...
    (microsoft.public.access.tablesdbdesign)