parameter

  • Thread starter Thread starter Foster1
  • Start date Start date
F

Foster1

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
 
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.
 
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
Click to expand...

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.
 
Foster1 said:
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
Click to expand...
 
Back
Top