hi all

I am facing a problem regarding tables and forms and pages.
my supervisor gave me a table by joining 2 tables. now she told me to make a search button or smething like this so that she can search which all the names starting from that letter.
i have made a query but i dnt know how to present that query where n what are the forms and pages used for.

please can anyone help me out in this,

Thanks in advance to all.

Go to the form wizard. Use the "table" your boss gave you as the basis for the form or your own query. Move the controls around the way you like them and change the text on the labels to read "pretty".

Teach your boss how to right click on a field she wants to filter on. In the menu that pops up, she should put her criteria into the "Filter For:" field. If she wants all records that have a value in that field that start with the letter "A", she would type: "A*" in the Filter For: field and press enter. That will filter the overall results set. She can use the navigation buttons that automatically come with wizard created forms to go from one record to the next.

Does that help?

Go to the form wizard. Use the "table" your boss gave you as the basis for the form or your own query. Move the controls around the way you like them and change the text on the labels to read "pretty".

Teach your boss how to right click on a field she wants to filter on. In the menu that pops up, she should put her criteria into the "Filter For:" field. If she wants all records that have a value in that field that start with the letter "A", she would type: "A*" in the Filter For: field and press enter. That will filter the overall results set. She can use the navigation buttons that automatically come with wizard created forms to go from one record to the next.

Does that help?

yeah thanks it helped a lil bit but when i right click and when i put the value "A*" in 'filter for' field it is not showing me all the values it gives me the total no of result like there are 1878 result by the letter A.
if u could help me more on this. it would be really greatful to u.

thanks again

Do you mind posting your database so I can take a look? If not, how about a screen shot showing what you mean?

perhaps the supervisor didnt join the tables properly!

perhaps the supervisor didnt join the tables properly!

i dont know that about the tables but i cannot show u the tables publically. Just help me understand if i put letter A in the 'filter for' u mean it has to show all the results by that letter ot just the total # of results.

Thanks.

Do you mind posting your database so I can take a look? If not, how about a screen shot showing what you mean?

I can tell u all the column names so that u will get an idea what am i trying to saying u.
columns are: ID, orgID, orgaltnamesID, orgnames, oldID, orgtypeID, altid.

now she wants me to make a keyword search button where we can fetch the data with a particular alphabet or if we put ID.

Thanks.

i dont know that about the tables but i cannot show u the tables publically. Just help me understand if i put letter A in the 'filter for' u mean it has to show all the results by that letter ot just the total # of results.

Thanks.

I think when you filter in the table it would show you all the entries where the names start with "A".. Just a suggestion: would a query help?