Jeff Boyce said: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 said: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!!!
Sla13jc said: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 said: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 said: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!!!
Jeff Boyce said: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 said: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 said: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
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!!!
Sla13jc said:in the tables it has the first name field and last name field then what
year
they where in the performance that is a number field, then a role field
that
is a text format, email, address, phone numbers, etc...
the field that i have all the dates is "year". what im wanting to do is
just
type in a year on the search box and it have all the names that performed
in
that year
becuase now i can type in smith and get everything ones last name that's
smith and their first name.
Jeff Boyce said: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 said: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
:
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
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!!!
Jeff Boyce said:Are you trying to do this using a query? That's the tool Access offers.
Regards
Jeff Boyce
Microsoft Office/Access MVP
Sla13jc said:in the tables it has the first name field and last name field then what
year
they where in the performance that is a number field, then a role field
that
is a text format, email, address, phone numbers, etc...
the field that i have all the dates is "year". what im wanting to do is
just
type in a year on the search box and it have all the names that performed
in
that year
becuase now i can type in smith and get everything ones last name that's
smith and their first name.
Jeff Boyce said: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
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
:
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
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!!!
Sla13jc said:no in a form
"What im wanting to do on the form contact list is search for a year
Jeff Boyce said:Are you trying to do this using a query? That's the tool Access offers.
Regards
Jeff Boyce
Microsoft Office/Access MVP
Sla13jc said:in the tables it has the first name field and last name field then what
year
they where in the performance that is a number field, then a role field
that
is a text format, email, address, phone numbers, etc...
the field that i have all the dates is "year". what im wanting to do is
just
type in a year on the search box and it have all the names that
performed
in
that year
becuase now i can type in smith and get everything ones last name
that's
smith and their first name.
:
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
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
:
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
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!!!