C
CharlieBoces
I have some limited experience with Access, and not much experience at
all with scripting etc. I have created a database of school district
contacts that is organized into 3 tables. Districts, Contacts, and
Buildings.
The Contacts and Buildings tables have a many to one relationship with the
Districts table. I want to create a fast, easy way of accessing this
information (there is no need for most of the people who will be using this
to make additions edits etc.). I created a from with subforms and it works
great, but I would like to be able to have search this data without having to
open Access.
I created a grouped Data Access Page that will pull up the subordiate
tables when I use the navigation buttons to go through the records in the
Districts table (which arent in alphbetical order???). When I add controls
such as combo boxes, etc, nothing happens when I try to use them.
I looked up several tutorials on the net, and either they are very vague,
assume an expertise in scripting, or just dont work. What I would
ultimatley like to do is create a Search box that could find a record in any
of my tables, and bring up the appropriate records in the data access page.
ex.
if someone types a Contact name into the search box, it finds that
contact in the contact table, and brings up that persons information in the
contacts Group, the district that they belong to in the districts Group, and
the buildings of that district in the buildings Group.
I would also like this to happen if a person types in a contact's phone
number, a district name, a building name, etc. etc.
Is this possible?
If so can someone explain it to me in something close to plain english and
not gloss over steps that might seem trivial or obvious?
all with scripting etc. I have created a database of school district
contacts that is organized into 3 tables. Districts, Contacts, and
Buildings.
The Contacts and Buildings tables have a many to one relationship with the
Districts table. I want to create a fast, easy way of accessing this
information (there is no need for most of the people who will be using this
to make additions edits etc.). I created a from with subforms and it works
great, but I would like to be able to have search this data without having to
open Access.
I created a grouped Data Access Page that will pull up the subordiate
tables when I use the navigation buttons to go through the records in the
Districts table (which arent in alphbetical order???). When I add controls
such as combo boxes, etc, nothing happens when I try to use them.
I looked up several tutorials on the net, and either they are very vague,
assume an expertise in scripting, or just dont work. What I would
ultimatley like to do is create a Search box that could find a record in any
of my tables, and bring up the appropriate records in the data access page.
ex.
if someone types a Contact name into the search box, it finds that
contact in the contact table, and brings up that persons information in the
contacts Group, the district that they belong to in the districts Group, and
the buildings of that district in the buildings Group.
I would also like this to happen if a person types in a contact's phone
number, a district name, a building name, etc. etc.
Is this possible?
If so can someone explain it to me in something close to plain english and
not gloss over steps that might seem trivial or obvious?