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
|
|||
|
|||
parameter
I have a data base for an Homeowners. Lots of unusual names. How can I
place something on the data base itself to allow someone to click on 'say a first letter of a last name' and those names pop up. Hopefully I could include the ID number so they could then look up the name with the full information. I have a query and placed it on the data base but when I try to look up a name it works but then I can't close it out to enable me to look up another name. I am not a progrramer so just know enough to get by. Is there anything simple that I can do? Foster1 |
#2
|
|||
|
|||
parameter
Access uses tables to store data, Forms to display, add/edit, Queries to
look it up, and Reports to print it out. It all starts with the data. Please describe your data (i.e., table) structure. What tables are you using? What fields are in those tables. "How" depends on "what". Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Foster1" wrote in message ... I have a data base for an Homeowners. Lots of unusual names. How can I place something on the data base itself to allow someone to click on 'say a first letter of a last name' and those names pop up. Hopefully I could include the ID number so they could then look up the name with the full information. I have a query and placed it on the data base but when I try to look up a name it works but then I can't close it out to enable me to look up another name. I am not a progrramer so just know enough to get by. Is there anything simple that I can do? Foster1 |
#3
|
|||
|
|||
parameter
On Fri, 5 Mar 2010 14:16:06 -0800, Foster1
wrote: I have a data base for an Homeowners. Lots of unusual names. How can I place something on the data base itself to allow someone to click on 'say a first letter of a last name' and those names pop up. Hopefully I could include the ID number so they could then look up the name with the full information. I have a query and placed it on the data base but when I try to look up a name it works but then I can't close it out to enable me to look up another name. I am not a progrramer so just know enough to get by. Is there anything simple that I can do? Foster1 You should not be working in the table directly; tables are for data storage,and are very limited when it comes to data editing or viewing. Instead use a Form based on the table. You can put a "Combo Box" on the form to look up a name; combo boxes have an autocomplete feature, so if you type the first letter of a name it will jump to the first row starting with that letter, and so on. You can use the Toolbox "combo box wizard" to create a combo - use the "Use this combo to look up a record" option. -- John W. Vinson [MVP] |
#4
|
|||
|
|||
parameter
"Foster1" wrote in message ... I have a data base for an Homeowners. Lots of unusual names. How can I place something on the data base itself to allow someone to click on 'say a first letter of a last name' and those names pop up. Hopefully I could include the ID number so they could then look up the name with the full information. I have a query and placed it on the data base but when I try to look up a name it works but then I can't close it out to enable me to look up another name. I am not a progrramer so just know enough to get by. Is there anything simple that I can do? Foster1 |
Thread Tools | |
Display Modes | |
|
|