If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using Form to Lookup/Search a Table
I'm looking to see if someone can point me to either the Access Help pages or
another location which will describe how to use a Form and Subform to look up a type in a specific value into a field and have it look up that information (such as running a query would) but display it into a subform. Thanks Jeffrey Wilson |
#2
|
|||
|
|||
Using Form to Lookup/Search a Table
I little more information, which I hope will help:
I have a table holding information for rental items (roll-off bins). When a bin goes on rent, its number is entered along with date it goes out on rent, date it comes back, and location. What I'm wanting to do is create a form which will allow me to search for a specific bin number, then display bin information (in a subform I'm thinking would be best) allowing someone to see all entries for that particular bin. As I've been reading the help pages, I'm getting the impression a query would be best to find the information, but I'm uncertain how to have the form to run the query and then show the data for just that bin number query into the form. It's frustrating because I feel like I'm close to the answer but am missing something. "Jeffrey Wilson" wrote: I'm looking to see if someone can point me to either the Access Help pages or another location which will describe how to use a Form and Subform to look up a type in a specific value into a field and have it look up that information (such as running a query would) but display it into a subform. Thanks Jeffrey Wilson |
#3
|
|||
|
|||
Using Form to Lookup/Search a Table
You can use the combo wizard to create this type of thing.
Put a combo in the main form's header. When the wizard asks what you want to do, choose the option that lets you find a matching record in the form. So when setup, the combo will show you the bin number and after you select the bin, it will filter the form to show only that record. Your subform will have its link master and link child fields set to the Primary key of the bin table, which will be the foreign key in the table the subform's query is based on. Once you click the combo and choose a bin, the subform will show the records for that bin. I am assuming that you have a table where you save the entries for each bin. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "Jeffrey Wilson" wrote in message news I little more information, which I hope will help: I have a table holding information for rental items (roll-off bins). When a bin goes on rent, its number is entered along with date it goes out on rent, date it comes back, and location. What I'm wanting to do is create a form which will allow me to search for a specific bin number, then display bin information (in a subform I'm thinking would be best) allowing someone to see all entries for that particular bin. As I've been reading the help pages, I'm getting the impression a query would be best to find the information, but I'm uncertain how to have the form to run the query and then show the data for just that bin number query into the form. It's frustrating because I feel like I'm close to the answer but am missing something. "Jeffrey Wilson" wrote: I'm looking to see if someone can point me to either the Access Help pages or another location which will describe how to use a Form and Subform to look up a type in a specific value into a field and have it look up that information (such as running a query would) but display it into a subform. Thanks Jeffrey Wilson |
#4
|
|||
|
|||
Using Form to Lookup/Search a Table
Jeffrey,
This may not be what you’re looking for, apologies in advance if it’s not, but you may also want to take a look at Allen Browne’s search form. It’s very flexible and allows you to search a number of ways. He also has a calendar control that I‘ve added on my search form, next to his date text box that is very easy to use. Users can then search for a particular date or date range to see the rental bin information or other information you want to know (such as your locations). I don’t know if this is something you need, but it’s available just in case. Here are the links: Search form- http://allenbrowne.com/ser-62.html Popup calendar- http://allenbrowne.com/ser-51.html I hope this helps. -- Aria W. "Jeffrey Wilson" wrote: I little more information, which I hope will help: I have a table holding information for rental items (roll-off bins). When a bin goes on rent, its number is entered along with date it goes out on rent, date it comes back, and location. What I'm wanting to do is create a form which will allow me to search for a specific bin number, then display bin information (in a subform I'm thinking would be best) allowing someone to see all entries for that particular bin. As I've been reading the help pages, I'm getting the impression a query would be best to find the information, but I'm uncertain how to have the form to run the query and then show the data for just that bin number query into the form. It's frustrating because I feel like I'm close to the answer but am missing something. "Jeffrey Wilson" wrote: I'm looking to see if someone can point me to either the Access Help pages or another location which will describe how to use a Form and Subform to look up a type in a specific value into a field and have it look up that information (such as running a query would) but display it into a subform. Thanks Jeffrey Wilson |
#5
|
|||
|
|||
Using Form to Lookup/Search a Table
I sent this post 24 hours ago, but I notice it never showed up here.
You can use the combo wizard to create this type of thing. Put a combo in the main form's header. When the wizard asks what you want to do, choose the option that lets you find a matching record in the form. So when setup, the combo will show you the bin number and after you select the bin, it will filter the form to show only that record. Your subform will have its link master and link child fields set to the Primary key of the bin table, which will be the foreign key in the table the subform's query is based on. Once you click the combo and choose a bin, the subform will show the records for that bin. I am assuming that you have a table where you save the entries for each bin. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "Jeffrey Wilson" wrote in message news I little more information, which I hope will help: I have a table holding information for rental items (roll-off bins). When a bin goes on rent, its number is entered along with date it goes out on rent, date it comes back, and location. What I'm wanting to do is create a form which will allow me to search for a specific bin number, then display bin information (in a subform I'm thinking would be best) allowing someone to see all entries for that particular bin. As I've been reading the help pages, I'm getting the impression a query would be best to find the information, but I'm uncertain how to have the form to run the query and then show the data for just that bin number query into the form. It's frustrating because I feel like I'm close to the answer but am missing something. "Jeffrey Wilson" wrote: I'm looking to see if someone can point me to either the Access Help pages or another location which will describe how to use a Form and Subform to look up a type in a specific value into a field and have it look up that information (such as running a query would) but display it into a subform. Thanks Jeffrey Wilson |
#6
|
|||
|
|||
Using Form to Lookup/Search a Table
Aria -
Thank you, that is definitely more than what I was looking for but is excellent information and after reading over that page will be the route to go. It definitely offers more flexibility to search more fields than I anticipated and I believe will be helpful to others using the database. Jeffrey Wilson "Aria" wrote: Jeffrey, This may not be what you’re looking for, apologies in advance if it’s not, but you may also want to take a look at Allen Browne’s search form. It’s very flexible and allows you to search a number of ways. He also has a calendar control that I‘ve added on my search form, next to his date text box that is very easy to use. Users can then search for a particular date or date range to see the rental bin information or other information you want to know (such as your locations). I don’t know if this is something you need, but it’s available just in case. Here are the links: Search form- http://allenbrowne.com/ser-62.html Popup calendar- http://allenbrowne.com/ser-51.html I hope this helps. -- Aria W. "Jeffrey Wilson" wrote: I little more information, which I hope will help: I have a table holding information for rental items (roll-off bins). When a bin goes on rent, its number is entered along with date it goes out on rent, date it comes back, and location. What I'm wanting to do is create a form which will allow me to search for a specific bin number, then display bin information (in a subform I'm thinking would be best) allowing someone to see all entries for that particular bin. As I've been reading the help pages, I'm getting the impression a query would be best to find the information, but I'm uncertain how to have the form to run the query and then show the data for just that bin number query into the form. It's frustrating because I feel like I'm close to the answer but am missing something. "Jeffrey Wilson" wrote: I'm looking to see if someone can point me to either the Access Help pages or another location which will describe how to use a Form and Subform to look up a type in a specific value into a field and have it look up that information (such as running a query would) but display it into a subform. Thanks Jeffrey Wilson |
#7
|
|||
|
|||
Using Form to Lookup/Search a Table
Jeanette -
Thank you for your input. This is great information and defnitely a way I can go. I hadn't thought the combo cox would work but after reading another link posted in this thread, I see it definitely is what I needed. Thank you again Jeffrey Wilson "Jeanette Cunningham" wrote: I sent this post 24 hours ago, but I notice it never showed up here. You can use the combo wizard to create this type of thing. Put a combo in the main form's header. When the wizard asks what you want to do, choose the option that lets you find a matching record in the form. So when setup, the combo will show you the bin number and after you select the bin, it will filter the form to show only that record. Your subform will have its link master and link child fields set to the Primary key of the bin table, which will be the foreign key in the table the subform's query is based on. Once you click the combo and choose a bin, the subform will show the records for that bin. I am assuming that you have a table where you save the entries for each bin. Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "Jeffrey Wilson" wrote in message news I little more information, which I hope will help: I have a table holding information for rental items (roll-off bins). When a bin goes on rent, its number is entered along with date it goes out on rent, date it comes back, and location. What I'm wanting to do is create a form which will allow me to search for a specific bin number, then display bin information (in a subform I'm thinking would be best) allowing someone to see all entries for that particular bin. As I've been reading the help pages, I'm getting the impression a query would be best to find the information, but I'm uncertain how to have the form to run the query and then show the data for just that bin number query into the form. It's frustrating because I feel like I'm close to the answer but am missing something. "Jeffrey Wilson" wrote: I'm looking to see if someone can point me to either the Access Help pages or another location which will describe how to use a Form and Subform to look up a type in a specific value into a field and have it look up that information (such as running a query would) but display it into a subform. Thanks Jeffrey Wilson . |
#8
|
|||
|
|||
Using Form to Lookup/Search a Table
Hi Jeffrey,
You’re very welcome. I only offered it as a suggestion because you mentioned locations, dates and bin numbers. I don’t know about you but I hate having to go back and re-do something I could have easily planned for in the beginning. -- Aria W. "Jeffrey Wilson" wrote: Aria - Thank you, that is definitely more than what I was looking for but is excellent information and after reading over that page will be the route to go. It definitely offers more flexibility to search more fields than I anticipated and I believe will be helpful to others using the database. Jeffrey Wilson "Aria" wrote: Jeffrey, This may not be what you’re looking for, apologies in advance if it’s not, but you may also want to take a look at Allen Browne’s search form. It’s very flexible and allows you to search a number of ways. He also has a calendar control that I‘ve added on my search form, next to his date text box that is very easy to use. Users can then search for a particular date or date range to see the rental bin information or other information you want to know (such as your locations). I don’t know if this is something you need, but it’s available just in case. Here are the links: Search form- http://allenbrowne.com/ser-62.html Popup calendar- http://allenbrowne.com/ser-51.html I hope this helps. -- Aria W. "Jeffrey Wilson" wrote: I little more information, which I hope will help: I have a table holding information for rental items (roll-off bins). When a bin goes on rent, its number is entered along with date it goes out on rent, date it comes back, and location. What I'm wanting to do is create a form which will allow me to search for a specific bin number, then display bin information (in a subform I'm thinking would be best) allowing someone to see all entries for that particular bin. As I've been reading the help pages, I'm getting the impression a query would be best to find the information, but I'm uncertain how to have the form to run the query and then show the data for just that bin number query into the form. It's frustrating because I feel like I'm close to the answer but am missing something. "Jeffrey Wilson" wrote: I'm looking to see if someone can point me to either the Access Help pages or another location which will describe how to use a Form and Subform to look up a type in a specific value into a field and have it look up that information (such as running a query would) but display it into a subform. Thanks Jeffrey Wilson |
Thread Tools | |
Display Modes | |
|
|