SEARCH BOX HELP NEEDED
in [Getting Started]
|
Prev: Main form with subform refinement
Next: ESPA�A
From: jerseygirl54 on 26 Jun 2008 19:12 I have created a Training Roster db in Access 2007. This roster is where we can enter class titles, dates and who attended specific classes in addition to a column for Pass/Fail for Range. On the class subform (Officer list) you can double click on the officer's name and it will open a form on the officer that lists all classes he has attended. I would like to have a button on the switchboard that allows someone to search for a specific officer by last name. Once found you would be able to open up his his form that lists classes he has attended (same form as indicated in first paragraph). I am VERY new and need VERY simple instructions. Any help you can offer is GREATLY appreciated! :-)
From: bhicks11 via AccessMonster.com on 26 Jun 2008 20:31 Here's the gist of what I think you are looking for: Make a form with a combobox - set the data source to Query/Table and in the record source set up your query for the officer. In the OnExit event of that combobox, open whatever form you want that shows the officers info and filter it on the value of the combobox. So filter it something like: =forms! selectform.combobox. That's the rough sketch but get into it and come back with questions. Bonnie http://www.dataplus-svc.com jerseygirl54 wrote: >I have created a Training Roster db in Access 2007. This roster is where we >can enter class titles, dates and who attended specific classes in addition >to a column for Pass/Fail for Range. On the class subform (Officer list) you >can double click on the officer's name and it will open a form on the officer >that lists all classes he has attended. > >I would like to have a button on the switchboard that allows someone to >search for a specific officer by last name. Once found you would be able to >open up his his form that lists classes he has attended (same form as >indicated in first paragraph). > >I am VERY new and need VERY simple instructions. >Any help you can offer is GREATLY appreciated! :-) -- Message posted via http://www.accessmonster.com
From: jerseygirl54 on 26 Jun 2008 23:51 Yes, this seems to be what I am seeking, but I really don't understand your directions. I created a form with the combo box, set the source to Table/Query for the Officer (Student table). I don't understand the rest of the directions. I want to enter the beginning characters of the name select the name then upon "Enter" open that Student's (Officer's) individual form. I don't know what is the "filter", where to put place it etc. Does it belong on the form with the combo box ? Is it a macro? Is it an Expression? Sorry for all the questions, but I'm lost. I've been playing around with this and not getting anywhere. Thanks! :-) "bhicks11 via AccessMonster.com" wrote: > Here's the gist of what I think you are looking for: > > Make a form with a combobox - set the data source to Query/Table and in the > record source set up your query for the officer. In the OnExit event of that > combobox, open whatever form you want that shows the officers info and filter > it on the value of the combobox. So filter it something like: =forms! > selectform.combobox. That's the rough sketch but get into it and come back > with questions. > > Bonnie > > http://www.dataplus-svc.com > > > > jerseygirl54 wrote: > >I have created a Training Roster db in Access 2007. This roster is where we > >can enter class titles, dates and who attended specific classes in addition > >to a column for Pass/Fail for Range. On the class subform (Officer list) you > >can double click on the officer's name and it will open a form on the officer > >that lists all classes he has attended. > > > >I would like to have a button on the switchboard that allows someone to > >search for a specific officer by last name. Once found you would be able to > >open up his his form that lists classes he has attended (same form as > >indicated in first paragraph). > > > >I am VERY new and need VERY simple instructions. > >Any help you can offer is GREATLY appreciated! :-) > > -- > Message posted via http://www.accessmonster.com > >
From: bhicks11 via AccessMonster.com on 27 Jun 2008 06:54 That's a good start JerseyGirl. By the way, I have a friend we call a JerseyGirl - not everyone gets the joke. Did you click on the ... in the Record Source property and set up your Query? This will define what the user sees and selects. After you have done this, make sure the combobox shows what you expect. NOTE: if the table has a unique ID field or autonum type field, make it the first column in the query, the officer name the second column and then go to the Format tab of properties and set the number of columns that you have set up and set the widths with the first column 0 so you don't see it. So if you have 2 columns, set the width to 0, 1. Get this done and come back. Bonnie http://www.dataplus-svc.com jerseygirl54 wrote: >Yes, this seems to be what I am seeking, but I really don't understand your >directions. I created a form with the combo box, set the source to >Table/Query for the Officer (Student table). I don't understand the rest of >the directions. I want to enter the beginning characters of the name select >the name then upon "Enter" open that Student's (Officer's) individual form. >I don't know what is the "filter", where to put place it etc. Does it belong >on the form with the combo box ? Is it a macro? Is it an Expression? > >Sorry for all the questions, but I'm lost. I've been playing around with >this and not getting anywhere. > >Thanks! :-) > >> Here's the gist of what I think you are looking for: >> >[quoted text clipped - 22 lines] >> >I am VERY new and need VERY simple instructions. >> >Any help you can offer is GREATLY appreciated! :-) -- Message posted via http://www.accessmonster.com
From: jerseygirl54 on 27 Jun 2008 09:38
Got it to work, but no matter what name is choosen, clicking always results in opening up the "Student" form to the first record. "bhicks11 via AccessMonster.com" wrote: > That's a good start JerseyGirl. By the way, I have a friend we call a > JerseyGirl - not everyone gets the joke. > > Did you click on the ... in the Record Source property and set up your Query? > This will define what the user sees and selects. After you have done this, > make sure the combobox shows what you expect. NOTE: if the table has a > unique ID field or autonum type field, make it the first column in the query, > the officer name the second column and then go to the Format tab of > properties and set the number of columns that you have set up and set the > widths with the first column 0 so you don't see it. So if you have 2 columns, > set the width to 0, 1. > > Get this done and come back. > > Bonnie > http://www.dataplus-svc.com > > > > > jerseygirl54 wrote: > >Yes, this seems to be what I am seeking, but I really don't understand your > >directions. I created a form with the combo box, set the source to > >Table/Query for the Officer (Student table). I don't understand the rest of > >the directions. I want to enter the beginning characters of the name select > >the name then upon "Enter" open that Student's (Officer's) individual form. > >I don't know what is the "filter", where to put place it etc. Does it belong > >on the form with the combo box ? Is it a macro? Is it an Expression? > > > >Sorry for all the questions, but I'm lost. I've been playing around with > >this and not getting anywhere. > > > >Thanks! :-) > > > >> Here's the gist of what I think you are looking for: > >> > >[quoted text clipped - 22 lines] > >> >I am VERY new and need VERY simple instructions. > >> >Any help you can offer is GREATLY appreciated! :-) > > -- > Message posted via http://www.accessmonster.com > > |